Ureader.com  
Microsoft software help and Community
   home   |   control panel login   |   archive   |  
 
XML
data.xmlanalysis
mappoint.webservice
msf
msxml-webrelease
netmyservices.sdk
passport.sdk
soap
soapsdk
uddi.general
uddi.programming
uddi.specification
xml
xmlsqlwebrelease
xsl
  
 
date: Mon, 17 Sep 2007 09:56:20 -0000,    group: microsoft.public.data.xmlanalysis        back       


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

Re: Update Cube Statement Error   
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?
date: Mon, 17 Sep 2007 10:20:27 -0000   author:   unknown

Google
 
Web ureader.com


    COPYRIGHT 2007, YARDI TECHNOLOGY LIMITED, ALL RIGHT RESERVE  |   contact us