Prepare the dimensions
Check that the required dimensions exist in the target database. Decide on the cube name and the order of its dimensions.
IBM PLANNING ANALYTICS · CUBES · TURBOINTEGRATOR
Create cubes in IBM Planning Analytics.
Manually or with a TI process.
Your dimensions are ready? Combine them into a cube, either directly in the Modeling Workbench or automatically with TurboIntegrator. The video shows both approaches and how to check whether the cube already exists.
The short answer
Manually: open the Cubes menu, enter a name and select the dimensions. In a process: use CubeExists in the Prolog to check for the cube, then create it with CubeCreate if needed.
Florian KaiserIBM Planning Analytics consultant
Read the video summary
Check that the required dimensions exist in the target database. Decide on the cube name and the order of its dimensions. In the Modeling Workbench, open the three-dot menu next to Cubes and start creating a cube. Enter its name, continue and select the dimensions. Check their order and confirm creation. Create a TI process. In the Prolog, add a CubeExists check and call CubeCreate only if the cube does not exist. Save and run the process, then check the new cube.
IN PLANNING ANALYTICS WORKSPACE
Step by step.
Create it manually
In the Modeling Workbench, open the three-dot menu next to Cubes and start creating a cube. Enter its name, continue and select the dimensions. Check their order and confirm creation.
Alternatively, create it with a process
Create a TI process. In the Prolog, add a CubeExists check and call CubeCreate only if the cube does not exist. Save and run the process, then check the new cube.
IN PRACTICE
Check first, then create.
This simplified example creates a cube using two existing dimensions. Adapt the names and their order to your model.
TurboIntegrator · Prolog
IF (CubeExists('Cubename') = 0);
CubeCreate('Cubename', 'Dimension1', 'Dimension2');
ENDIF;Replace Dimension1 and Dimension2 with the names of your existing dimensions. An existing cube is skipped; this check does not validate or change its structure.
COMMON QUESTIONS
Any questions?
Why use CubeExists before CubeCreate?
CubeExists returns 1 if the cube exists and 0 otherwise. This lets you skip creation on a later run and avoid an error caused by an existing cube.
Does CubeCreate also create the dimensions?
No. The specified dimensions must already exist. Learn how to create a dimension manually.
Does dimension order matter?
Yes. The order of the dimensions passed to CubeCreate becomes the cube dimension order. Check it before creating the cube.
Is transaction logging enabled automatically?
Manual creation in the Modeling Workbench enables transaction logging. According to IBM, CubeCreate does not enable it automatically; use CubeSetLogChanges if required.
KEEP LEARNING
More Planning Analytics tips.
Florian KaiserPlanning Analytics consultantSUPPORT FOR YOUR TM1 MODEL
A model that is easy to navigate.
Want to make your reporting clearer or develop your Planning Analytics model? I can help you implement your requirements in Planning Analytics.
Discuss your project ↗