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.