QUESTION 1
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.