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