Database Reference
In-Depth Information
In Figure
10-4
you can see that the DimAuthor's dimension contains the Author Key, Author Id, and Author
State attributes, renamed to Author, AuthorId, and AuthorState.
Figure 10-4.
The DimAuthors attributes
SSAS always provides a default, invisible hierarchy for each attribute consisting of two levels. In this default
design, each individual attribute of the dimension is considered a child attribute of an All attribute, as illustrated
in Figure
10-5
. The All level contains only one member called, well, All.
Figure 10-5.
The default attribute hierarchy
The All member forms the root-level value of the hierarchy. Once this is set, the All level represents the total
of all the members of a group (Figure
10-6
). It is simply a way of organizing information. Microsoft recommends
that you define user hierarchies when it makes sense to do so.