Update Cube Statement Error
I make a MDX update cube statement like blow:
UPDATE CUBE [Cube] SET ([Dim Budget Item].[Hierarchy].
[Level1].&[Ceiling Titles].&[Others].&[Others].&[CAC-ç½é¾],
[AnalysisDate].[Year].&[2008],[Measures].[Delivery Volumn],[Budget
Customer].[Hierarchy].[Budget Customer].&[100017])=1000,([Dim Budget
Item].[Hierarchy].[Level1].&[Ceiling Titles].&[Others].&[Others].&[CAC-
ç½é¾],[AnalysisDate].[Year].&[2008],[Budget Customer].[Hierarchy].
[Budget Customer].&[100017],[Measures].[Delivery Amount])=1000000,
([Dim Budget Item].[Hierarchy].[Level1].&[Ceiling
Titles].&[Others].&[Others].&[CAC-ç½é¾],[AnalysisDate].[Year].&[2008],
[Budget Customer].[Hierarchy].[Budget Customer].&[100017],[Measures].
[Pickup Amount])=10000,
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?
date: Mon, 17 Sep 2007 09:56:20 -0000
author: unknown