Update Cube Statement Error

Update Cube Statement Error

Post by jefersline » Tue, 18 Sep 2007 18:56:20


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?
 
 
 

Update Cube Statement Error

Post by jefersline » Tue, 18 Sep 2007 19:20:27

But when i connect to analysis services 2005 with Microsoft SqlServer
Managment Studio,
every is fine.
i have checked that the querystring is all the same.
why the result is too different?