You are managing a SQL Server 2008 Analysis Services (SSAS) method which includes a dimension called TimeTester for Company.com.
There is a table called SalesTester which includes the two columns named OrderTester and ShipTester.
they are connected with TimeTester.
You should make sure that you could get information by measures using the DimTime TimeTester. Which is the correct answer?
A.
You should develop a one-to-many relationship between the TimeTester dimension and the OrderTester measure group.
B.
You should develop a many-to-one relationship between the ShipTester dimension and the SalesTester measure group.
C.
You should develop a many-to-many relationship between the TimeTester dimension and the ShipTester measure group.
D.
You should develop two common relationships between the TimeTester dimension and the SalesTester measure group. You should not utilize same columns of measure group.