FIX: The naming convention that the Partition Aggregation utility and the Partition Manager utility use could allow duplicate aggregations for partitions (897350)

CAUSE

When an aggregation is added to the collection of aggregations for a partition, the Decision Support Objects (DSO) API examines the Name property of the newly added aggregation. DSO performs this test to determine whether the aggregation is a duplicate of any existing aggregation. This test works for the Analysis Manager utilities such as the Storage Design wizard and the Usage Based Optimization wizard. The test works for those utilities because the utilities use the DatasetName (DSN) that the aggregation covers as the name of the aggregation.

Both the Partition Aggregation and the Partition Manager perform the following steps:

1. Remove all existing aggregations from the partition.
2. Add aggregations based on the list shown in utility.

When you are adding aggregations to a partition, the Partition Aggregation and the Partition Manager use the following format as the name for the aggregations:

CustomAggnnn

Note nnn is a numeric value that is unique for each aggregation record.

Because the Partition Aggregation and the Partition Manager do not use the DSN in the name, DSO cannot detect if any one of the aggregations are duplicates. With either utility, duplicate aggregations may exist. Additionally, duplicate aggregations may be created if you use the Usage Based Optimization wizard or the Storage Design wizard.