• edited by
550 views

1 Answer

1 1 vote
Given Dimensions:

Time: Day $\rightarrow$ Month $\rightarrow$ Year  

Location: City $\rightarrow$ State $\rightarrow$ Country  

Product: Item $\rightarrow$ Item Type $\rightarrow$ Item Category  

Each dimension has 3 levels.

 

General Formula:

If there are $n$ dimensions and the $i^{th}$ dimension has $L_i$ levels, then the total number of possible cuboids are:

\[
\prod_{i=1}^{n} (L_i + 1)
\]

Here,

\[
L_1 = L_2 = L_3 = 3
\]

\[
\text{Total cuboids} = (3+1)(3+1)(3+1)
\]

\[
= 4^3 = 64
\]

\[
\boxed{\text{Total number of cuboids} = 64}
\]

Correct Option: (A)
• moved by
Answer:
Position:
Show:

Related questions

2 2 votes
1 1 answer
3.7k
3.7k views
go_editor asked Aug 8, 2016
3,670 views
____ system is market oriented and is used for data analysis by knowledge workers including Managers, Executives adn Analysts.OLTPOLAPData SystemMarket System
1 1 vote
1 1 answer
2.9k
2.9k views
Arjun asked Feb 27, 2025
2,940 views
Consider a fact table in an OLAP application: $\text{Facts (D1, D2, val)},$ where $\text{D1}$ and $\text{D2}$ are its dimension attributes and $\text{val}$ is a dependent...
1 1 vote
1 1 answer
468
468 views
gatecse asked Feb 23
468 views
Consider that the visualization of a $3$-dimensional data cube is showing Sales Quantity for each combination of the attributes Product Type, Month and Country.From this,...
1 1 vote
1 1 answer
438
438 views
GO Classes asked Feb 16
438 views
\[\begin{array}{ccc}\textbf{Time Hierarchy} & \textbf{Location Hierarchy} & \textbf{Product Hierarchy} \\\text{Year} & \text{Country} & \text{Item Category} \\\downarrow ...