Create the dimension
Open the database in the Modeling Workbench. Click the three-dot menu next to Dimensions and select Create dimension. Enter a suitable name, such as Parameter, and confirm.
IBM PLANNING ANALYTICS · MODELLING · DIMENSIONS
Create dimensions in IBM Planning Analytics.
Build the structure in a few steps.
Need a new dimension for your model? Create it directly in the Modeling Workbench in Planning Analytics Workspace. Give it a name, add the members you need and commit your changes. The video demonstrates this with a simple parameter dimension.
The short answer
Open the three-dot menu next to Dimensions and select Create dimension. Enter a name, use Add root member to add your members and finish by clicking Commit.
Florian KaiserIBM Planning Analytics consultant
Read the video summary
Open the three-dot menu next to Dimensions and select Create dimension. Enter a name; the video uses a parameter dimension. Click Add root member and enter the members you need. Finally, click Commit. The dimension is then available for use in new cubes.
IN PLANNING ANALYTICS WORKSPACE
Name it. Add members. Commit.
Add members
In the dimension editor, click Add root member. Enter the members your dimension should contain to build an initial list.
Commit your changes
Check the names and click Commit. You can then select the dimension when creating a new cube.
THE VIDEO EXAMPLE
Build a small parameter dimension.
For a small number of members, you can create the dimension directly in the editor. The video uses a parameter dimension to demonstrate the steps.
A parameter dimension is needed.
A new cube needs a dimension containing a small number of parameters.
Create it in the editor.
Give the dimension a name and add the required parameters as individual members.
Ready for the next cube.
After committing the changes, the dimension is available when creating a cube.
COMMON QUESTIONS
Any questions?
Which permissions do I need?
To create and edit dimensions in Planning Analytics Workspace, you need the Modeler or Administrator role and the required database access.
Can I import a longer member list?
Yes. For many members, importing from a file is a useful option. Learn how to create a dimension from CSV.
Can I add aliases later?
Yes. In the dimension editor, add an attribute of type Alias to provide alternative member names. Read the alias tutorial.
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 dimensions easier to understand or develop your TM1 model? I can help you implement your requirements in Planning Analytics.
Discuss your project ↗