You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named DimCustomer that contains the following three attributes:
Customer
City
Country
The Customer attribute is the key. The DimCustomer dimension is related to a measure
group
named Sales that has the Granularity property set to City.
You need to ensure that you can retrieve measure values based on the City and Country
attributes.
What should you do?
A.
Set the source attribute to Customer and the related attribute to City.Set the source
attribute to City and the related attribute to Country.
B.
Set the source attribute to City and the related attribute to Customer.Set the source
attribute to Country and the related attribute to City.
C.
Set the source attribute to Customer and the related attribute to City.Set the source
attribute to Customer and the related attribute to Country.
D.
Set the source attribute to City and the related attribute to Customer.Set the source
attribute to Country and the related attribute to Customer.