Skip to main content

Product Q&A

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

3152 Topics
yuyao.wang13
Level 3
yuyao.wang13Level 3
asked in Process Analysis
Inquiry on Best Practices for Building an Overview View with Data from Multiple Data Models

Dear all,I am currently working on building a view for the management team to track KPIs across the entire organization. The organization consists of multiple entities, each using different systems (e.g., SAP, MSSQL, etc.), and as a result, we have multiple data models in the backend.In the overview view, we want to visualize data from these different models in a single interface. I have created a space that contains one view and multiple knowledge models. I would like to confirm whether this approach aligns with best practices and if it is possible to achieve my goal with this setup.Looking forward to your insights.Thank you,Yuyao

817
bunyod.sap
Level 4
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. 

353
bunyod.sap
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

231
jakob.hanse
Level 2
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?

371
manuel.wetze
Level 5
frederick.coutr12
Level 3
frederick.coutr12Level 3
asked in General Product Q&A
Transformation Hub roadmap

Hi everyone,We’ve recently started trying the Transformation Hub, which looks like a fantastic tool for tracking the realization of value. While exploring its capabilities, we’ve noticed a few limitations (though we might be mistaken, as it’s still new to us).Is there a roadmap available that outlines when new features might be added? Specifically, we’re curious about the potential inclusion of:Custom processes Custom objective types Custom currencies (e.g., $CAD) Ability to track value based on something else than a financial amountThanks in advance for your guidance and any updates you can provide!

362
frederick.coutr12
Level 3
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

200
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

262
S
Celonaut
louis.forst11
Level 2
louis.forst11Level 2
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 :)

571
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?

241
S
Celonaut
louis.forst11
Level 2
louis.forst11Level 2
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

182
louis.forst11
Level 2
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 

371
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

235
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:  

90
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 

372
mark.langa
Level 3
jesus.herna
Level 2
jesus.hernaLevel 2
asked in General Product Q&A
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)

 

140
jesus.herna
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: ""

310
rahul.awast12
Level 2
AllstateCelonis
Level 2
AllstateCelonisLevel 2
asked in General Product Q&A
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!

522
janpeter.van.d
Level 8
vamsimadhavg
Level 2
vamsimadhavgLevel 2
asked in General Product Q&A
Need to Trigger Action Flow for Last Refresh Date

I am trying to make an action flow which gets triggered when the data load is more than a day old i.e., when the data load failed, and we are unaware of the failure. Current problem is that I am able to get the last refresh date from event log which is the MAX of the time stamp but to put a trigger to see if the MAx is more than a day old, the FILTER function in general does not allow aggregations. Is there a way out of it or any other path that can be taken to create an action flow to trigger a mail if the last refresh date is more than a day old.

382
vamsimadhavg
Level 2
vamsimadhavg
Level 2
vamsimadhavgLevel 2
asked in General Product Q&A
Merge two parallel paths in action flow

Hi, I am trying to query data in Celonis module in the Action flow . However, I have requirement to split the data into two paths and then prepare a csv and then merge it back into one using a text aggregator. Is there a module that can merge paths in action flow. Or is there a way to split data based on filters and merge or append it into one file

250
vamsimadhavg
Level 2
thomas.keim
Level 4
thomas.keimLevel 4
asked in General Product Q&A
New Studio: Table component "calculate share in percentages"

Hello Community,I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:Within “Analysis” the table component has the function “calculate share in percentages”.Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.How does it work in the new views?Thank you so much for help.Best, Thomas  

862
thomas.keim
Level 4
KenshiroYasu
Level 2
KenshiroYasuLevel 2
asked in Process Improvement
How to use a trigger with Watch Trigger

Hi, I am just learning about Trigger with Action Flow in an academy.But I am in a trouble how to use a trigger for Action Flow that I made in KM.After making this, I tried to use it but It could not be shown in a setting field.How do i solve this problem?  

781
W
Celonaut
michael.kohlm
Level 2
michael.kohlmLevel 2
asked in Process Intelligence Graph (PI Graph)
Merging CSVs

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.

382
michael.kohlm
Level 2
wein.nadin
Level 3
wein.nadinLevel 3
asked in Process Improvement
Hide/Unhide Tabs in new Views

Hello,  do you know if it’s possible to hide/unhide tabs in a new view as a business user in apps?  

321
S
Level 3
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in General Product Q&A
concatenating in data jobs

Hi Everyone. I am trying to create a table in Data Jobs, but I want two zeros infront of a number.  nothing I try works? what could the issue be? See ‘00’||”COL-1” 

40
bennita.dutoi12
Level 4
preena.nair
Level 2
preena.nairLevel 2
posted in Process Analysis
Process order/Production order

what insights generation can be done for production order

270
preena.nair
Level 2

Badge winners

VIEW ALL
Community Code of Conduct