dbTalk Databases Forums  

AS2005: multiple batch in 1 XML/A command?

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


Discuss AS2005: multiple batch in 1 XML/A command? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Jéjé
 
Posts: n/a

Default AS2005: multiple batch in 1 XML/A command? - 07-24-2006 , 08:36 AM






Hi,

I want to know if its possible to execute multiple batch into 1 command.
I try to process my cubes and partitions and I want this:
1 transaction by cube, parrallel process of the partitions into this cube.

My script generate this XML/A command:
<Batch>
<Parallel>
-- partitions of the first cube here --
</Parallel>
<Parallel>
-- partitions of the second cube here --
</Parallel>
<Parallel>
-- partitions of the third cube here --
</Parallel>
</Batch>

the result is good, the system process the first partitions, then the second
block and the third.
but everything is into 1 transaction!
so until I reached the end of the batch command the processed cube remain
unavailable.

Can I do something in my XML/A script?
or I have to execute each cube into a separate XML/A command?

thanks.

Jerome.



Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: AS2005: multiple batch in 1 XML/A command? - 07-24-2006 , 09:23 AM






ok,

I have created a workflow similar to this one:
http://blogs.conchango.com/jamiethom...7/18/4235.aspx

and its ok now.

so its the same idea, but I generate XML/A scripts which process in parallel
the partitions of the cubes instead of 1 at a time like Jamie develop.
But 1 transaction by cube. so I have the best of the 2 worlds.


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

Quote:
Hi,

I want to know if its possible to execute multiple batch into 1 command.
I try to process my cubes and partitions and I want this:
1 transaction by cube, parrallel process of the partitions into this cube.

My script generate this XML/A command:
Batch
Parallel
-- partitions of the first cube here --
/Parallel
Parallel
-- partitions of the second cube here --
/Parallel
Parallel
-- partitions of the third cube here --
/Parallel
/Batch

the result is good, the system process the first partitions, then the
second block and the third.
but everything is into 1 transaction!
so until I reached the end of the batch command the processed cube remain
unavailable.

Can I do something in my XML/A script?
or I have to execute each cube into a separate XML/A command?

thanks.

Jerome.





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.