xtrCubeOptimize Value List
Applies To
Discussion
Use the constants of this value list with the Optimize property of the Cube, CubeGroup, and ChildCube objects to increase the performance of PowerCubes and Transformer. The constants represent optimization settings.
Cube size, processing time in Transformer, and access time in PowerPlay® are all affected by the optimization setting chosen. Select the best one for your model and data.
| Constant |
Description |
|---|---|
| trOptimizeAutoPartition |
Specifies that the auto-partitioning feature is available. This is the default setting for models created in Transformer versions 6.0 and later. |
| trOptimizeCategories |
Minimizes the number of categories in a cube. Only categories referenced in the data source or specifically designated to be included are added. There is an extra data pass for each cube to find the categories needed for that cube. This is the default for models created in Transformer versions before 6.0. |
| trOptimizeDataPasses |
Optimizes the number of passes through the temporary working files during cube creation. All categories are included in the resulting cube, though categories not directly referenced or indirectly referenced via an ancestor will not be visible in PowerPlay. |
| trOptimizeDefault |
Sets the default applicable to the version of Transformer the model was created with. |
| trOptimizeDirectCreate |
Adds all categories in the model to the cube before the data sources are processed. It is best used with models that generate few new categories, and where all categories are expected to be added to the cube. Not applicable for individual cubes within a cube group. |