I make a MDX update cube statement like blow:
UPDATE CUBE [Cube] SET ([Dim Budget Item].[Hierarchy].
[Level1].&[Ceiling Titles].&[Others].&[Others].&[CAC-=E7=99=BD=E9=9B=BE],
[AnalysisDate].[Year].&[2008],[Measures].[Delivery Volumn],[Budget
Customer].[Hierarchy].[Budget Customer].&[100017])=3D1000,([Dim Budget
Item].[Hierarchy].[Level1].&[Ceiling Titles].&[Others].&[Others].&[CAC-
=E7=99=BD=E9=9B=BE],[AnalysisDate].[Year].&[2008],[Budget
Customer].[Hierar=
chy].
[Budget Customer].&[100017],[Measures].[Delivery Amount])=3D1000000,
([Dim Budget Item].[Hierarchy].[Level1].&[Ceiling
Titles].&[Others].&[Others].&[CAC-=E7=99=BD=E9=9B=BE],[AnalysisDate].[Year]=
..&[2008],
[Budget Customer].[Hierarchy].[Budget Customer].&[100017],[Measures].
[Pickup Amount])=3D10000,
As my opinion,the result in writeback table should be like:
column1 column2 column3
1000 0 0
0 1000000 0
0 0 1000
but in reality is:
column1 column2 column3
1000 0 0
1000 1000000 0
1000 1000000 1000
What did i do wrong?
|
