You are developing a SQL Server 2008 Analysis Services (SSAS) method for Company.com.
There is a dimension called TestProduct which includes the listed properties.
* Product
* City
* Country
The TestProduct dimension is connect with a measure group named Products which owns the Granularity attribute link to City.
It is a key for Product. You should make sure that you could search values according to the City and Country properties.
Which is the correct answer?
A.
You should configure the source property to Product and the connected property to City. And then configure the source property to City and the connected property to Country.
B.
You should configure the source property to Product and the connected property to City.
C.
You should modify the source property to Product and the connected property to City.
D.
You should delete the source property to Product and the connected property to City.