Process Intelligence Graph (PI Graph)

I created a ‘Status change’ event in OCPM and I can’t establish an order for the events that have the same timestamp. The script looks like this (I simplified it to be easier to understand):SELECT DISTINCT 'MeldungGeneralEvent_' || meldung_objects.QMNUM || JCDS.STAT || JCDS.UDATE || JCDS.UTIME AS "ID", 'Meldung_' || meldung_objects.QMNUM AS "Meldung", 'Meldung Status Changed' AS ActivityName, COALESCE(SS.TXT04, US.TXT04) AS ActivityStatus, CAST(JCDS.UDATE AS DATE) + CAST(JCDS.UTIME AS TIME) AS "Time", CASE WHEN COALESCE(SS.TXT04, US.TXT04) LIKE '%EGPR%' THEN 33 WHEN COALESCE(SS.TXT04, US.TXT04) LIKE '%MMAB%' THEN 34 ELSE 32 END AS Sorting,FROM meldung_objectsTo give an example, I select only the activities for Meldung number “748291035”:

Hi - Is it possible to export the process explorer to an external site?

Hi everyone,we are using Object Link functionality to link Manufacturing Orders. In order to show the relevant predecessors and successors of one selected order (order number is written to variable aufnr) we filter as follows:This selects the respective order, but also all predecessors and successor orders.However, in this case, we only want to see the orders, that are created in the same plant, not from previous plants. E.g. in the following examples, the 2 first orders 1 and 2 of Plant A should not be selected, if the variable is set to Order 6.What is the best practice to filter in this case?Thank you, BR Philipp

Hi Everyone! Is there a way to download the BPMN model from Process Explorer (New Views) so that I can use it in PAM?

Shipped Not Invoiced App version 1.0.0 (2023-08-01) App version now available for object-centric process mining A Shipped Not Invoiced app version that supports object-centric process mining is available now from the Celonis Marketplace. The object-centric version of the app uses the Order Management perspective that’s supplied with our object-centric data model. Before you set up the object-centric version of the app, you’ll need to load the object-centric data model with your data and validate the Order Management perspective. The app uses the objects and events that you’ve already built from your source system data and stored in the OCPM Data Pool. To get started, see Quickstart: Extract and

Hello!!Does anyone know if it is possible to generate a document with the complete documentation of an OCPM-Model (Objects, Events, Relationships (O2O & E2O) and Transformation Scripts)?Thanks and best regards,Pablo

I am struggling to access tables from the Global Scope in an object that is based on a data connection. While I see a parameter selection that allows me to access tables from different data connections, I cannot find the right parameter to access a table that is house in the Global Scope. Is there a way to reference the global scope correctly? 

How can you configure the sorting of activities in OCPM?

Hi CommunityAny possibilities to change the object colors in an object centric graph? 

Hi Celonis Community,I’m trying to get a better understanding of what is in the OCPM Catalog. I’m hoping to extract all the objects and events, their attributes, etc. and build out some documentation in the event I need to adopt the OOTB solutions. There doesn’t seem to be an export button or a way to pull out that information. Has anyone found a way to get this information out of Celonis? Thanks!Matt!

 Hello guys,I have a varchar column in my database and i would like to replace before the values “SU” in vendor table. I try to use the function INSTR but its not working in OCPM.Kindly please let me know  what is the function to be used to remove before values for SU.Few are the examples below : GHYSU10001049331000SU100014329022SU1000003141  

Hello Community,I would like to give my users the option to display an amount (e.g. freight) in any currency. To do this, I use the function CURRENCY_CONVERT_SAP and pass the target currency via a variable. This works perfectly.My problem is the unit: Do you know of or is there a way to use my variable in the unit field so that the selected currency is automatically displayed as the unit?Thank for help, Thomas  

Hi Celopeers!Anyone knows about Knowledge Hub release? Regards!

Hi all, We have installed the ‘Open Order Processing App’ on an Object Centric Data Model (OCDM), and using the latest version, built in the Enhanced Studio. The app was installed on the ‘Test’ OCDM, and in the Tasks Management view, you see all the predefined tasks (we added ‘Approval Block’ ourselves). See screenshot below.  When we update the OCDM of the Knowledge Model where the triggers are in, and publish the asset, all tasks disappear (I’ve added the approval hold again manually): This is in some way logical, since the triggers for the tasks are linked to a data model and not to a knowledge model. However, it’s quite disturbing, because switching from Test and Pro

In OCPM ,  How do we merge two objects into one object ?

How do I calculate the Cycle time in OCPM, when my process starts in one object and ends in another?I tried PU functions + bind but I didn't get good results. If anyone can help me I'd be grateful.

Hi all,What are your methods to crosscheck all information is correct in a Studio View?Using Variables and the Knowledge Model is a very important practice, when changing formulae in the KM, then the components automatically update.However, when using a KPI from the KM is not possible, how do you ensure consistency throughout different tabs? How do you guarantee to the users that they won’t find any misalignments or mistakes?Is there a specific methodology at hand, besides suggesting a manual check tab-by-tab?Thank you for your guidelines.

I have built process maps using OCPM. When event timestamps are equal for more than one activity, the events are sequenced based on alphabetical order of event names in process explorer. This is misleading and does not make sense as it is supposed to be in the sequence of sort order.Is there a way to configure sorting order based on sort column when events timestamp are equal?

Hi All,I’ve following error message when trying to reload the OCPM data model: The Data Model Load experienced an issue with the Data Pipeline Orchestrator. Celonis Support ID: 22950f46-9f10-46af-96de-887c2e2d81a5 Does anyone know what could be the issue here? Thanks,Sunil

I’m trying to build a Website journey with OCPM. I expect to have various objects like Web Object, Order Object, etc in the flow. Considering just the Website frontend, in case centric approach, to show the traversal throught the various webpages, I could imagine having the webpages as the activity, however when moving to OCPM, I’m wondering how the scenario should be modeled. Since (I assume) the webpage traversal would be events affecting the Web Object itself and there is a possibility that there is far too many webpages to manually keep adding to events, is there a better way of building this journey with OCPM?

How to add a custom KPI in the OCPM process explorer?

Hello everyone, not sure if this is a bug but I am very new to knowledge models and views. I only worked with analysises beforehand and I am trying views for the very first time. I somehow added a record here. Not sure how, since I never pressed “Create record”. I tried to create an augmented attribute but it somehow failed. Anyways I am trying to clean up my mess now. This is the newly created record: It is autogenerated and now is included everytime I create a Knowledge Model based on that Data Model: I NEVER touched the BackEnd at all. When opening the DataModel in the preview section, it exists as a standalone table: 

Hello, I have received the data set I want to analyze in several CSV files (due to the row limit of 1 million rows). Now I would like to merge this split CSV data set in Celonis, but I have not found the function to do so. The data set is structured in such a way that CaseID, Activity, Timestamp and other case information are each in one line, as can be seen in the screenshot. Thank you for your help.Edit: Sorry for posting in the wrong category, it looks like it can't be changed.

Everything I’m doing on my OCPM projects (saving and previewing transformations, publishing, running data jobs, loading data models) is taking an obscene amount of time. I’m talking 2+ hours for something that used to take minutes…Is anyone else experiencing this?

Hi all, I'd like to know if we have one time SAP data extractor that optimized for OCPM Core 5 process. I know this extroctor but it is only available for specific case centric data extraction like O2C or P2P. (I also know it is able to extract specific table one by one with it.)https://docs.celonis.com/en/one-time-extraction-from-sap-ecc-or-sap-s-4hana.html Does anybody know optimized extractor for OCPM? (I found data uploader in OCPM data pool.) Thanks in advance,