Which relationship type should you choose?

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.

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.

Answer:



Leave a Reply 5

Your email address will not be published. Required fields are marked *


sani

sani

Should’nt this be Referenced relation? can someone plz advise

Greg

Greg

Nope, many-to-many is correct..

HR_OS_B

HR_OS_B

True, here one customer can have more than one accounts and one account can have more than one customers.

Mahmoud Ibrahim

Mahmoud Ibrahim

how can the account have more than one customer?

Shadab Baig

Shadab Baig

it could be a joint account