1209
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
53
property set to Key, whereas the manager ID attribute will be confi gured with a Usage
of Parent. Other important properties for confi guring a parent-child dimension include
the following:■ RootMemberIf: Used on the parent attribute to identify the top level. Values
include ParentIsBlank (null or zero), ParentIsSelf (parent and key values
are the same), ParentIsMissing (parent row not found). The default value is all
three, ParentIsBlankSelfOrMissing.
■ MembersWithData: As set on the parent attribute, this controls how nonleaf mem-
bers with data display. Under the default setting, NonLeafDataVisible, Analysis
Services repeat parent members at the leaf level to display their corresponding
data. This would be a situation in which the manager is also listed as an employee.
Sales for the employee will be included in the total but not in the details when set-
ting the property to NonLeafDataHidden.FIGURE 53-7
A self-referential table.After you confi gure the parent-child relationship, the parent attribute presents a multilevel
view of the data. All the other attributes of the dimension behave as normal.Dimension Refi nements
After you build a dimension, a large number of properties are available to refi ne its behav-
ior and that of its attributes. This section details some of the more common and less obvi-
ous refi nements possible.Hierarchy (All) Level and Default Member
The (All) level is added to the top of each hierarchy by default, and represents every mem-
ber in that hierarchy. At query time, the (All) level enables everything in a hierarchy to be
included, without listing each member separately.c53.indd 1209c53.indd 1209 7/31/2012 10:30:24 AM7/31/2012 10:30:24 AM
http://www.it-ebooks.info