Open process editor settings
Open settings in PAW and select Process editor. Find the preference for the variable name prefix.
IBM PLANNING ANALYTICS · TI PROCESSES · VARIABLES
Change default variable prefixes.
Use your naming convention from the start.
Do you keep renaming automatically generated TI variables? Set your preferred prefix in IBM Planning Analytics Workspace. New variable names can then start with your convention, such as “vs_” instead of “v”.
The short answer
Open Settings, go to the Process editor and change the variable name prefix. Save the preference and check it in a new TI process. Available from PAW 2.1.17 or 3.1.4.
Florian KaiserIBM Planning Analytics consultant
Read the video summary
Open settings in PAW and select Process editor. Find the preference for the variable name prefix. Replace the default “v” prefix with your convention, such as “vs_”. Save the change. Agree on the spelling with your team so processes remain consistent to read. Create a new TI process and select a cube view as its data source, for example. Check the generated variable names and adjust individual names to your convention where needed.
IN PLANNING ANALYTICS WORKSPACE
Step by step.
Set your prefix
Replace the default “v” prefix with your convention, such as “vs_”. Save the change. Agree on the spelling with your team so processes remain consistent to read.
Check new variables
Create a new TI process and select a cube view as its data source, for example. Check the generated variable names and adjust individual names to your convention where needed.
IN PRACTICE
Rename fewer variables by hand.
A simple example using a source dimension named “Product”. The prefix is a naming convention; it does not determine a data type.
vProduct
With the default “v” prefix, the variable name starts with that letter.
vs_
In the video, I use “vs_” as my convention for string variables.
vs_Product
Newly generated names use the prefix. Rename numeric variables separately if your convention requires it.
COMMON QUESTIONS
Any questions?
Which PAW version supports this?
From PAW 2.1.17 or 3.1.4. Here is how to find your version.
Does “vs_” automatically identify string variables?
No. You set a prefix for variable names. It does not automatically distinguish strings from numbers or change any data type.
Are existing variables renamed?
The preference is for newly added variables. It does not retroactively standardise existing names.
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 ↗