Product Q&A

Hi All,I am trying to use OCPM catalog to build a procurement process, currently I am having 3 databases SAP ECC, S4 and ariba. The issue here is that when I am selecting the database ariba/S4 then also I am getting the option to select the transformations for only SAP ECC. Is there any way to get the s4 and ariba transformations itself for the respective databases. Thanks,Akshay

Hello everyone,I understand that the button dropdown is still not available in the new Views. Has anyone managed to recreate a similar functionality? For example in the analysis I have two button dropdowns and for each one of them I have manually inputted 5-6 categories (Local Supplier, Company Code, MSGK, PO number etc.). Each category is updating two variables (one is for the name of the column and other is PQL calculation in OLAP table). Categories from button one are updating variables in column A while the categories in button two are updating variables in column D. I need to achieve something similar in the new Views, but the documentation for the Input Dropdown isn’t entirely clear to me. Has anyone implemented this successfully? If so, how did you manage it?Thanks in advance for your help!

Hello everyone,I would like to create option for users where they can leave comments. I would like for this option to be connected to a chart (let say it’s a chart showing number of blocked documents per month) and I would like to allow users to leave comments for February (number of blocked documents was really high compered to other months). But the issue is that for comments and augmented attribute identifier needs to be unique and I cannot configure it. So if someone has some idea I would be grateful.  Also in documentation they configured comments with variables but when i put variable for DOC ID (VIM_1HEAD.DOCID) and use that variable as identifier it’s not working. Any idea what should be put there? Thank you!

Can we change Data model of an existing Knowledge model? As I am trying to change the data model, I am getting Data model fail notification.

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

How do I see the replication cockpit also along with the data job. How do i set the change table and trigger for it?

Hi team,I need help in understanding how to apply filter for KONP table in data extraction joining another table.My requirement is:1.For A018 table - I need all the records where A018.MATNR =  EKPO.MATNR.2.For KONP table, all the records from KONP table where A018.KSCHL = KONP.KSCHL If i am trying to implement 1st point in filter condition of A018 extraction as screenshot below,Data extraction fails with error : Error loading resource A017. The multi-part identifier "ts1.EKPO.MATNR" could not be bound.Can you please help in this? Thank you in advance.

I DID THE WHOLE PROCESS IN MY DATA POOL, FROM UPLOADING A FLAT FILE TO THE DATAMODEL WHERE I HAVE NO ERRORS, HOWEVER IN THE VIEWS WHEN CREATING A TABLE VIEW IT ONLY BRINGS ME THE HEADERS

Hi Guys, what’s up ? I wanted to ask if there is any way we can selection multiple attributes in new views and update variable based on it. Currently, the ‘multiple’ option is disabled for attribute selection. I tried with free text but it just adds additional single quotes in beginning and end of the string, so those single quotes should be removed to consider it as table and fields. for ex. “table”.”field” is considered as ‘“table”.”field”’.  

Buenos días necesito saber si es posible utilizar CELONIS para realizar análisis de dato o información para obtener INTELIGENCIA en el ámbito militar, lo que me permitirá mejorar el proceso de toma de decisiones 

Hi all, In the case explorer, in YAML or Views, how can I change the Throughput Time and use my own formula in PQL?Thanks for helping.Br,Leonardo

Good morning all, I need assistance with PQL to compare the timestamp of a certain activity of case A with the timestamp of another activity of case B, has anyone done this before?

Hello,My goal is to create a filter which, after clicking, will only show cases which contain specific activity in them. In my case I want to include all cases which do contain activity with string ‘reject’ in the name of activity.I’m trying to create a filter with this expression:  FILTER MATCH_PROCESS_REGEX ( "_CEL_MERGED_ACTIVITIES"."ACTIVITY", 'X' >> LIKE '%reject%' ) = 1;             Although it does not seem to be working.How can I create and apply a filter to show only all cases which do have such activity?

I have event log as leading_object_id activity_name resource1 Create Invoice A1 Approve Invoice Z2 Create Invoice A2 Create Invoice B2 Approve Invoice BI want to write PQL query (KPI) such that I get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice. How can I achieve this?

Within an OLAP table, I would like to use both the Delivery Line Item Date ("VBEP"."EDATU") and the shipment gross weight ("LIPS"."BRGEW") Does anyone know how I can apply a PQL function to combine these tables? Please find the error below. I looked into the PQL documentation but I can't find the solution. Error in formulaNo common table could be found. The tables ["VBEP"] and ["LIPS"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [VBEP]N <-- 1![VBAP]!1 --> N[VBFA]N <-- 1[LIPS]. For more information on the join path, search for "Join functionality" in PQL documentation.

We are working with a prospect who uses JDE and he requested us this information.

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? 

Hi all, Since a short while we see the option eventlog automerge in the data model overview (see attached screenshot). However, this is not mentioned in the Release Notes or online documentation. Does somebody knows what this option is for? Thanks in advance! Bests, Jan-peter! Celonis_Automerge|690x150

Hello everyone,I have a list of Material Numbers, and some of them belong to the P18 Business Unit, some to the P20 Business Unit, and some belong to both P18 and P20 at the same time.I created a Quick Filter to show only the materials that belong to P18, and it works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')I did the same for materials that belong to P20, which also works correctly:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')However, when I try to filter for materials that belong to both P18 and P20 at the same time, the following filter does not work correctly — it also shows materials that belong only to P18 or only to P20:FILTER "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P18')AND "o_celonis_MaterialMasterPlant"."ID" IN_LIKE ('P20')Do you have any idea how to fix this?Thanks! 

Hello,To better analyze the Service Now process (a very complex process with many parallel tasks and loops...) in Celonis, is it preferable to use the pm_project and pm_project_task tables or the sys_audit tables?Thank you,

I am working on an intercompany transaction where one subsidiary of the parent in buying material from a vendor which is a subsidiary of the same parent. Hence O2C-AR of the buyer should be synced with the P2P-AP of the vendor.

I want to visualize end to end process of a buisness; order received → purchasing begin→ production → payments to vendors → order shipped to customer → cutomer payment receivedhow i can connect in SAP all this O2C to P2P; what are common tables to link all this

Dear Community,I want to calculate an average error rate for each year under certain conditions. Even though it may seem quite simple, I receive an incorrect result. 🤔This is my formula:COUNT (DISTINCT (“Table”.”Column”))/COUNT (DISTINCT (“Table”.”Column”)). The KPI “2023” has the following conditions as filters: Do you have any idea what is wrong with my formulas? Many thanks and kind regards,Varvara

Hello Community,I hope you can help me to find the best approach of my issue. My challenge is to build a table with the complete SAP Process Flow: Order, Delivery, ShipmentFor this I have created a data model with the following linked tablesVBAK (1) - (N) VBAP (1) - (N) LIPS (N) - (1) LIKP (1) - (N) VTTP (N) - (1) VTTK When I try to add fields from all tables into one studio table I get the following error:I have understand the problem but missing the best approach to solve it.What do you think? Is the a studio table with different PQL formulas the solution? If yes, how can I do it?Or is it better, when I create a table (e.g. TAB_PROCESS_FLOW) within the transformations that includes all the key columns and connect the other tables (VTTK, VBAK...) within the data mode

I am using the free version and custom functionality.Have two event logs and trying to create two flows with transition using the process explorer.Data model, KM, Data Explorer everything is working.  In the KM link between logs is enabled. In Views - Process explorer , it shows two flows. but the transition is not showing so trying to enable the configure transition in the Transition toggle and getting the error as Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables1.What should be data structure.?2.Do we need same event in both logs?3.How does multievent log works with Transition enabled in backend.