Re: Update Local Cube

#1

Hello Joost,
You are right that Update statement is supported for what-if analysis, but
changes can not be commited and stored in the cube. The changes are only
awailable inside same ADO connection, but most likely PivotTable uses new
connection.
--
Hope this helps,
Irina

---------------------------
Disclaimer: This posting is provided 'AS IS' with no
warranties, and confers
no rights.

"Joost" <Joost.Stalpers (AT) mpg (DOT) com> wrote

Quote:

I am having trouble updating a local cube (created from an Access db
with "CREATE CUBE"). My code uses an ADO connection that executes the
"UPDATE CUBE" statement and it runs without errors but the pivot table
that uses the cube for its data doesn't show the changes.

On
http://msdn.microsoft.com/library/de...keyco_2z3n.asp
it says that local cubes can use the "UPDATE CUBE" statement for
what-if analysis, so I must be doing something wrong.

Any ideas would be most welcome, thanks, Joost.

#2

Hi Irina, I see the light now, thank you very much.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: Update Local Cube

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

Re: Update Local Cube - 07-02-2003 , 01:47 PM

Re: Update Local Cube - 07-10-2003 , 08:19 AM