Microsoft
70-448 · Question #276
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named DimProduct that contains an attribute named Price. You use the DimProduct dimension in a cube. You need…
The correct answer is B. Set the AttributeHierarchyEnabled property of the Price attribute to False. See the full explanation below for the reasoning.
Question
You create a SQL Server 2008 Analysis Services (SSAS) solution. You create a dimension named DimProduct that contains an attribute named Price. You use the DimProduct dimension in a cube. You need to ensure that aggregations are not associated with the Price attribute. What should you do?
Options
- ASet the IsAggregatable property of the Price attribute to False.
- BSet the AttributeHierarchyEnabled property of the Price attribute to False.
- CSet the MembersWithData property of the Price attribute to NonLeafDataHidden.
- DSet the GroupingBehavior property of the Price attribute to DiscourageGrouping.
How the community answered
(31 responses)- A3% (1)
- B77% (24)
- C13% (4)
- D6% (2)
Community Discussion
No community discussion yet for this question.