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.)

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.)

Answer:

Explanation:



Leave a Reply 3

Your email address will not be published. Required fields are marked *


Andres

Andres

Andres

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://www.linkedin.com/pulse/ssas-hiding-disabling-attribute-hierarchies-khanh-phung

Ba

Ba

I think the last should be Set Enabled property to false. The question is about disabling hierarchy in a cube not single attributes in a hierarchy