Re: MDX Updates

#1

Try sending the SELECT statement from a different query window. If it
returns the wrong result, then your cube update transaction (in the first
query window) is not committed. Send a COMMIT TRANSACTION statement.

--
This posting is provided "AS IS" with no warranties, and confers no rights
Please do not send email directly to this alias. This alias is for newsgroup
purposes only.

"Fabio GRANDE" <f.grande (AT) poker (DOT) it> wrote

Quote:

Hi All !

I'm quite sure You can help me, answering a simple(???) question...

I'm "playing" with Analysis Services (2005) and MDX Updates... I
really can't understand WHERE my updates go...

I'm doing all from "Query Window" of SQL Server Management Console :

1) I write (and launch) a simple MDX UPDATE CUBE.
2) If I SELECT the data I've just updated, I see what I expect.

3) If I go to browse my cube (always from SQLServer Management
Console), I can't see the new data... Even if I refresh or reconnect
the session (from browsing).

Why ? What am I missing ?

I would update cubes from CLR Triggers, letting users see new data
from cube browsing...

Hoping You can understand me...
TIA
Fabio G

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

Re: MDX Updates

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

Re: MDX Updates - 03-13-2006 , 07:18 PM