Database Reference
In-Depth Information
Figure 10-9.
Hiding attribute hierarchy
Now, in Microsoft Excel, the AuthorState and Authors attributes will no longer be displayed independently
of the AuthorState.
Not all client applications hide the individual attributes when this setting is applied. This may seem strange,
but because the attribute hierarchy is marked only as hidden, it is not deleted (Figure
10-10
). Since some software
does not check to see whether the property is set to True or False, the individual attribute may appear in some
reporting applications.
Figure 10-10.
Hidden attribute hierarchies are invisible to only some client applications
■
Although microsoft recommends hiding the attribute hierarchies after you have created a user-defined
hierarchy, it is not always in your best interest to do so. often, report builders want more options instead of less. we
configure the Authors dimension to hide the Authors attribute in the next exercise, and in Chapter
15
we demonstrate
the impact that this choice has in microsoft Excel.
Note
Now that the hierarchies are defined, let's configure them.
Configuring Hierarchies
Table
10-2
describes the most common properties for user-defined hierarchies.
