You are building a Microsoft SQL Server Analysis Services multidimensional model over a SQL Server database. In a cube named OrderAnalysis, there is a standard cube dimension named Stock Item. This…

Question

Options

• ASet the AttributeHierarchyVisible property to False.
• BSet the AttributeHierarchyEnabledproperty to False.
• CSet the AttributeVisibility property to Hidden.
• DSet the Usage property to Regular.
• ESet the AttributeHierarchyDisplayFolder property to Hidden.

• A
  81% (34)
• B
  10% (4)
• C
  2% (1)
• D
  5% (2)
• E
  2% (1)

Explanation

The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is created. If this property is set to False, the attribute hierarchy is not created and the attribute cannot be used as a level in a user hierarchy; the attribute hierarchy exists as a member property only. However, a disabled attribute hierarchy can still be used to order the members of another attribute. If the value of the AttributeHierarchyEnabled property is set to True, the value of the AttributeHierarchyVisible property determines whether the attribute hierarchy is visible independent of its use in a user-defined hierarchy. https://technet.microsoft.com/en-us/library/ms166717(v=sql.110).aspx

No community discussion yet for this question.