Aggregation Migration

Definitions of aggregations objects in AS2K5 are organized in AggregationsDesign groups so as to be able to assign a unique definition to several partitions within a Measure Group.

When Migration Wizard migrate aggregations, if two AS2K aggr sets from two different partitions of the same cube have exactly the same definition but are ordered in a different way, the Migration Wizard process will create two different AggregationsDesign with different name, duplicating xmla descriptions.

So It's better to order all the same aggr.definitions by the same criteria in every partition of a cube before migrating it.

It can be done by using the Partition Aggregation Utility.

Thanks.

I would not worry about arranging aggregations in AS2K.

AS2K5 gives you a lot of power and flexibility as it comes to editing objects.

I would migrate the cube in whatever state it is. Later I would clean up the AS2K5 database using scripted view of the database.

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