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

in Figure 8-7 . There are no children for the Account with AccountKey = 98
(Account Name is "Average Unit Price") and there are no corresponding
fact rows in the fact table FactFinance. Therefore, if you browse the current
Adventure Works DW cube in Cube Browser, you will see a null value for
the Average Unit Price account. The MDX expression in the relational table
for Average Unit Price account is:
[Account].[Accounts].[Account Level 04].&[50]/
[Account].[Accounts].[Account L
02].&[97]
Figure 8-7
When evaluated this MDX expression will provide the amount for
Account Average Unit Price from Accounts Net Sales and Units.
Accounts Net Sales and Units are not children of the Average Un-
it Price account and hence the custom formula mentioned earli-
er calculates the value for Average Unit Price Account. In the
preceding expression you see that the dimension and hierarchy
names specified are Account and Accounts, respectively. Notice
the members specified in the MDX expression for custom rollup
include the level names Account Level 04 and Account Level 02.
By default, the level names for parent-child hierarchies have the
names "Level xx." Hence you also need to make sure you speci-
fy appropriate property to have the level names as shown in the
MDX expression. Hence you need to change the name of the di-
mension and the parent-child hierarchy in your database.
8. Right click on the dimension name Dim Account and click Rename. Enter
the name Account. When asked if the object name needs to be changed,
click Yes. Open the Account dimension in Dimension Designer. Right-click
the parent-child hierarchy Parent Account Key and rename it Accounts.