Updating Your UDM Data - Professional SQL Server Analysis Services 2005 with MDX - page 531

1. Execute the SQL queries (CreateWriteBackExampleTables.sql in
the Chapter 11 folder that can be downloaded from the accom-
panying web site) initially executed to ensure you have all the
dimension members. Open the dimension WB Period in the Ana-
lysis Services cube used in the previous section.
2. Rename the key attribute as Quarter, and have the name column for the
key attribute set to QuarterName. Remove the attribute hierarchy Quarter-
Name and create a user hierarchy Period that has two levels, Calendar,
Year and Quarter, as shown in Figure 11-9 . Open the Adventure Works DW
cube in the WriteBackExample database and delete the measure WB_Fact
Count that was created by intellicube. You will learn later in this section why
you need to delete the measure with aggregation function Count.
Figure 11-9
3. Deploy the changes to your Analysis Services instance.
4. Send the following MDX query to the cube:
select {[WB Employee].[Manager].&[290],
[WB Employee].[Manager].&[290].children} on 1 ,
[WB Period].[Period].&[2004].children on 0
from [Adventure Works DW]
5. The results of this MDX query are shown in the following table. The cell
values show the Budget Expense amount for various quarters for employ-
ees reporting to Amy Alberts. Notice that the value for 2004 Q3 is not
available.