PowerCube Optimization Methods

Auto-Partition

Enables the Auto-Partition tab, where you can set the parameters for Cognos® Transformer to devise a partitioning scheme.

This is the default optimization setting.

Categories

Minimizes the number of categories in a cube. Cognos Transformer adds only categories that are referenced in the source data or specifically designated to be included. Categories optimization requires an extra data pass for each cube to find the categories required for that cube.

Data Passes

Optimizes the number of passes through the temporary working files during the creation of a cube. Cognos Transformer assumes that all categories are required in the resulting cube, and does not pass through the source data to determine which categories are required. Although included, unreferenced categories are not visible in your reporting component.

Direct Create

Adds all categories in the model to the cube before the data sources are processed. Records that do not generate new categories are then directly updated to the cube.

This optimization method is best used with models that are expected to generate few new categories, and where all categories are expected to be added to the cube.