You are managing a SQL Server 2008 Analysis Services (SSAS) project for Company.com.
Some object show below in the cube
* A time dimension named TimeDimension that has an attribute named TimeKiller.
* A fact table named FactOrdersTable.
Different hierarchies should be included in the Time dimension,
You should take method to do it
Which is the correct answer?
A.
You should design three dimension usage relationships between the Time dimension and the FactOrdersTable fact table.
B.
By defining a one-to-one relationship, you should design a single dimension usage relationship between the Time dimension and the FactOrdersTable fact table.
C.
By defining a regular relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table
D.
By defining a many-to-many relationship for both the dimension usages, you should design two dimension usage relationships between the Time dimension and the FactOrdersTable fact table