dbTalk Databases Forums  

SP4 Update Cube problem

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss SP4 Update Cube problem in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Michel CARADEC
 
Posts: n/a

Default SP4 Update Cube problem - 06-13-2005 , 03:54 AM






Hi again,

I posted this message 2 weeks ago, and got no reply, so submit it again.
Thanks for your feedback.
Note I noticed the same behaviour with PTS9 beta (June CTP)

After installing AS SP4 on server+Pivot Table SP4 on client, I got this bug
:

1- Use cube Budget in Foodmart 2000 sample database
-2 Run this first UPDATE CUBE statement :

UPDATE CUBE [Budget] SET ([Account].[All Account].[Net Income].[Total
Expense].[Lease],[Category].[All Category].[Current Year's
Budget],[Measures].[Amount],[Store].[All
Stores].[Canada].[BC].[Vancouver].[Store 19],[Time].[1998].[Q1])=1000
USE_EQUAL_ALLOCATION

This command performs well. Note the updated cell was Empty before running
command (1000 after)

3- Run this second UPDATE CUBE statement (on the same cell) :

UPDATE CUBE [Budget] SET ([Account].[All Account].[Net Income].[Total
Expense].[Lease],[Category].[All Category].[Current Year's
Budget],[Measures].[Amount],[Store].[All
Stores].[Canada].[BC].[Vancouver].[Store 19],[Time].[1998].[Q1])=2000
USE_WEIGHTED_ALLOCATION

Even if the command execution succeeds, the amount returned for the updated
cell is still 1000 (instead of 2000).
Subsequent calls to UPDATE CUBE on this cell give the same result (new
amount is ignored)
If I use 'USE_EQUAL_ALLOCATION' in the second statement, it will work.

I've reproduced this on client PCs running Pivot Table SP4
There is no problem on client PCs running Pivot Table SP3a

Is this a known bug. I so, how can I correct it ?

Thanks for you help

Michel CARADEC



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.