Which relationship type should you choose?

HOTSPOT
You are developing a SQL Server Analysis Services (SSAS) cube. A dimension named
Category is based on the DimCategory table.
A subset of the data source view is shown in the following graphic.

You need to relate the Category dimension to the Sales 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
Category is based on the DimCategory table.
A subset of the data source view is shown in the following graphic.

You need to relate the Category dimension to the Sales measure group.
Which relationship type should you choose?
To answer, select the appropriate option from the drop-down list in the dialog box.

Answer:

Explanation:

Note:
Referenced Relationship
Link a dimension to a fact table indirectly through a dimension that is linked directly through
a primary key–foreign key relationship.



Leave a Reply 0

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