70-448 · Question #181
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…
The correct answer is D. You should Change the UnKnownMember property of the DimProducts dimension to Hidden. See the full explanation below for the reasoning.
Question
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?
Options
- AIn the hierarchy, you should change the HideMemberIf property of the Categories level to
- BIn the hierarchy, you should change the HideMemberIf property of the Products level to
- CYou should Change the UnKnownMember property of the DimProducts dimension to none.
- DYou should Change the UnKnownMember property of the DimProducts dimension to Hidden.
How the community answered
(67 responses)- A7% (5)
- B18% (12)
- C3% (2)
- D72% (48)
Community Discussion
No community discussion yet for this question.