Thursday, September 11, 2014

SSAS TUTORIAL : Hiding and disabling Attribute Heirarchies

In the tasks in this topic, you will disable social security numbers and other attributes in the Employee dimension that will not be used for browsing. You will then hide the customer name and postal code attribute hierarchies in the Customer dimension. The large number of attribute members in these hierarchies will make browsing these hierarchies very slow independent of a user hierarchy.


1.       Switch to Dimension Designer for the Employee dimension, and then click theBrowser tab.
2.       Verify that the following attribute hierarchies appear in the Hierarchy list:
o    Base Rate
o    Birth Date
o    Login ID
o    Manager SSN
o    SSN
3.       Switch to the Dimension Structure tab, and then select the following attributes in the Attributes pane. You can select multiple measures by clicking each while holding down the CTRL key:
o    Base Rate
o    Birth Date
o    Login ID
o    Manager SSN
o    SSN
4.       In the Properties window, set the value of the AttributeHierarchyEnabled property to False for the selected attributes.
Notice in the Attributes pane that the icon for each attribute has changed to indicate that the attribute is not enabled.
The following image shows the AttributeHierarchyEnabled property set to False for the selected attributes.
5.       On the Build menu, click Deploy Analysis Services Tutorial.
6.       When processing has successfully completed, switch to the Browser tab, clickReconnect, and then try to browse the modified attribute hierarchies.
Notice that the members of the modified attributes are not available for browsing as attribute hierarchies in the Hierarchy list. If you try to add one of the disabled attribute hierarchies as a level in a user hierarchy, you will receive an error notifying you that the attribute hierarchy must be enabled to participate in a user-defined hierarchy.


1.       Switch to Dimension Designer for the Customer dimension, and then click theBrowser tab.
2.       Verify that the following attribute hierarchies appear in the Hierarchy list:
o    Full Name
o    Postal Code
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:
o    Full Name
o    Postal Code
4.       In the Properties window, set the value of the AttributeHierarchyVisible property toFalse for the selected attributes.
Because the members of these attribute hierarchies will be used for dimensioning fact data, ordering and optimizing the members of these attribute hierarchies will improve performance. Therefore, the properties of these attributes should not be changed.
The following image shows the AttributeHierarchyVisible property set to False.
5.       Drag the Postal Code attribute from the Attributes pane into the Customer Geography user hierarchy in the Hierarchies and Levels pane, immediately under the City level.
Notice that a hidden attribute can still become a level in a user hierarchy.
6.       On the Build menu, click Deploy Analysis Services Tutorial.
7.       When deployment has successfully completed, switch to the Browser tab for the Customer dimension, and then click Reconnect.
8.       Try to select either of the modified attribute hierarchies from the Hierarchy list.
Notice that neither of the modified attribute hierarchies appears in the Hierarchylist.
9.       In the Hierarchy list, select Customer Geography, and then browse each level in the browser pane.

Notice that the hidden levels, Postal Code and Full Name, are visible in the user-defined hierarchy.

No comments:

Post a Comment