You create a SQL Server 2008 Analysis Services (SSAS) solution. You have a table named
Orders that contains the following columns:
• OrderKey
• Shipper
• OrderAmount
You create a dimension named DimOrders from the Orders table. You set the OrderKey as a
key column and the Shipper column as an attribute. You create a measure group named
FactOrders from the Orders table.
You need to create a dimension relationship to ensure that the OrderAmount column can be
aggregated by the Shipper column.
What should you do?
A.
Set the relationship between the DimOrders dimension and the FactOrders measure
group to No Relationship.
B.
Create a fact dimension relationship between the DimOrders dimension and the
FactOrders measure group.
C.
Create a regular dimension relationship between the DimOrders dimension and the
FactOrders measure group. Set the Granularity attribute to Shipper and the measure group
columns to OrderAmount.
D.
Create a regular dimension relationship between the DimOrders dimension and the
FactOrders measure group. Set the Granularity attribute to OrderKey and the measure
group columns to OrderAmount.