dbTalk Databases Forums  

Processing partitions in parallel

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


Discuss Processing partitions in parallel in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ramunas Balukonis
 
Posts: n/a

Default Processing partitions in parallel - 09-27-2006 , 08:11 AM






Hi,

is it possible to process several partitions in parallel using AMO?
XMLA is not very friendly as it require DatabaseID, CubeID and
MeasureGroupID instaed of DatabaseName, CubeName and MeasureGroupName.

Ramunas Balukonis



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

Default Re: Processing partitions in parallel - 09-27-2006 , 08:40 AM






you can have friendly ID names
generate the XML/A script of the database, change the IDs and execute the
script.
every object will have the ID you want.

"Ramunas Balukonis" <ramblk2 (AT) hotmail (DOT) com> wrote

Quote:
Hi,

is it possible to process several partitions in parallel using AMO?
XMLA is not very friendly as it require DatabaseID, CubeID and
MeasureGroupID instaed of DatabaseName, CubeName and MeasureGroupName.

Ramunas Balukonis





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

Default Re: Processing partitions in parallel - 09-28-2006 , 07:37 PM



You can also use AMO to generate your xmla, I have an example on my blog
here:
http://geekswithblogs.net/darrengosb.../GenerateXmlaB
yName.aspx

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

In article <uQTi0pj4GHA.4196 (AT) TK2MSFTNGP05 (DOT) phx.gbl>,
willgart_A_ (AT) hotmail_A_ (DOT) com says...
Quote:
you can have friendly ID names
generate the XML/A script of the database, change the IDs and execute the
script.
every object will have the ID you want.

"Ramunas Balukonis" <ramblk2 (AT) hotmail (DOT) com> wrote in message
news:1159362686.30125 (AT) loger (DOT) vpmarket.int...
Hi,

is it possible to process several partitions in parallel using AMO?
XMLA is not very friendly as it require DatabaseID, CubeID and
MeasureGroupID instaed of DatabaseName, CubeName and MeasureGroupName.

Ramunas Balukonis






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.