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

COMMIT statement is executed, Analysis Services gets the new value to
be written, subtracts the original cell value for that tuple, and then writes
back the difference in the ROLAP partition that has been set up for write-
back. Because the original cell value was null and the new value is 1000,
you should see 1000 in the ROLAP partition.
10. Send the following query to the relational table in the Adventure Works
DW database. You will see that there is a new entry in the relational table
that has a value of 1000.
select * from [WriteTable_WB Fact]
11. If you go to the second MDX query window and query the cell value for
Jae Pak, you will see the new value 1000.
12. Analysis Services allows you to send multiple updates within a transaction
so that you have the ability to roll back or commit the entire transaction
that does an update to cube. You can include one or more update queries
within the statements Begin Transaction and Commit Transaction query,
to start a transaction for cell update.
13. After the update statement, send the first MDX query in the same query
window:
SELECT {[WB Employee].[Manager].&[290],
[WB Employee].[Manager].&[290].children
} on 1 ,
[WB Period].[Period].&[2004].children on 0
FROM [Adventure Works DW]
14. You will see the results shown in the following table. Notice that
Alberts, Amy, parent member of Pak, Jae, got the 1000 aggreg-
ated. Analysis Services takes care of calculations and aggrega-
tions of the data written back to the cells automatically.
2004 Q1 2004 Q2 2004 Q3
Open table as spreadsheet