GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the Generic Retailer dimension PRODUCT)can drill down from ProductBrandID to ProductCategoryID.

Question

GENERIC RETAILER
Observe the ER diagram for the Generic Retailer:
  Assume that the dimension PRODUCT containing the following columns:
ProductKey (surrogate key)
ProductID
ProductDescription
ProductBrandID
ProductBrandName
ProductCategoryID
ProductCategoryName
is created for the Generic Retailer.This dimension will be used for the following questions citing Generic Retailer PRODUCT dimension.
-A user using an OLAP query (based on the dimensionally modeled data set that contains the Generic Retailer dimension PRODUCT)can drill down from ProductBrandID to ProductCategoryID.

Quizplus · Accepted Answer

In a dimensionally modeled dataset, drilling down typically moves from a higher-level, more generalized category to a more detailed or specific category. Therefore, one would drill down from ProductCategoryID to ProductBrandID, not the other way around.

GENERIC RETAILER Observe the ER Diagram for the Generic Retailer