Export / Import Aggregations

Hello,

Is there a way to export / import the partition aggregations ?

The thing is - I ran the usage base optimization (+ using a bit of SP2 AggMgr.exe), but everytime I change the cube and redeploy, it overrides the aggregations and i have to rerun the usage base optimizer.

Thanks,

Haggai

What exactly do you intend import or export: aggregation design object or physical aggregation?

I don't know if there is a tool to export/import aggregations but if it exists I think it would be very dangerous because aggregations strictly depend from metadata.

When you say "everytime I change my cube" what does it means? Probably that something changed in your metadata so AS have to overrides aggregations.

Anyway like any other object aggregation can be defined using DDL so you can try to look at yours .partitions file.

|||

Good question.

I dont know of any automated tool or way of adding aggregation desing into a measure group. Though I can see someone enhancing AggregationManager sample application to allow for loading aggregation design stored in file. Or copying aggregation design from one measure group to another. I might have some time doing that :)

As for now, the easiest way would be to create a XMLA script of your old measure group and save only AggregationDesign object part of it in the separate file. Then create XMLA script of new measure group and add AggregationDesing object to it.

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

|||

Based on your answer - I Altered my new measure group and pasted the old AggregationDesigns object. It works fine.