You are developing a Microsoft SQL Server 2005 Analysis Services (SSAS) project. The data source for a cube has tables as shown in the following exhibit. (Click the Exhibit button.)
The cube contains the following objects:
A dimension named DimAccounts that uses a table named Accounts.
A dimension named DimCustomers that uses a table named Customers.
A measure group named Transactions that uses a fact table named Transactions.
A measure group named Customer Accounts that uses a fact table named CustomerAccounts.
You need to create a cube dimension to browse through the measures in the Transactions fact table by using the DimCustomers dimension.
What should you do?
A.
Create a referenced relationship and set the intermediate dimension as DimAccounts.
B.
Create a referenced relationship and set the intermediate dimension as DimCustomers.
C.
Create a many-to-many relationship and set the intermediate measure group to Transactions.
D.
Create a many-to-many relationship and set the intermediate measure group to Customer Accounts.