90 IBM Cognos Dynamic Cubes
4.9.9 Automatic aggregate cube creation
You can use the aggregate cube auto-matching functionality to create an aggregate cube
automatically. You can do this by dragging the aggregate table onto the aggregates field of the
aggregates tab of the cube that you are working on. Where matching measures and
dimensions are found in the cube, Cognos Cube Designer maps each of these items to the
aggregate table. Where possible, it also attempts to identify the highest level of aggregation
required and roll up dimensions. Inspect the aggregate cube and refine it to ensure that it is
modeled exactly as you need it to be.
The ability to automatically map depends on how the aggregate tables are set up. A naming
convention f