Sessions in XML for Analysis 
Author Message
 Sessions in XML for Analysis

The default mode for UPDATE CUBE is autocommit, which is if you didn't open
transaction, every UPDATE CUBE will automatically open one and commit (if
the statement suceeded). What you need to do is:

1. Begin new session - See Statefullness support section in XML/A spec
2. Issue BEGIN TRANSACTION statement using session ID obtained at step 1
3. Issue one or more UPDATE CUBE statements using session ID obtained at
step 1
4. Issue COMMIT TRANSACTION (or ROLLBACK TRANSACTION) statement using
session ID obtained at step 1
5. End session

HTH,
Mosha

--
==================================================

Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================

Quote:
> Hello,

> I am using Java programs to make a Discover, Execute and UPDATE calls
> with Microsoft Analysis Server. While I make UPDATE statements the
> session is getting comitted after every single UPDATE back to the cube
> cells. Does anyone has implemented stateful connection for making
> UPDATEs or write back of cube cells with Microsoft Analysis Server.

> I urgently require help and advice from someone in this regard.

> Thanks in Advance,
> Ramesh



Mon, 19 Jul 2004 02:31:56 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Sessions in XML for Analysis

2. XML for Analysis to Analysis Services: Security / Access Control

3. Database-related sessions, joint BCS and XML UK Meeting (XML DevCon 2001, London)

4. Database-related sessions, joint BCS and XML UK Meeting (XML DevCon 2001, London)

5. Database-related sessions, joint BCS and XML UK Meeting (XML DevCon 2001, London)

6. Database-related sessions, joint BCS and XML UK Meeting (XML DevCon 2001, London)

7. XML for Analysis Simple Sample XLS doesn't work w/ASP.NET XML WebControl

8. XML for Analysis Simple Sample XLS doesn't work w/ASP.NET XML WebControl

9. Storing an Analysis Services connection in an ASP session

10. Session RESET when connect to Analysis Server

11. Ddatabase, query, and schema sessions (XML DevCon 2001, New York, April 8-11)

12. database-related sessions, British Computer Society Meeting (XML DevCon 2001, London)


 
Powered by phpBB® Forum Software