DRAG DROP
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: See the expalantion.
Explanation:
Note:
* The value of theAttributeHierarchyEnabledproperty 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 theAttributeHierarchyEnabledproperty is set
toTrue, the value of theAttributeHierarchyVisibleproperty 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
1. Switch to Dimension Designer for the Employee dimension, and then click the
Browser tab.
2. Verify that the following attribute hierarchies appear in the Hierarchy list:
• Base Rate
• Birth Date
• Login ID
• Manager SSN
• SSN
3. Switch to the Dimension Structure tab, and then select the following attributes in the
Attributes pane, by using the CTRL key to select multiple attributes at the same time:• Base Rate
• Birth Date
• Login ID
• Manager SSN
• SSN
4. In the Properties window, set the value of the AttributeHierarchyEnabled property to
False for the selected attributes.
Etc.
Reference: Hiding and Disabling Attribute Hierarchies
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00218.jpg
http://www.200-120exam.com/wp-content/uploads/2015/02/clip_image00424.jpg
Both anwsers (carlos and the suggested) are wrong.
There is no AttributeHierarchyEnabled” property for
user hierarchies. Just “Enabled” and this is the exact
property that we should set to “false” at last step.
“You need to disable…..”
1-Open the Operations cube in the cube designer
2-In the Dimensions pane of the Cube Structure tab, select the Fiscal hierarchy of the Date Dimension
3-In the Properties window, set the enabled property to False
100% correct
I don’t agree. Please take a look at: https://saysmymind.wordpress.com/2013/01/15/hide-a-specific-attribute-hierarchy-in-role-playing-dimension-ssas-multidimensional/
1. Open the Operations cube…
2. In the dimensions pane of the cube … select fiscal hierarchy
3. In the properties windows set attributeHierarchyEnabled property to false
https://saysmymind.files.wordpress.com/2013/01/hidingattributehierarchyroleplayingdimension.jpg
+1
answer is wrong you just have to test it . if you choose the attributeHierarchyEnabled you will only specify one attribute … the question says You need to disable the Fiscal hierarchy in the Operations cube without impacting other database objects.
Fabio is correct
1-Open the Operations cube in the cube designer
2-In the Dimensions pane of the Cube Structure tab, select the Fiscal hierarchy of the Date Dimension
3-In the Properties window, set the enabled property to False