You need to ensure that aggregations are not associated with the Price attribute

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?

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?

A.
Set the IsAggregatable property of the Price attribute to False.

B.
Set the AttributeHierarchyEnabled property of the Price attribute to False.

C.
Set the MembersWithData property of the Price attribute to NonLeafDataHidden.

D.
Set the GroupingBehavior property of the Price attribute to DiscourageGrouping.



Leave a Reply 0

Your email address will not be published. Required fields are marked *