dbTalk Databases Forums  

Using AMO for parallel processing

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


Discuss Using AMO for parallel processing in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dattatrayhkulkarni@gmail.com
 
Posts: n/a

Default Using AMO for parallel processing - 09-01-2006 , 12:45 AM






Hi,

I want to write some AMO code which will process many partitions of a
cube in parallel.

The process API doesn't have any required parameter to specify the
parallel ( or batch ) processing mode.

Can you please let me know any pointers for the same?

Do I need to use the XMLA for parallel cube processing?

regards,
dattatray.


Reply With Quote
  #2  
Old   
Darren Gosbell
 
Posts: n/a

Default Re: Using AMO for parallel processing - 09-01-2006 , 07:01 AM






You do need to use XMLA for parallel processing, but you don't
necessarily need to generate it by hand.

I have an example on my blog at:
http://geekswithblogs.net/darrengosb.../GenerateXmlaB
yName.aspx

The example is done in PowerShell, but it is not that different from
doing it with C# or VB.NET. The basic pattern is to:

1) set the CaptureXml property on the server to true
2) then to call the process method on the objects you want to process
3) finally call ExecuteCaptureLog(true,true,true) on the server to
initiate the parallel process.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1157089535.209942.277550 (AT) p79g2000cwp (DOT) googlegroups.com>,
dattatrayhkulkarni (AT) gmail (DOT) com says...
Quote:
Hi,

I want to write some AMO code which will process many partitions of a
cube in parallel.

The process API doesn't have any required parameter to specify the
parallel ( or batch ) processing mode.

Can you please let me know any pointers for the same?

Do I need to use the XMLA for parallel cube processing?

regards,
dattatray.



Reply With Quote
  #3  
Old   
Rea
 
Posts: n/a

Default RE: Using AMO for parallel processing - 09-03-2006 , 07:28 AM



I need to address the same issue..
What is AMO code??

"dattatrayhkulkarni (AT) gmail (DOT) com" wrote:

Quote:
Hi,

I want to write some AMO code which will process many partitions of a
cube in parallel.

The process API doesn't have any required parameter to specify the
parallel ( or batch ) processing mode.

Can you please let me know any pointers for the same?

Do I need to use the XMLA for parallel cube processing?

regards,
dattatray.



Reply With Quote
  #4  
Old   
Darren Gosbell
 
Posts: n/a

Default RE: Using AMO for parallel processing - 09-04-2006 , 07:11 AM



In article <1AD6B0CB-F86C-4732-A8F0-F2053CD55E69 (AT) microsoft (DOT) com>,
Rea (AT) discussions (DOT) microsoft.com says...
Quote:
I need to address the same issue..
What is AMO code??

"dattatrayhkulkarni (AT) gmail (DOT) com" wrote:

Hi,

I want to write some AMO code which will process many partitions of a
cube in parallel.

The process API doesn't have any required parameter to specify the
parallel ( or batch ) processing mode.

Can you please let me know any pointers for the same?

Do I need to use the XMLA for parallel cube processing?

regards,
dattatray.



AMO is Analysis Management Objects and is a library of .Net classes that
you can use to administer Analysis Services.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell


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.