HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named
Customer is based on the DimCustomer table. A subset of the data source view is shown in
the following graphic.
You need to relate the Customer dimension to the AccountBalance measure group.
Which relationship type should you choose? To answer, select the appropriate option from
the drop-down list in the dialog box.
Should’nt this be Referenced relation? can someone plz advise
Nope, many-to-many is correct..
True, here one customer can have more than one accounts and one account can have more than one customers.
how can the account have more than one customer?
it could be a joint account