I have a cube with 78 partitions and want to employ parallel process of a
group of these from a C# AMO program.

Q: How is the parallelism managed? Do I need to manage separate threads
from inside my program, or is this taken care of by the AMO interface
somehow?

Any code snippets would be most appreciated!

Scott


--
Scott Sampson

This thread contains sample AMO code for doing parallel processing with AMO.

http://forums.microsoft.com/MSDN/Sho...07435&SiteID=1


//--------------------------------------------------------------------------------
// The commands that AMO is sending to the server (Create,
Process, Delete etc)
// can be captured into a log (instead of being sent to the
server for execution)
// and run later (eventually all of them into a Batch, in
parallel).
//
// A common use for AMO capture mode is to do parallel
processing of objects.
// For example:
// - the [Adventure Works DW] sample database has the dimensions
[Product] and [Date]
// - we want to process these 2 dimensions transactional and in
parallel
// - normal AMO code (that connects to server and calls
Process() on [Product] and
// then Process() on [Date]) will process the dimensions
separately and serially
// - with capture mode, we'll be able to process the dimensions
transactional and in
// parallel, using the same Process methods unchanged
//
// The capture mode related properties and methods are on the
Server class:
// - CaptureXml: enables/disables capture mode
// - CaptureLog: provides the log with the captured commands
// - ExecuteCaptureLog: runs the commands from the log in a
Batch, with options for transactional and parallel
//--------------------------------------------------------------------------------


Adrian



"Scott Sampson" <ScottSampson (AT) discussions (DOT) microsoft.com> wrote

Hi Scott,

This earlier [MS] post in the Newsgroup provides some sample C# code:

http://groups.google.com/group/micro...c5b5c9f49bf9d4
processed?

From: Adrian Dumitrascu [MS]
Date: Wed, May 17 2006 4:23 pm

To process multiple objects at once with AMO (in a Batch, in Parallel), this
is sample code (sorry it's C#, I don't have it available in VB.NET):

Server s = new Server();


s.Connect("localhost");


try
{
// We'll put AMO in capture-mode; this means that all .Process, .Update
etc commands
// are saved in a log (Server.CaptureLog), instead of being sent to the
server. And then
// we can run the commands from the log in a single Batch (eventually in
Parallel).
s.CaptureXml = true;


// Now we'll call the .Process methods as normally.
s.Databases["my database id"].Dimensions["my dimension id1"].Process();
s.Databases["my database id"].Dimensions["my dimension id2"].Process();


// Once we called Process on all the objects we want, we'll exit
capture-mode and
// we'll run the script.
s.CaptureXml = false; // we exit the capture mode
XmlaResultCollection results = s.ExecuteCaptureLog(true, true); //
transactional and parallel


// Now we'll check the results
foreach (XmlaResult result in results)
{
foreach (XmlaMessage message in result.Messages)
{
Console.WriteLine(message.Description);
if (message is XmlaError)
{
// the processing failed, there is at least one error
reported here.
}
}
}


}


finally
{
s.Disconnect();


}
....

"Scott Sampson" wrote: