Database Reference
In-Depth Information
In the preceding example, you learned yet another important attribute property:
Mem-
bersWithData
. This property advises Analysis Services how to handle data val-
ues at non-leaf levels. Generally in a regular dimension, non-leaf levels aggregate
data from leaf levels; for example, we'll sum up January, February, and March sales
in order to find the value for the first quarter. In a parent-child scenario, the story
is somewhat different because each manager could have her own sales in addi-
tion to the sales reported for salespeople whom she manages. Analysis Services
creates "data members" for such managers; each data member reflects the data
found in the underlying relational source, rather than the aggregation of subordinate
salespeople's sales. You set the
MembersWithData
property for the
Employees
hierarchy to
NonLeafDataHidden
so that managers' data members don't show up.
The default value for the
MembersWithData
property is
NonLeafDataVisible
; if
you keep the default value, a manager's sales figure will show up as though she was
reporting to herself. For example, notice that the list of Amy Albert's direct reports
includes Amy Alberts after I switch the property to
NonLeafDataVisible
:
Search WWH ::
Custom Search