Advanced Dimension Design - Professional SQL Server Analysis Services 2005 with MDX - page 341

Figure 8-16
In Figure 8-16 you can see that the member David Bradley also reports to
David Bradley. This is because each parent member is also included as its
child, so that the value for that parent member is an aggregate of all its chil-
dren and its own value. By way of example, if you have a Sales organization
of employees and each manager manages a few sales employees in a region
in addition to being in charge of certain sales, the total sales by the manager
is a sum of all the direct reports plus the manager's own sales. That is why
you sometimes see a member reporting to him or herself while browsing a
parent-child hierarchy. If you know that the non-leaf members (as with man-
agers in an employee organization) do not have fact data associated with
them and are just an aggregate of the children, Analysis Services 2005
provides a property by which you can disable a member being a child of itself.
This property is called MemberWithData and setting the value to
NonLeafDataHidden, as shown in Figure 8-17 , allows you to disable a mem-
ber being shown as reporting to itself.