nerdexam
Microsoft

70-448 · Question #178

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…

The correct answer is B. You should configure the AttributeHierarchyEnabled attribute of the PriceTester attribute to False. AttributeHierarchyEnabled Determines whether the attribute is enabled as a hierarchy; this must be True if the attribute will be used in a multilevel hierarchy

Implement an Analysis Services Solution

Question

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?

Options

  • AYou should configure the IsAggregatable attribute of the PriceTester attribute to True.
  • BYou should configure the AttributeHierarchyEnabled attribute of the PriceTester attribute to False.
  • CYou should configure the MembersWithData attribute of the PriceTester attribute to LeafDataHidden.
  • DYou should configure the MembersWithOutData attribute of the PriceTester attribute to LeafDataHidden.

How the community answered

(19 responses)
  • A
    5% (1)
  • B
    79% (15)
  • C
    5% (1)
  • D
    11% (2)

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

Topics

#attribute hierarchy#dimension properties#AttributeHierarchyEnabled#SSAS dimensions

Community Discussion

No community discussion yet for this question.

Full 70-448 Practice