You are developing a SQL Server 2008 Analysis Services (SSAS) method for
Company.com.
There is a dimension called DimProductTester which includes a property called PriceTester.
You should make sure that aggregations could not link to the Price property.
Which is the correct answer?
A.
You should configure the IsAggregatable attribute of the PriceTester attribute to True.
B.
You should configure the AttributeHierarchyEnabled attribute of the PriceTester attribute
to False.
C.
You should configure the MembersWithData attribute of the PriceTester attribute to
LeafDataHidden.
D.
You should configure the MembersWithOutData attribute of the PriceTester attribute to
LeafDataHidden.
Explanation:
AttributeHierarchyEnabled Determines whether the attribute is enabled as a hierarchy; this
must be True if the attribute will be used in a multilevel hierarchy