Product Q&A

In the attached photo, the number of cases is duplicated and counted.I want to know the PQL that solves this.

I have gone through the explanation in documentation, but didn't find it to be detailed enough. Can somebody please explain with certain examples ?

Ready to seize unlimited opportunities?Visit the EMS Marketplace from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners.Visit the EMS Marketplace or find your team. Recently Added: IBM work order management for manufacturing IndustryWork Order Management application provides an operational dashboard to monitor, plan and streamline the end to end lifecycle of a work order, Identifying bottlenecks and processing differences based on various dimensions for continuous improvement and faster lead times, digitally transforming the work order process to improve data quality and reporting & providing automation for faster fixes. IBM record to analyze month end close:A recurring challenge faced by F&A operations team is the ability to control and monitor the close of each financial period. The Month end close (MEC) process is pretty complex and intense as it is

Some times working fine and some times getting below error  Change log extraction failed!. Change log strategy not specified. Celonis Support ID: 889395d9-5218-4e84-a325-da537c6a4aa5

HI All, We received a error when testing the data connection at a client on C4C+ project. The description of the error is as follows:  "Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Error making capabilities request to extractor: Remote application on http://uplink/uplink/api/internal/proxy/90574be94ecede1912b66868c75ec3994e77111b3c097720be3e1e94a41b3865/connector-capabilities[POST] responded with 500 : {"timestamp":1647536076176,"status":500,"error":"Internal Server Error","message":"Could not connect to middleware - client not connected. Client: 90574be94ecede1912b66868c75ec3994e77111b3c097720be3e1e94a41b3865, Channel: connector-capabilities","path":"/uplink/api/internal/proxy/90574be94ecede1912b66868c75ec3994e77111b3c097720be3e1e94a41b3865/connector-capabilities"} " The data connection first worked but after the weekend(11-12

We had a request to align content in certain columns to the right in a Table component in a View. Is there a way to specify that the content in a specific column should be right justified? Thanks in advance.

I want to get a detailed view of the simulation scenario by generating an event log that can be viewed in the process explorer. Currently I see the simulation running and giving me the required summary. But I want to view the simulated process.

I have a question - how does the function "having" work in Celonis PQL? I need to select case where Count(Activities)>3. How can i do it is Celonis? Thank you so much!

Dear all, I have checked with Coupa and Oracle both connectors, its shows the below error. How to resolve these issues. Thanks Regards,Jayaraman.M

Good evening guys,I would like to calculate the total throughput time of a sub process which can occur multiple times within one case. The subprocess always starts with a unique activity and ends with a unique activity. There might be different activities between the start & end activity (see picture). I tried my best by using the MATCH_PROCESS_REGEX function but didn't succeed. Thanks a lot for any hints and suggestions! Cheers,Alex 

Hi,  I am facing an issue while getting the number of iteration of the activity purchase requisition before the activity purchase order.  if anyone have idea how can we get the activity occurrence so please help! Thanks in advance.

Hi all,  I am trying to transform the data from multiple excel files into a single activity table but while I am transforming the timestamp field. it shows the error below:Execution error: ERROR: Column "_EVENTTIME" is of type timestamp but expression is of type varchar When I upload the file I have already indicated the field as DATETIME field Therefore i am not so sure about how this went wrong, appreciate your time and help in advance!

How to create bar chart and line chart in Celonis as the way we create in excel with secondary excess.

I need to review in detail a ETL process in Celonis. I would like to at least download to my desktop all the scripts. And if possible also to download all the tables definitions (including raw data, temporary, views, and data model) Is that possible? TIA

Where i can find Celonis Analyst training ?

Has this product been used with an ETRM/CTRM system? If so what systems?

Hi,  I am trying to display the time difference in days on the 2nd column between each task on the 1st column (which is shown in the process flow explorer already) but I would like it in a table format.  So instead of giving me the overall throughput time from process start to end, is it possible to get the days between tasks? This can be seen below: 

We are working on one use case here, we have two systems one is SAP & other is readsoft workflow. when ever an invoices is processed then that invoice will enter into SAP from readsoft means SAP BSEG table consists of the processed invoices and readsoft table consists of both processed and non processed invoices. where in the data model we are taking BSEG table as a case table and joining with readsoft table. when we load the data model we are able to see only processed invoices in the studio but unable to see the non processed invoices from the readsoft table. could anyone you please help us how can we get those non processed invoices into stuido.

The session I want to enroll in, has a link I cannot press because it is hidden behind the screen of another course

I've created an activity table in which I've created a level column that will contain 1 or 2 depending on what I would like to display. In a dashboard, I have made the following tests with no desired results: Created a process explorer sheet and add the activity table to it. Add a filter to the sheet in order to display on the process explorer activities of level 1.Created a new sheet to which I added a process explorer component and added a filter to the component itself. None of above cases worked. Is is possible to filter activities display in a process explorer? Thanks

I would like create a single KPI that uses a conditional count. This KPI should display the count of the number of cases within a process that has a duration < 60 days between two specific events.

Can we create Boxplot in View ?

Problem: In the dataset I am working with, a mistaken batch process in the source system added extra timestamps which are throwing off throughput times.  Objective: My objective is to map to null all activities in my activity table which are repeated back to back. Example: In the simplified table below, I would want the final activity to map to null since it is a repeated activity &quot;c&quot; of the same work order &quot;3&quot; Table = &quot;Celonis_Remap_Practice_csv&quot; Partial Solution:I created a custom dimension on a variant explorer with the following code: CASEWHEN   &quot;Celonis_Remap_Practice_csv&quot;.&quot;Activity&quot; = ACTIVITY_LAG (&quot;Celonis_Remap_Practice_csv&quot;.&quot;ACTIVITY&quot;)   AND INDEX_ACTIVITY_ORDER ( &quot;Celonis_Remap_Practice_csv&quot;.&quot;ACTIVITY&quot; ) &gt; 1THEN NULLELSE &quot;Celonis_Remap_Practice_csv&quot;.&quot;Activity&quot;END; This effectively removed the duplicate activity from the variant explorer, but I want duplicate activi

We are trying to obtain the profile name of our Team URL for using it in the Machine Learning Workbench. So far, only one of them works correctly.

If yes - can this include parallel gateways to reflect activities that can de done at the same time?