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.