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

trieves data for measures across a specific hierarchy, it takes the de-
fault members of other hierarchies while doing this evaluation. For
most hierarchies the All member is the default. In the Account dimen-
sion the IsAggregatable property is set to false because aggregating
the data for the top-level members in the Account dimension does
not make business sense. In such circumstances, Analysis Services
uses the default member of the hierarchy. If a default member is not
specified, Analysis Services retrieves the first member of the hier-
archy. The first member of the Accounts hierarchy is Balance Sheet
and the unary operator for Balance Sheet, ~ (tilde), will result in very
weird or non-intuitive results. In order for you to see meaningful res-
ults, you need to make sure you choose the right default.
3. For the Accounts hierarchy, click the DefaultMember property. In the
Set Default Member dialog, choose a member to be the default op-
tion, select Net Income, and click the OK button. The Net Income
member has a unary operator of +, which will result in meaningful
data being seen while browsing the Amount measure for other di-
mensions. Now, deploy the changes to the Analysis Services in-
stance. This percentage of ownership will be applied for the meas-
ures being queried.
4. If you browse the Organization dimension along with the measure
Amount you will notice appropriate rollups based on the weighted un-
ary operator. Figure 8-14 shows the amount for various organiza-
tions, and you can see that the amount from the Canadian organiza-
tion is aggregated as 0.75 to the North American organization.
Figure 8-14
When multiple calculations are specified for a cell, Analysis Services 2005
uses a specific order in which calculations are evaluated. Due to the order of
calculations, cell values might not always be intuitive and you can sometimes