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