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