Product Q&A

Could you advice if it is possible to export analysis from our Celonis cloud environment and import that (data model and visualizations) to other cloud environment? I have been trying to search but have not been able to find clear answer if and how this could done. Thanks!

Hi together, In Celonis Snap it seems that the Anonymization & Pseudonymization feature is locked. Just out of interest, how exactly does the feature look like in the enterprise edition? So it is possible to a.) anonymize (not possible to trace back / recover), and b.) pseudonymize e.g. with custom string or hash (possible to trace back / recover) ? In particular I would like to know whether its possible to trace back information of pseudonymized columns. Thank you in advance! Best regards, Daniel

I want to create an alert which sends e-mail to a group of recipients when the Data Load is successful. Is it possible to trigger an alert directly from Celonis? I can subscribe to a data pool to get alerts on reload failure but not when It is successful. In addition Is it possible to get the Log history of the reloads for analysis?

Hi Community,I was wondering if someone would have the solution to my challenge:I have built an OLAP table with one dimension and multiple KPIs. The dimension is the Country, and the KPIs are the number of entries in the PO table (COUNT_TABLE(case_table)), the number of distinct values of a specific field (COUNT(DISTINCT case_table.field), the total cycle time between 2 activities and then different ratios like automation, change and rework rates which use the activity table as basis. I also show the total value of the POs per country and have used here for statement SUM(case_table.value). Yet, doing so it appears that the calculated value is not correct as it identifies the value of each PO line and sums it up for each activity encountered on the PO lines. The same formula used in a pie chart returns the correct value.When I hide the different ratios in the table, the correct total value is returned.  The first two KPIs with the count of entries also show correct values at any time. I

Hello, how do you deal best with deleted records in Delta extractions? For a set of tables, we see, that delta jobs do not account for records that are deleted in the data source.E.g. when we extract a table and at that specific point in time it has - let's say - 50 records, but in the meantime, 25 of them get deleted, we have different data in Celonis and in the data source. The next delta job will not remove those records in Celonis, but only add changes or new records. Only a full extraction will overwrite the table and in the process of doing so, remove the deleted records.The question therefore is, what is best practice here? What options other than the Real-Time-Extractor and running full jobs daily do we have? Thanks!

Dimensions: Number of reworkKPI1: lead timeKPI2:Number of cases​I can't get the number of cases corresponding to the number of rework. Please let me know if there is a syntax.

Is there a way to calculate all KPIs by considering working days only? e.g. 5 workdays per week? e.g. average case duration would be lesser considering 5 days instead of 7.

I have cleared my Celonis Implementation Professional certification. How do I get the complete certificate/bage?

Hi all,​May I ask for the examination of Solution Professional, we need to submit a Demo for the last test of the certification, right? Is the Demo created by myself? And have to record my screen and explanation on the Demo, then submit the Video file to the system？​​Thanks and Best regards

I'm a developer and I want to learn about the coding aspects of celonis rather than the analyst courses. Can any of the celopeers please suggest to me the courses for that? Thanks in advance😄

Our jobs are running on SSMS. So we are planning to trigger Data model on Celonis after the job is completed using a shell script. I would Like to know if this is possible? Or if there is any other way to trigger the Data model after our job is done?

We have a high interest and demand in the market to use & implement Celonis for helping the clients in migrating to S/4HANA. I reviewed the frictionless system migration (S/4HANA) webinar. it was useful and insightful, it also showed how Celonis can support their clients throughout the different migration phases.  As stated, in the design phase that Celonis can help in Master data consolidation, Testing, and data transformation. but unfortunately, it wasn’t stated exactly in details how can Celonis help throughout the migration in the previously mentioned areas. Thanks in advance.

Hi, We want to calculate process conformance as a KPI in the OLAP table for each company codes, markets etc as dimensions. Two years back Celonis team showed us that this can be done by opening process conformance analysis -> press F12 and then scan the browser logs for certain keywords and use some part of the logs into the OLPA table KPI editor.However, I dont recall all the steps but would like to understand if someone can share these steps again that would be really helpful. We have 4.6 on premise setup. PS: Tried using CONFORMANE PQL syntax but this proved way more difficult given complex process model design. Regards,Amogh

Do we have cases for Planning & Budgeting Process in Finance?

I am completing a training exercise in the My Exercises Studio and it is not allowing me to get additional options when I R Click on the sheet name

I am trying to create a dashboard or just an olap table in which I can see the open items that will be becoming due in the next few weeks (1 to 3 weeks). My question is how to create a formula that gives me that based on today’s date (not on a fix date), as my expectation is that tomorrow a new set of invoices is displayed based on tomorrow’s date. Data Model B2Cnet due date already in the data model BSEGMERGED table https://bosch.eu-4.celonis.cloud/package-manager/ui/views/ui/assets/fe6ad3d2-c14b-4470-82bc-89f486af4559#!/documents/fe6ad3d2-c14b-4470-82bc-89f486af4559/view

Have a KPI viz. Average Throughput time and I want to give a selection option for Percentile (50%, 80%, 90% & 98%). How I can do that?

Looking to improve "right party contact, conversion rate, abandon, etc."

Hi Can someone please help with PQL script to calculate duplicate invoices

We are trying to load the out of the Box OTC model. We have successfully completed - the Full Extraction Job ,the full Transformation Job,The Create data model view Job When we schedule the data load of the data model its failing with the following errorsData model load failed during table export: Data model tables could not be exported: O2C_VBRP, O2C_MARC, O2C_KNKK, O2C_VBUK, O2C_VBUP, O2C_VBFA, O2C_VBAP, O2C_KNA1, _CEL_O2C_ACTIVITIES, O2C_KNB1

how to register for certification program

I want download 2022-01-13-JDBC_Extractor_Package.zip to verify connection with onpremised system. I tried download this URL, but I get only downlaod.html.https://academic-*****.eu-2.celonis.cloud/help/display/CIBC/Downloads+and+Version+HistoryHow can I get JDBC_Extractor_Package.zip?

Hi, I have a data table that has 3 columns: -, 0, 1with a load of data rows below them. How do I go about calculating the total percentage for each column? I would potentially want a KPI in my dashboard that immediately tells me0 = x%1 = y%- = z% thanks,Terence

I would like to know where I can find it and if it is possible to install Task Mining on MAC machines? Where can i find the installer?