You have the data model shown in the exhibit. (Click the Exhibit tab.) You need to create a hierarchy from DimproductSubcategory[ProductSubcategoryName] and DimProduct[ProductName].
What should you do before you create the hierarchy?
A. Create a relationship between the tables. To DimProductSubcategory, add a calculated column named ProductName that uses the LOOKUPVALUE
(DimProduct[ProductName],DimProduct[ProductKey],[ProductKey]) DAX formula.
B. To DimProduct, add a calculated column named ProductSubcategoryName that uses the LOOKUPVALUE(DimProductSubcategory
[ProductSubcategoryName],DimProductSubcategory[ProductCategoryKey],[ProductSubcategoryKey]) DAX formula.
C. Create a relationship between the tables. To DimProduct, add a calculated column named ProductSubcategoryName that uses the RELATEDTABLE
(DimProductSubcategory[ProductSubcategoryName]) DAX formula.
D. To DimProduct, add a calculated column named ProductSubcategoryName that uses the VALUES(DimProductSubcategory[ProductSubcategoryName])
DAXformula.
