You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS)project.You create a
cube that has the following objects:
A dimension named ProductSubcategory that contains a table named DimProductSubcategory.A dimension named Product that contains a table named DimProduct.A fact table named FactInventory.
The relationship between the three tables is shown in the following exhibit. (Click the Exhibit button.)
You need to create a relationship on the Dimension Usage tab to browse through the data in theFactInventory table by using only the ProductSubcategory dimension.
What should you do?
A.
Create a fact relationship in the FactInventory table.
B.
Create a regular relationship between the ProductSubcategory dimension and the FactInventory table.
C.
Create a referenced relationship between the ProductSubcategory dimension and the FactInventory table.
D.
Create a many-to-many relationship between the ProductSubcategory dimension and the FactInventory table.