Databases Reference
In-Depth Information
Combining all the sections of the MDX you have seen, you will have the
following MDX query to allocate the budget to Amy Albert's team based
on a ratio of the previous quarter:
update cube [Adventure Works DW]
set (
[WB Employee].[Manager].&[290]
, [WB Period].[Period].&[20043]) = 1000
use_weighted_allocation by
([WB Period].[Period].&[20042], [WB
Employee].[Manager].currentmember)/
([WB Employee].[Manager].&[290],[WB
Period].[Period].&[20042])
If you execute the MDX query to retrieve the budget amount for all
the children of Amy Albets for various quarters of 2004 after executing
the update statement, you should see the results shown in the follow-
ing table. In the RTM version of the product the allocation does not get
distributed. We believe this is a bug that might be resolved in service
packs. We will provide an update through the download site on this ex-
ample.
2004 Q1
2004 Q2
2004 Q3
2072000
2865000
1000
Alberts,Amy
Alberts,Amy
116000
1000
0.34904014
883000 1329000 463.8743455
Pak,Jae
366000
627000
218.8481675
Valdez,Rachel
Search WWH ::
Custom Search