Hello,

As I get a lot of help from this newsgroup, I already have another question.
I have a script that creates and process SSAS partitions. I was wondering if
anyone can suggest what is the best way to copy aggregations from one
partition to new created partition. I am looking at script solution, not
interactive. I know that in XMLA you can specify aggregation ID when you
create partition. But it is not very easy to use...
As one option, I am looking for some script that grabs last partition for
same measure group and get the id of aggregate used and uses it for new
partition build.
As another option, very likely my way of doing this is not right, and I am
looking for info how such scripting is expected to be done by microsoft.

Thank you in advance

Hello Vimas,

Thank you for your post and nice to see you again in MSDN newsgroup.

I understand that you're looking for script to copy aggregation from one
partition to a new one. You want to some script to grabs last partition for
same measure group and get the id of aggregate used and uses it for new
partition build.

In AS2005 aggregations are not specific to the particular
partitions.AggregationDesign object contains definitions of
aggregations.This allows you easily to apply aggregation design to any
partition.

You usually don't need your "template" partitions, just create a partition
and point AggregationDesignID property to the particular aggregation design
object.

An agg design can have none, one or more than one partition pointing to it.
A partition points to one and only one agg design. Doing a multi-select
when designing aggregations in SSMS applies the same agg design to all of
the partitions.


You could use AMO to enumberate and find
Partition.AggregationDesign/Partition.AggregationDesignID properties and
use them to create new parititon.

http://msdn2.microsoft.com/en-us/library/ms345091.aspx

Also, You may want to try and use AmoBrowser sample application to navigate
list of objects in AMO.

If you have futher questions, please feel free to let's know.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support


================================================== ===


This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== ====