Skip to main content

Load Scripts

Analysis - Maintenance only

Effective August 1st 2025, Analysis features can no longer be purchased as part of a Celonis Platform license. Celonis continues to maintain Analysis (by fixing bugs and ensuring that performance remains strong) but no further feature development will take place.

You can migrate your existing Analysis assets to our enhanced Studio Views, giving you access to our intuitive View creation capabilities. To learn how to migrate your existing Analysis to Studio Views, head to: Migrating Analysis to Views.

And for an overview of our enhanced Studio features, see: Studio feature availability matrix.

  • Load Scripts are scripts that automatically run when the analysis is loaded.

  • With them, you are able to assure, for example, that your analysis always begins with a certain filter applied or with a selector option displayed.

Manage Load Scripts

20873317.png
20873318.png

  1. Load Scripts can be managed in the analysis settings in the tab: Load Scripts.

  2. Define the Load Script using PQL statements in the text box. If more than one script is applied, they should be separated by a semicolon.

  3. The add column section aids the input of Load Scripts. It allows the user to select a column from the connected databases and returns a default script based on it.

    The default script has a format: FILTER "TABLE_NAME"."COLUMN_NAME" <op> <value>

  4. The documentation shows the possible values the <op> (operator) might assume in the Load Script formula.

  5. Here you can find examples of useful Load Scripts formulas. Remember to replace the table names and columns according to the ones of the data tables connected to your current analysis.

    Caution

    It is not possible to use VARIABLES in the analysis load script. You can use them in sheet or component filters but not in the load script within analysis settings.