You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a cube that contains the following objects:
A time dimension named Time that has an attribute named TimeKey.
A fact table named FactOrders.
The Time dimension contains different hierarchies. Two of the columns of the fact table link to the attribute.
You need to view the measures for different hierarchies for both the columns in the fact table.
What should you do?
A.
Create a single dimension usage relationship between the Time dimension and the FactOrders fact table by defining a regular relationship.
B.
Create a single dimension usage relationship between the Time dimension and the FactOrders fact table by defining a many-to-many relationship.
C.
Create two dimension usage relationships between the Time dimension and the FactOrders fact table by defining a regular relationship for both the dimension usages.
D.
Create two dimension usage relationships between the Time dimension and the FactOrders fact table by defining a many-to-many relationship for both the dimension usages.