Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Optimizing PowerPlay Cubes?
- Thread starter Cranium57
- Start date
CognosProfessional
Programmer
Optimize the Processing of a Power Cube:
Description
The Processing tab of the PowerCube property sheet contains the following optimization controls:
Optimization, with Auto-Partition set as the default
This Cube Is Incrementally Updated check box
Cube Creation, with local processing enabled as the default
Store This PowerCube Compressed check box
Enable Crosstab Caching check box
Depending on your PowerPlay edition, portions of this topic may not apply to you. Click here for details on the features of Transformer in the various PowerPlay editions.
Steps
1. In the Processing tab (PowerCube property sheet), select any of the following:
Optimization. Use to choose how Transformer optimizes the creation of a cube. For more information click here .
This Cube is Incrementally Updated. Use to add only the most recent data to an incrementally updated cube, thereby shortening processing time. See Update Your Cubes Incrementally.
Cube Creation. Use to create the cube or cube group locally (Enabled); or, if data related to a particular cube is unchanged since the last update, shorten processing time by selecting Disabled.
Store This PowerCube Compressed. Use to compress the cube for more compact storage. However, you cannot enable cube compression for multifile cubes.
Enable Crosstab Caching. Use to store summaries for the initial PowerPlay crosstab in the cube, which shortens access time in PowerPlay.
2. Click OK.
Related Topics
Create a Test Cube
PowerCube Optimization Methods
Set a Password for a PowerCube
POWER CUBE Optimization METHODS:
Setting Description
Categories Minimizes the number of categories in a cube. 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.Note: This is the default optimization setting for models created in Transformer versions prior to 6.0.
Data Passes Optimizes the number of passes through the temporary working files during the creation of a cube. Transformer assumes that all categories will be required in the resulting cube, and does not pass through the source data to determine which categories are required. Although included, unreferenced categories will not be visible in PowerPlay.
Direct Create Adds all categories in the model to the cube before the data sources are processed. Records that don’t generate new categories are then directly updated to the cube.This optimization method is best used with models which are expected to generate few new categories, and where all categories are expected to be added to the cube.Note: This setting is not available for individual cubes in a cube group.
Auto-Partition Enables the Auto-Partition tab, where you can set the parameters for Transformer to devise a partitioning scheme.Note: This is the default optimization setting.
CP![[cook]](/data/assets/smilies/cook.gif "[cook] [cook]")
Description
The Processing tab of the PowerCube property sheet contains the following optimization controls:
Optimization, with Auto-Partition set as the default
This Cube Is Incrementally Updated check box
Cube Creation, with local processing enabled as the default
Store This PowerCube Compressed check box
Enable Crosstab Caching check box
Depending on your PowerPlay edition, portions of this topic may not apply to you. Click here for details on the features of Transformer in the various PowerPlay editions.
Steps
1. In the Processing tab (PowerCube property sheet), select any of the following:
Optimization. Use to choose how Transformer optimizes the creation of a cube. For more information click here .
This Cube is Incrementally Updated. Use to add only the most recent data to an incrementally updated cube, thereby shortening processing time. See Update Your Cubes Incrementally.
Cube Creation. Use to create the cube or cube group locally (Enabled); or, if data related to a particular cube is unchanged since the last update, shorten processing time by selecting Disabled.
Store This PowerCube Compressed. Use to compress the cube for more compact storage. However, you cannot enable cube compression for multifile cubes.
Enable Crosstab Caching. Use to store summaries for the initial PowerPlay crosstab in the cube, which shortens access time in PowerPlay.
2. Click OK.
Related Topics
Create a Test Cube
PowerCube Optimization Methods
Set a Password for a PowerCube
POWER CUBE Optimization METHODS:
Setting Description
Categories Minimizes the number of categories in a cube. 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.Note: This is the default optimization setting for models created in Transformer versions prior to 6.0.
Data Passes Optimizes the number of passes through the temporary working files during the creation of a cube. Transformer assumes that all categories will be required in the resulting cube, and does not pass through the source data to determine which categories are required. Although included, unreferenced categories will not be visible in PowerPlay.
Direct Create Adds all categories in the model to the cube before the data sources are processed. Records that don’t generate new categories are then directly updated to the cube.This optimization method is best used with models which are expected to generate few new categories, and where all categories are expected to be added to the cube.Note: This setting is not available for individual cubes in a cube group.
Auto-Partition Enables the Auto-Partition tab, where you can set the parameters for Transformer to devise a partitioning scheme.Note: This is the default optimization setting.
CP
- Status
Similar threads
- Locked
- Question