Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4433 Topics
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in Process Analysis
snapshot

Hi There, does anyone know if Celonis can take snapshots of values? We determine inventory but its always the newest and latest figures and I cant find a proper data to use for a timeline graph of inventory. So I was wondering if its possible for Celonis to take a daily snapshot of a figure for use in a graph. 

433
bunyod.sap
Level 4
eby.t12
Level 2
eby.t12Level 2
asked in Process Intelligence Graph (PI Graph)
OCPM for a Website Journey

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?

160
eby.t12
Level 2
C
Level 2
carlos.meizo12Level 2
asked in General Product Q&A
Has anyone implemented JD Edwards P2P connector? I need to understand how it works and recomendations coming from real project experience.

Has anyone implemented JD Edwards P2P connector? I need to understand how it works and recomendations coming from real project experience.

205
denis.pede12
Level 3
amy.marti
Level 2
amy.marti
asked in Process Analysis
Adding a total line to a table

I’m trying to add a total line to a table in Celonis, similar to a total line in an Excel pivot table. In my table, my first column is a dimension and the rest are aggregated KPIs. But my end user needs to see the overall total, too. Any thoughts?

511
muthappan.alaga
Level 4
jakob.hanse
Level 2
jakob.hanseLevel 2
asked in Data Ingestion & Infrastructure
Staging Table for inserts in Replication Cockpit

Hi,We have a scenario where records can be created/deleted in source system multiple times.We are currently using the replication cockpit for extracting changes, but for deleted records we do not get the full information of the deleted records, we only get the primary key of the table and a change indicator = ‘D’ (Deleted) and we would like to know what the values of all the attributes for the specific records were prior to the deletion. We have located the following staging tables and views:_CELONIS_TMP_{TableName}_NEW_DATA  _CELONIS_TMP_{TableName}_TRANSFORM_DATA {TableName}_DELETED_DATA Unfortunately, it seems like the _CELONIS_TMP_{TableName}_NEW_DATA table only includes records with change indicator = ‘U’ (Updates) and not change indicator = ‘I’ (Inserts). This makes it difficult for us to map what the historical values were, if we have both inserts and deletions within the same execution of the replication cockpit.Does anyone know of a staging table for inserts we can use, befor

381
jakob.hanse
Level 2
sivasakthi.dhand
Level 3
sivasakthi.dhandLevel 3
asked in Process Analysis
Filter using parameter in view not working in object centric data model table.

I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'

271
sivasakthi.dhand
Level 3
Ayushi
Level 2
AyushiLevel 2
asked in Process Intelligence Graph (PI Graph)
Adding custom KPI in OCPM process explorer

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

571
manuel.wetze
Level 5
marcus.sturs11
Level 2
marcus.sturs11Level 2
asked in Process Analysis
Calculate Average Activites for similar cases

Hello all,I am struggling to calculate the average count of activities for similar cases. The calculation returns a wrong result. It doesn’t matter if I use PU_COUNT on the activity table or CALC_REWORK. Example DataCase ID Parameter Number of Activities in Activity table 1 A 10 2 A 10 3 A 20 4 B 15  I would like to know the amount (count) of process steps (activities) on average for cases with a certain parameter.Expected ResultParameter Average activities count A 13.33 ((10+10+20)/3) B 15 (15/1)  What I getDimension: ParameterKPI:  AVG(CALC_REWORK())Parameter Average activities A 15 B 15  It does consider the ‘10’ activities for case 1 and 2 only once. So if the number of activities is the same for multiple cases (which might very well be the case), the calculation is wrong. If I remove the Dimension, I get the correct overall result of 13.75. But as soon as I add the Parameter as a dimension (which I need), the result is not correct anymore

250
marcus.sturs11
Level 2
raman.silot11
Level 3
raman.silot11Level 3
asked in Process Improvement
Action flow tracking

Hey, I can see that we have alert subscription option for action flows. But can we get the error information somewhere for each email sent ? I am currently working on creating an action flow tracker, for which I want to track and visualise the number of emails sent with each action flow stream and what error that action flow stream faced that too. Let me know if any ideas for the same. Thank You

422
S
Celonaut
louis.forst11
Level 3
louis.forst11Level 3
asked in Process Improvement
Push CSV to Data Integration via Sharepoint

Hi all, is it possible to alter the push csv to Data Integration but instead of using one drive using sharepoint. I tried it but it always tells me that file cannot be found. Also the id that i have to use for the make a request in the documentation does not exist Push CSV to Data Integration (celonis.com).Thanks in advance :)

831
S
Celonaut
carmem.caval
Level 3
carmem.cavalLevel 3
asked in Process Improvement
Anyone now if there is a way to delete files from sharepoint using action flow?

I'm using a SharePoint connector and the Microsoft 365 module to read data from XLSX files. These files are constantly updated, and I needed a way to get rid of them after a certain time. I know that Microsoft 365 has a function to delete a table, but it deletes a sheet, not the whole file. The SharePoint module has a "Delete an Item" action, but it doesn't seem to bring the correct files. Is there a way to do this? If not, is there a way to move files from one path to another inside SharePoint, still using only Action Flow?

331
S
Celonaut
sagar.belur
Level 2
sagar.belurLevel 2
posted in General Product Q&A
Calculate a KPI without affected by change in Dimension

Hi,I am working on a KPI (A), which is calculated based on the result from another KPI (B) but this KPI (B) should not affected by Dimension selections. Do you know if this is possible? Thanks

211
mathijs.lende12
Level 3
louis.forst11
Level 3
louis.forst11Level 3
asked in AI
Coding in the Academy Studio

Hi all, is it possible to code in the Academy Studio or not. For me it always show that there is no data model or data pool that i can use. Thanks for your helpbest regards Louis

332
louis.forst11
Level 3
johannes.mayr12
Level 2
johannes.mayr12
asked in Process Analysis
Combine two similiar objects to simplify analysis

Hey community, Is it possible to combine two ocpm objects with each individual eventlog to combine into on object & eventog?My szenario is that i have two objects for two different type of documents. They have the same structure and events but they are not named same as each event ends with they name of their type.And i want to perform on both the same analysis and i am looking for a way instead of duplicating all analysis and adapting the kpi to simply my it. So both less duplicate work for me and easier for the enduser to work with. Is there like a “union” function to join them or is it possible with a parameter to switch the object/eventlog in a view? Thanks in advance 

531
S
Level 3
R
Level 2
rithu.kaLevel 2
asked in General Product Q&A
how to change the nanme

how to change the nanme

245
Kandregula Susmitha
Level 2
lucas.diniz
Level 2
lucas.dinizLevel 2
asked in Process Analysis
How to change data model in Duplicate Checker APP

I extended my duplicate checker perspective, add the objeties what i want, and change my data model variable to my data model extended, but my view warns are records missing, these records have “aug” in the name. Anyone know how to change my data model to my data model extended and create these records missing?my perspective extended:the error when i change my data model:  

120
lucas.diniz
Level 2
mark.langa
Level 3
mark.langaLevel 3
asked in Process Management
CPM - Link to Scenario

Hello,I’m trying to create a link in the editor that directs to a specific scenario. The only method I know is to copy the link to the scenario, but when clicked in Navigator, it opens in a new tab.Is there a way to create this link so it stays within the same screen? Edit the link in Editor 

552
mark.langa
Level 3
leon.boere
Level 2
leon.boere
asked in Data Ingestion & Infrastructure
How to Exclude NULL Values in a CASE WHEN Statement in PQL?

Hi All,When using a case when statement how would I go about excluding all the values which are not true from the result.Lets say:CASE WHEN PROCESS EQUELS 'A' -> 'B'THEN 'A to B'WHEN PROCESS EQUELS 'C' -> 'D'THEN 'C to D'Now I'm only interested in plotting the values fall in the 'buckets' basically. How do I exclude the rest which are NULL (very large number of cases).

430
leon.boere
Level 2
omomadia.kagho12
Level 2
omomadia.kagho12Level 2
asked in Data Ingestion & Infrastructure
How can obtain the total number of invoice, PO, and line items in an aggregate expression

Hi all, I am using the COUNT function to get the total number of invoices, PO, and line items that fulfill the conditions in the code statements. The problem is the KPIs I am using were created using COUNT functions, which makes it impossible to get the total numbers by nesting the entire code in another COUNT function. This gives the error message:  Aggregate expressions cannot be nested inside aggregate expressions. Does anyone have an idea how I can resolve this issue? The code is added also. 

290
omomadia.kagho12
Level 2
jesus.herna
Level 2
jesus.hernaLevel 2
asked in Process Analysis
When i try to create an augmented attribute in the new views experience it gives me the error variable[0]. value, does anyone know how to solve it? (there´s already an identifier in the data model)

 

160
jesus.herna
Level 2
milan.eric
Level 3
milan.ericLevel 3
asked in Process Intelligence Graph (PI Graph)
Knowledge Model added a record to the Base and now I can not remove it

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:   But when I ppress “Go to Data Model” it does not actually exist in the BackEnd (obviously, since it doesnt exist).But how do I get rid of this record? It annoys me that it exists and I can not do anything about it… Thank you!Sincerely, a very confused new Views-User

501
milan.eric
Level 3
milan.eric
Level 3
milan.ericLevel 3
asked in General Product Q&A
Bill of Material structure in Celonis

Hello everyone, we currently want to display the Bill of Materials Hierarchy in Celonis.The issue with that is, that the hierarchy is not present in any SAP-Table. But instead in the related tables MAST and STPO.I have the MAST which has BOM and Material (component) relationship which needs to be traversed to STPO with the BOM-Nr. to identify the compenents and each component may be split into sub materials and new BOMs which needs to be looked up in the MAST for its BOM again and it goes on and on. Up to 4 levels deep.So the 4th level has no relationship to the first level. This recursive issue with inputing the results from MAST into STPO into MAST into STPO… is not possible in the FrontEnd (I assume).I am going crazy with knowledge models and action flows, the documentation is absolutely horrible. So it probably needs to be done in the data model itself. Additionally we want to add the Vendor from open orders from the EKPO. So we can filter for a material and for a vendor to so the

702
milan.eric
Level 3
priyank.gandh11
Level 2
priyank.gandh11Level 2
asked in General Product Q&A
How can I change the implicit Left Outer Join in Celonis

Col 1 and Col 2 are the two columns in the OLAP table I'm attempting to generate.Where Col 1 from Table A can have 0 or many values associated from Col 2 of Table B.The cardinality of Tables A and B is (1:N). Currently in place-Values in Col 1 of Table A that have no value associated with Col 2 of Table B are excluded from the OLAP table. What I hope to accomplish-Values in Col 1 should be shown, and values that have nothing related with Col 2 of Table B should have (Null/-) displayed in front of them. The Join Functionality of Celonis does Left Outer Join, and considers the (N) side table (Table B) on the Left Side implicitly, while I want it to be the other way round. Thank You! Regards,Priyank 

410
priyank.gandh11
Level 2
rahul.awast12
Level 2
rahul.awast12Level 2
asked in Process Analysis
Select All check box not appearing in filter dropdown option in views YAML

I am working on creating views and created Filter check box with on click option , but  Select All checkbox is not coming at right side.Below is the YAML I am usingid: dropdown-list-60b99e03-3e73-459b-87be-9d51464f35type: dropdown-listsettings:  data:    columns:      - id: c3c70431-d853-4ff1-95ac-50bc70a226ff        order: 100        onClick:          update:            selection: multiple            variables:              - name: target_attribute_name1        attribute: TABLE_1_2.TARGET_ATTRIBUTE_NAME        displayName: ""

390
rahul.awast12
Level 2
AllstateCelonis
Level 2
AllstateCelonisLevel 2
asked in AI
PyCelonis functionality question

I am working on a script in PyCelonis to search assets and compile a list of the data models/Knowledge models that the assets are using, with the aim of non manually figuring out which DM/KMs are currently in use by production assets.  Using PyCelonis I have been able to navigate down to the asset level and find lots of information for each asset, but have so far not found anywhere that you can identify the DM/KM an asset is built on. The “.dict()” function provides a lot of information and I thought would be the intuitive place to include this kind of information but it is nowhere to be found, except when the asset is a view and the KM gets referenced in the yaml code that is provided in “.dict()” Does anyone know if this is information that we can pull from PyCelonis? And, if so, how to find this information on the asset level? Thanks in advance for your help!

672
janpeter.van.d
Level 8

Badge Winners

  • First Post
    lisaschneiderhas earned the badge First Post
  • Value Realization Expert
    Pablo MChas earned the badge Value Realization Expert
  • Qualified to Deliver Business Value with Celonis
    Pablo MChas earned the badge Qualified to Deliver Business Value with Celonis
  • First Post
    maxim.vnouthas earned the badge First Post
  • Celonis Certified Data Analyst
    akmal.farhahas earned the badge Celonis Certified Data Analyst
VIEW ALL
Community Code of Conduct