You create a SQL Server 2008 Analysis Services (SSAS) solution. The cube structure is as
shown in the following exhibit. (Click the Exhibit button.)
You need to ensure that the Amount measure can be aggregated for the DimCustomer
dimension.
What should you do?
A.
Create a regular relationship between DimCustomer and FactTransaction.
B.
Create a referenced relationship between DimCustomer and FactCustomerAccount. Set
DimAccount as an intermediate dimension.
C.
Create a many-to-many relationship between DimCustomer and FactTransaction. Set
FactCustomerAccount as an intermediate measure group.
D.
Create a many-to-many relationship between DimCustomer and FactCustomerAccount.
Set FactTransaction as an intermediate measure group.