PrepAway - Latest Free Exam Questions & Answers

Which three actions should you perform in sequence?

You are developing a SQL Server Analysis Services (SSAS) multidimensional project. The project
file includes two cubes named Finance and Operations. The project also includes a dimension
named Date. The Date dimension includes two hierarchies named Fiscal and Calendar. The Date
dimension has been added to both cubes.
You need to disable the Fiscal hierarchy in the Operations cube without impacting other database
objects.
Which three actions should you perform in sequence? (To answer, move the appropriate actions
from the list of actions to the answer area and arrange them in the correct order.)
Select and Place:

PrepAway - Latest Free Exam Questions & Answers

Answer:

Explanation:
Note:
* The value of the AttributeHierarchyEnabled property determines whether an attribute hierarchy is
created. If this property is set toFalse, 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 toTrue, the value of the
AttributeHierarchyVisible property determines whether the attribute hierarchy is visible
independent of its use in a user-defined hierarchy.
* To set the attribute hierarchy properties in the Employee dimension
Etc.

Hiding and Disabling Attribute Hierarchies


Leave a Reply