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.
Exhibit:
Hot Area:
Answer:
FactSales — DimProduct — DimCategory
Referenced