You are managing a SQL Server 2008 Analysis Services (SSAS) database for
Company.com.
There are three characters in a dimensionality called DProducts below:
* An attribute named Categories.
* A key attribute named Products that has a relationship to the Categories attribute.
* A hierarchy that has the Categories attributes on the first level and the Products attribute
on the second level.
When you browse through the dimension, it shows all the Products that do not have a
relationship to the Categories attribute.
The attribute is grouped under a Categories member named Unknown.
You need to ensure that only those products that have a relationship to the Categories
attribute are displayed.
Which is the correct answer below?
A.
In the hierarchy, you should change the HideMemberIf property of the Categories level to
OnlyChildWithNoName.
B.
In the hierarchy, you should change the HideMemberIf property of the Products level to
OnlyChildWithNoName.
C.
You should Change the UnKnownMember property of the DimProducts dimension to
none.
D.
You should Change the UnKnownMember property of the DimProducts dimension to
Hidden.