Question

This is a Datawarehousing - Data Mining - Cube Cuboids Question:

Consider a cube defined on the following dimension hierarchies:

{customer < customer_street < customer_city < customer_state}

{supplier < supplier_city < supplier_state}

{day < month < quarter < year}

{product < product_line < product_category}

The number of cuboids that contain the supplier and quarter attributes is:

(a) 96

(b) 12

(c) 20

(d) 144

What is the answer and why?

Answer 1

Please Upvote, If you are impressed with the answer.

If you have any doubt, you can comment.

Answer:

option B is correct - 12 cuboids

This is because, there are total 2^3 cuboids in supplier.

And there are 4 cuboids in quarter.

Therefore total 12 cuboids in supplier and quarter