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 ProductID.

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 ProductID.

Quizplus · Accepted Answer

The PRODUCT dimension includes the ProductID and ProductBrandID columns, allowing users to drill down from ProductBrandID to ProductID through an OLAP query.

GENERIC RETAILER Observe the ER Diagram for the Generic Retailer