Celonis Product Documentation

Connection (Celonis User) (required): Add your Celonis User connection. The user should have USE and ADMIN permissions on the Data Model that should be queried.

Data pool (required): Select the Data Pool which contains your Data Model.

Data model (required): Select the Data Model you would like to query.

Columns (required): Add the columns that you would like to query. You can add a column from the Data Model or write a PQL expression. You can change the order of the columns, define column names (alias) and adjust format as well as unit.

Filter(optional): Define filters. Example: FILTER "Table"."Column" = {Placeholder for Parameter}

Sort by (optional): Sort the rows according to one column (ascending/descending).

Limit (optional): Limit the number of rows. If left empty, 'Limit' will default to 50.

Connection (Celonis User) (required): Add your Celonis User connection. The user should have ADMIN permissions on the Data Model that should be reloaded.

Data pool (required): Select the Data Pool which contains your Data Model.

Data model (required): Select the Data Model you would like to reload.

Force complete reload (required): Define if you want to reload from cache or force a complete reload.

Application Key (required): Create an Application Key in the team settings and grant it permissions to USE the analysis you would like to create the report from.

Type (required): Choose if you would like to create a pdf report from an analysis in Process Analytics or Studio.

Analysis (required): Select the analysis you would like to create the report from.

Sheets (required): Select and order the sheets you would like to include in the report.

Output (required): Choose the output type of the report. Select 'Download Link' to create a publicly available link. Choose 'Base64 String' to create Base64 encoded content. Base64 encoded content is e.g. needed for email attachments.

Filter (optional): Define the PQL filter that will be passed to the analysis.

Width (optional): Adjust the width of the PDF based on the sheet width. Default: 1920.

Height (optional): Adjust the height of the PDF based on the sheet height. Default: 1080.

Device Pixel Ratio (optional): The ratio of the resolution in physical pixels to the resolution in CSS pixels. Default: 1.

Header (optional): Define a header (as HTML content) that will be shown on each page.

Footer (optional): Define a footer (as HTML content) that will be shown on each page.

To (required): Define who this email will be sent to. You can add multiple email addresses by separating them with a comma.

Subject (required): Define a subject for the email.

Body type (optional): Choose a body type for your email e.g. Plain or HTML. If you choose the HTML option, you can format the email using HTML tags.

Body (required): Define the body for the email.

CC (optional): Define who will receive a copy of this email. You can add multiple email addresses by separating them with a comma.

BCC (optional): Define who will receive a blind copy of this email. You can add multiple email addresses by separating them with a comma.

Reply to (optional): Define an email address to which the recipient can reply to (if different from your default email address).

Attachment file name and content (optional): Add attachments to your email. Make sure to have file name with extension (e.g. Report.pdf) and attachments content encoded in Base64.

Program Name (required): Define here the name of the program (.bat or .exe file) on the server that should be executed.

Arguments (optional): You can define up to 9 arguments that can be submitted into the local program.