You create a SQL Server 2008 Analysis Services (SSAS) solution.
You create a dimension named Customer. The Customer dimension has the attributes
named Country and State.
The Country attribute has the following components:
The KeyColumn property is set to the country code.
The NameColumn property is set to the country name.
You create an attribute relation between the Country attribute and the State attribute.
You need to ensure that the state names are sorted first by the country name and then by
the state name.
What should you do?
A.
Set the OrderBy property to Name and the OrderByAttribute property to Country for the
State attribute.
B.
Set the OrderBy property to AttributeName and the OrderByAttribute property to Country
for the State attribute.
C.
Set the OrderBy property to Name for the Country attribute.
Set the OrderBy property to Key and the OrderByAttribute property to Country for the State
attribute.
D.
Set the OrderBy property to Name for the Country attribute.
Set the OrderBy property to AttributeKey and the OrderByAttribute property to Country for
the State attribute.