Skip to main content

Celonis Product Documentation

Validating KPIs for the object-centric Open Order Processing app

The Setup and Validation view is the best way to validate and adjust the KPIs in the Open Order Processing app’s Knowledge Model. If you’ve worked through your use case there but something is still not the way you want it, you can make further adjustments directly in the Knowledge Model in Studio.

The Knowledge Model for the Open Order Processing app is called “Knowledge Model”. You’ll need Analyst permissions on Studio and the Knowledge Model to update it. Each KPI contains a PQL (Process Query Language) formula which you can change in our editor to change how the KPI behaves. Your changes are applied when you publish a new version of the app.

The Knowledge Model also includes calculated attributes that contain the business logic to classify and provide metadata about objects. You can use them in PQL queries as if they were another column in the database table for the object type. They appear in the Knowledge Model as attributes of relevant records. If you make any edits to view components that involve the calculated attributes from the Knowledge Model, we’ll automatically update the calculated attributes in the Knowledge Model to match your edits. You can also adjust them directly in the Knowledge Model before or after editing the views.

Calculated attributes and PQL formulas might be reused in the calculations for several KPIs across the Knowledge Model. If you change the business logic in one location and save your change, all of the KPIs that reuse the calculated attribute or PQL formula will reflect your changes.

The Records section of the Knowledge Model for the Open Order Processing app.

Here’s how to work with the KPIs and calculated attributes in the app’s Knowledge Model. If you need training, check out the training track “Build Knowledge Models and Views” on the Celonis Academy.

  1. In the Celonis navigation menu, select Studio.

  2. In the Studio overview, find the Open Order Processing app in the space where you installed it, and click its tile.

  3. Select the Knowledge Model from the app navigation.

  4. Select the KPIs section of the Knowledge Model to work with KPIs, or the Records section to work with calculated attributes. To see only the records with calculated attributes, and see only the calculated attributes on those records, click the Hide Autogenerated Definitions icon by the search bar.

    The Hide Autogenerated Definitions icon is right after the search bar in the Knowledge Model navigation bar.
  5. To see and edit the full PQL formula and other settings for a KPI, click its row to open an editor. The editor automatically validates any changes that you make in the PQL formula.

  6. If you want a fuller-featured PQL editor that lets you select from the tables and columns in your data, click on the pen icon next to the PQL formula.

  7. If you need to disable a KPI or formula, click the three vertical dots at the top of the editor, and select Disable Scope, then click Disable to confirm. When you do this, the object can't be accessed or used anywhere in the package, including by other apps that depend on it.

  8. When you’ve made changes to the KPIs, use the Publish button at the top of the screen in your Studio space to publish a new version of the app.

Here are the calculated attributes for the Open Order Processing app:

Calculated Attribute name

Attribute ID

Record ID

Description

Open Order Item Indicator

IsOpen

O_CELONIS_SALESORDERITEM

Whether a sales order item is open or closed.

Variable with the due date name:  ${om_date_due_date_text}

DueDate

O_CELONIS_SALESORDER

The next due date for the order (as configured in the app settings).

Delivery Creation

DeliveryNoteCreationStatus

O_CELONIS_SALESORDER

The status of delivery creation for the sales order.

Pending: needs to be created for all items

Partially: created for some items

Done: creation completed for all items

Goods Issue

GoodsIssueStatus

O_CELONIS_SALESORDER

The status of goods issue for the sales order.

Pending: needs to be created for all items

Partially: created for some items

Done: creation completed for all items

Invoice Creation

InvoiceCreationStatus

O_CELONIS_SALESORDER

The status of invoice creation for the sales order.

Pending: needs to be created for all items

Partially: created for some items

Done: creation completed for all items

Overdue Delivery Creation

IsDeliveryOverdue

O_CELONIS_SALESORDER

Whether the sales order is overdue with a missing delivery.

Overdue Goods Issue

IsGoodsIssueOverdue

O_CELONIS_SALESORDER

Whether the sales order has an overdue goods issue.

Overdue Invoice

IsInvoiceOverdue

O_CELONIS_SALESORDER

Whether the sales order has an open invoice after goods issue occurred.

Delivery Block

HasDeliveryBlock

O_CELONIS_SALESORDER

Whether a delivery block exists for the sales order.

Credit Block

HasCreditBlock

O_CELONIS_SALESORDER

Whether a credit block exists for the sales order.

Billing Block

HasBillingBlock

O_CELONIS_SALESORDER

Whether a billing block exists for the sales order.

Missing Price

HasMissingPrice

O_CELONIS_SALESORDERITEM

Whether there is a missing price in the sales order position.

Backorder

IsBackorder

O_CELONIS_SALESORDERITEM

Whether the sales order item is not fully confirmed (1 = Yes).

Prio

Prioritization

O_CELONIS_SALESORDER

The priority of the order, based on where action is most urgently needed. The priority is calculated based on execution gaps for this order. Orders that are due today or overdue have the highest priority. Next are blocked orders (with delivery blocks, credit blocks or billing blocks), followed by incomplete orders.