Chapter 8. Optimization and performance tuning 221
– Addition of a measure that will be queried against and you want it to be included in
aggregates. Note the following information:
• Updates for a new measure to in-database aggregates can be made without
rerunning the Aggregate Advisor. The DBA can modify the database aggregate
creation and refresh scripts to include the measure. Then, using Cognos Cube
Designer, the modeler can update the aggregate cube definition, and publish the
cube.
• Updates to in-memory aggregates require rerunning the Aggregate Advisor and
saving a different set of in-memory aggregates from the new advisor results.
Significant data skew changes are made, such as moving from a small-scale development
system to a larger ...