You need to create a referenced dimension that allows you to browse the measures of the FactSales table by using the DimGeography dimension

You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server
2008.
You create the dimensions as shown in the following table.

The CustKey attribute is used as a column in a table named FactSales.
You need to create a referenced dimension that allows you to browse the measures of the
FactSales table by using the DimGeography dimension.
What should you do?

You create a SQL Server 2008 Analysis Services (SSAS) solution by using SQL Server
2008.
You create the dimensions as shown in the following table.

The CustKey attribute is used as a column in a table named FactSales.
You need to create a referenced dimension that allows you to browse the measures of the
FactSales table by using the DimGeography dimension.
What should you do?

A.
Set the reference dimension to DimGeography by using a referenced dimension attribute
as GeoKey and an intermediate dimension attribute as CustKey.

B.
Set the reference dimension to DimGeography by using a referenced dimension attribute
as GeoKey and an intermediate dimension attribute as GeoKey.

C.
Set the reference dimension to DimCustomer by using a referenced dimension attribute
as CustKey and an intermediate dimension attribute as GeoKey.

D.
Set the reference dimension to DimCustomer by using a referenced dimension attribute
as GeoKey and an intermediate dimension attribute as GeoKey.



Leave a Reply 0

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