The following scenarios are based on a model that includes three dimensions:
Product (3 levels)
Market (4 levels)
Measures
The total number of potential aggregate views is 12.
The aggregate views are numbered from 1 to 12.
Data was loaded, and an aggregation was performed. The aggregation materialized aggregate views 3, 5, 7, and 8.
A second data load was completed, so, since the aggregation, the level 0 input data has changed.
You are designing a new aggregation. Thus, you are using option 2 of the wizard.
In the wizard, if you select the “Add to existing aggregate view selection” option:
Views 3, 5, 7, and 8 are automatically selected.
Select views 1 and 12.
When the aggregation is materialized, aggregate views 1 and 12 are materialized.
The database aggregation now contains aggregate views 1, 3, 5, 7, 8, and 12.
Note: | If you were pleased with the query performance produced by the original aggregate view selections, you should select the Add option. Also, if the Add option is used, materialization time is reduced. |
Aggregation Replacement Option
In the wizard, if you select the “Replace existing aggregate view selection” option:
No views are automatically selected.
Select views 1, 3, 7, 9, and 11.
On the past page of the wizard, you must select or clear the “Replace existing aggregation” option.
If you selected the “Replace existing aggregate view selection” option, on the last page of the wizard, you must select or clear the “Replace existing aggregation” option.
If you select the “Replace existing aggregation” option:
Aggregate views 3, 5, 7, and 8 are deleted.
Aggregate views 1, 3, 7, 9, and 11 are materialized.
The database aggregation now contains aggregate views 1, 3, 7, 9, and 11.
If you clear the “Replace existing aggregation” option:
Aggregate views 3 and 7 exist.
Aggregate views 1, 9, and 11 are materialized.
The database aggregation now contains aggregate views 1, 3 ,5, 7, 8, 9, and 11.