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?

Question

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?

Accepted Answer

B. Create a fact dimension relationship between the DimOrders dimension and the FactOrders

Answer

A. Set the relationship between the DimOrders dimension and the FactOrders measure group to

Answer

C. Create a regular dimension relationship between the DimOrders dimension and the FactOrders

Answer

D. Create a regular dimension relationship between the DimOrders dimension and the FactOrders

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…

Question

Options

How the community answered

Community Discussion