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

2004 Q1 2004 Q2 2004 Q3

Alberts,Amy 2072000 2865000 1000

Alberts,Amy 116000 1000

(null)

Pak,Jae

883000 1329000 1000

Valdez,Rachel

366000 627000 (null)

Varkey Chudukatil,Ranjit

707000 908000 (null)

15. Switch to the first MDX window, and send the following query to
update the same cell to 800. If you are executing the following
statements in SQL Server Management Studio, execute them as
separate statements by selecting the statement and then press-
ing execute or Ctrl+E to execute; that is, Begin Transaction
should first be highlighted and executed, followed by the update
statement and then the Commit Transaction statement.

BEGIN TRANSACTION

UPDATE CUBE [Adventure Works DW]
SET ( [WB Employee].[Manager].&[291]
, [WB Period].[Period].&[20043]) = 800

COMMIT TRANSACTION

16. If you send a query to retrieve the data for Jae Pak for Quarter 3
of 2004 in both MDX query windows, you will see the exact same
value of 800.

Analysis Services uses the ROLAP partition to implement the cell writeback; when
you send the update cell query the cell data value is held in memory for that