Skip to main content

Celonis Product Documentation

Using helper objects in an object-centric data model

Your object-centric data model can include standalone helper objects that provide reference information to PQL functions. The Celonis catalog processes include the CurrencyConversion and QuantityConversion helper objects which you can reuse. You can also create and include your own reference tables, and other types of helper object such as lists of values.

These PQL operators use reference tables that you can include as helper objects:

  • FACTORY_CALENDAR - uses a calendar table with columns for the identifier, start date, and end date

  • WEEKDAY_CALENDAR - uses a calendar table with columns for the identifier, weekday, shift start time, and shift end time

  • WORKDAY_CALENDAR - uses SAP’s TFACS table

  • QUANTITY_CONVERT - uses a quantity conversion rates table with columns for the conversion rate identifier, from unit, to unit, and conversion rate

  • CURRENCY_CONVERT - uses a currency conversion rates table with columns for the from currency, to currency, conversion rate, from date, to date, exchange rate type, and source system identifier

  • CURRENCY_CONVERT_SAP - uses SAP’s TCURR, TCURF and TCURX tables

You can also create helper objects to look up long lists of values, such as match lists for the IN operator.

Here’s how to include a reference table as a standalone object in a perspective:

  1. In the Objects page of the Objects and Events UI, create a new object type by clicking Create, then Model from scratch. Give the object type a suitable name (for example, FactoryCalendar).

  2. Add an attribute to the object type for each column of the reference table, and save the object type.

  3. Click the Transformations icon in the new object type’s sidebar, and click Add Transformations. Follow the instructions in Creating custom transformations to populate the object type with the data from your reference table.

  4. Add the object type to the perspectives where you want to use the reference table. Follow the instructions in Extending Celonis perspectives if you’re adding it to a Celonis catalog perspective, or in Creating custom perspectives and event logs if you’re editing a custom perspective.

When you publish your changes, we’ll add the reference table to the data model for the perspective, and when you load the data model, we’ll populate it with your data.