You are designing a Microsoft SQL Server 2005 Analysis Services (SSAS) project.
You create a dimension named DimProducts that contains the following features:
An attribute named Categories.
A key attribute named Products that has a relationship to the Categories attribute.
A hierarchy that has the Categories attribute 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.
What should you do?
A.
In the hierarchy, change the HideMemberIf property of the Categories level to OnlyChildWithNoName.
B.
In the hierarchy, change the HideMemberIf property of the Products level to OnlyChildWithNoName.
C.
Change the UnKnownMember property of the DimProducts dimension to None.
D.
Change the UnKnownMember property of the DimProducts dimension to Hidden.