Skip to main content

Celonis Product Documentation

Analysis variables
Saving PQL statements as variables

PQL statements can be saved as variables and re-used in different parts of your analysis.

How to use variables
20873366.png

Variables can be used in all text input fields and formula inputs in the analysis UI.

Syntax

<%=VARIABLENAME%>

Input components allow you to change the value in the text input or formula input within the variable. You can change the variable's content with:

  1. Buttons

  2. Button dropdowns

  3. Input fields

Managing Variables
20873367.png
  1. Variables can be managed in the analysis setting in the tab Variables.

  2. Create new variables with the button 'Create variable'.

  3. Search your existing variables with the search input.

  4. All existing variables are listed in the table below 'My variables' and sorted by name.

  5. Each variable shows which type of variable it is, a static value or text replacement.

  6. In the last column, each variable previews its current value. In case of the static value, it shows a preview of the calculated value on text replacement it will show the currently stored text.

Creating a text replacement variable
20873368.png

The text replacement variable will put the text that it stores wherever you are using the variable in the analysis. You can share reoccurring text snippets all over the analysis.

  1. The defined variable name will be used to call the variable in the rest of the analysis. Spaces and special characters are automatically replaced by '_'.

  2. There are two types of variables. You can switch between the types with the available dropdown.

  3. On the textinput field, you can set the variable's value. Be aware, that this value can be overwritten by other components like a button. This input will always show the current value that is set on the analysis draft.

  4. Remove the variable with the remove button. (Only available if the variable was saved once)

  5. Duplicate the currently opened variable. The duplicate will be added to the list of your variables and '_1' is added to the name.

  6. Canceling will cancel all your changes and you exit the edit view for the variable.

  7. Saving will apply your changes to the variable you were just editing.

Note

Nested variables are not supported.

Creating a static value variable
20873369.png

Static value variables calculate the PQL statement you define and store the value. This static value can be reused all over the analysis. The calculation will respect the analysis loadscript but ignore component and sheet loadscripts and ad-hoc selections.

  1. The defined variable name will be used to call the variable in the rest of the analysis. Spaces and special characters are automatically replaced by '_'.

  2. There are two types of variables. You can switch between the types with the available dropdown.

  3. The PQL statement defined on the function input will be evaluated to the start of each session.

  4. Refresh the preview if you change the PQL statement.

  5. You can also use the full function editor to create the PQL statement.

  6. Remove the variable with the remove button. (Only available if the variable was saved once)

  7. Duplicate the currently opened variable. The duplicate will be added to the list of your variables and '_1' is added to the name.

  8. Canceling will cancel all your changes and you exit the edit view for the variable.

  9. Saving will apply your changes to the variable you were just editing.