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

[WB Period].[Period].&[2004].children on 0
FROM [Adventure Works DW]

2004 Q1 2004 Q2 2004 Q3

Open table as spreadsheet

2072000 2865000 1000

Alberts,Amy

Alberts,Amy 116000 1000 250

Pak,Jae 883000 1329000 250

Varkey Chudukatil,Ranjit 707000 908000 250

366000 627000

Valdez,Rachel 250

If you did not specify the allocation clause to be
USE_EQUAL_ALLOCATION, Analysis Services assumes that the data al-
located needs to be equally distributed to all the children. Therefore,
the following UPDATE statement will also result in the same results as
shown in the previous table:

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

Now that you have learned how to update data to a non-leaf member,
you will learn the remaining allocation options provided by Analysis Ser-
vivces.

Weighted Allocation

In a more complex scenario, allocation of budgets depends on the size
of the organization or the revenue generated by the person (or group)
in the previous year. A common form of allocation in the real-world is to