Product Q&A

Hi everyone, I would like to know if there are connectors ready to extract data from the Oracle HCM platform. We´re planning to use EMS to map and analyze personnel moves through positions, including transferences, promotions, demotions, etc. Thanks.

Dear Experts Does anyone know if Celonis OP system or the IBC Hybrid deployment supports Oracle database? Is there any customer references? Thanks!

Hi there, I would like to ask for you feedback to do the following: I would like to measure the median throughput time over time (per month) in two different column charts. Happy Path column chartThe first chart should display the median throughput time from "PR received" to "PO sent to supplier" where "PR received" is directly followed by "PO sent to supplier" (Happy path). The result should be displayed in a column chart: January - 20h, February - 23h, March - 18h etc. Non-happy path column chartThe second column chart should display the throughput time for all PR that didn't follow the happy path. This includes all PR request that did not go straight to "PO send to supplier", but had other activitites in between. The result should be displayed in a column chart: January - 40h, February - 46h, March - 36h etc. I am currently managing to get to the numbers seperately, but not displayed over time (per month) in two different column

I am trying to upload a CSV into my Celonis Snap, but when I upload it, I get a processing error that the "Number of fields does not match schema". Does anyone know why this is happening? I converted all of the columns to strings but did not help.

Mass Transaction Qualifier - We are currently trying to configure the mass transaction functionality. I am curious how others have coded this. Today it appears that it simply qualifies all activities done by a SAP user within 10 seconds (we can config the amt of time 10 seconds was recommended to start). All of these activities are classified as a mass transaction and they are all coded as user type "R" (again I believe this is the standard).  However, when you look at the actual business process and execution many if not all of these mass transactions are initiated by a manual user performing at least one of the steps.  Example: in P2P user marks "delivery complete' which triggers second activity automatically of set "final invoice indicator' in SAP even though user name is the same for both activities. Currently Celonis calls both of these activities "R" whereas we would like the initial activity to show as "A" because a user perf

Hi everyone, I created a Chart and face the problem that the expression of the KPI does not fit into the tooltip.   Option 1: Is there a setting to change the size of the tooltip box? Option 2: Alternatively I wanted to limit the characters of the variables. Could you help me to insert a LEFT or RIGHT statement? My syntax does not work. <%= MyVariable %> --> Full text is shown<%= LEFT(MyVariable,10) %> --> Only show the left 10 characters

Hi community,  I created a dashboard and would like to use a variable so that the end-user can easily switch between first-to-first // first-to-last occurrences. Could you help me with getting the syntax right. Thank you!

Hello, I want to create a variable that defines Area_of_Business. it would be a combination of the Department and Type of the Business. It is not a problem to create the variable but rather to integrate it into the graphs and diagrams as I cant use "CEL_CASES"."AREA"=Variable (dont have a column called "AREA") or "CEL_CASES"."DEPARTMENT"=Variable or "CEL_CASES"."TYPE_OF_BUSINESS" =Variable in the quiry. Any ideas how to implement it? Best,Maria

Please see error message:Data model load failed during table export: Data model tables: Quote_Header_xlsx_Quote_Header, Customer_xlsx_Customer contain more rows than the allowed maximum per table of 0. Please reduce the number of rows. Both tables are not bigger as the case table, so I cannot understand why the number of rows should be an issue.

Is it possibile to receive commercial deck and presentation in Italian?

Anbei die heute bei unserem virtual cocktail gezeigten Folien zu CoE

[Salesforce Extractor - Pseudonymization] Hi guys, assuming that the SFDC extractor is within the celonis cloud, it seems to us that non-pseudonymized data is at least for some period of time brought to the celonis cloud before it gets hashed. If this understanding is correct, would you know for how long would that be storaged (is the non-pseudonymized deleted at some point?) and how can we make sure that this information could not be accessed at all at anytime? Thanks a lot

Do you have any questions about Snap or want to make sure you are getting the most out of your analysis? Book a 1-1 Snap call, a complimentary and personalized session tailored to you and your process mining needs with a Snap expert.  https://celonis-se.appointlet.com/s/snap   

Join us for our next Introduction to Celonis Snap webinar on May 25th at 4pm CEST/ 10am EDT! We will cover Process Mining fundamentals, show you how to upload and analyze your data with our various Quickstarts and you will have the opportunity to ask questions.  Sign up at: https://www.celonis.com/webinar/celonis/introduction-to-celonis-snap/

New to process mining? Sign up for our free, hands-on Snap Training and become a Process Mining expert in no time! We will guide you through everything you need to know about uploading and analyzing your data in Snap. Register at: https://lms.celonis.com/

Hi everyone, i am trying to create cathegories for my pie chart. The categories would describe the Value of the "Case" based on payments (can be NULL) and the rest of the reserves 8also can be NULL) for the Case. I have started with the following description of the Categories:(CASE WHEN (  ("CEL_SHUK_CASES"."ZAHLUNGEN" + "CEL_SHUK_CASES"."RESTRESERVEN")>=0 AND ("CEL_SHUK_CASES"."ZAHLUNGEN" + "CEL_SHUK_CASES"."RESTRESERVEN") <1000  OR   (("CEL_SHUK_CASES"."ZAHLUNGEN") IS NULL AND ("CEL_SHUK_CASES"."RESTRESERVEN")>=0 AND ("CEL_SHUK_CASES"."RESTRESERVEN")<1000)  OR   (("CEL_SHUK_CASES"."RESTRESERVEN") IS NULL AND ("CEL_SHUK_CASES"."ZAHLUNGEN")>=0 AND ("CEL_SHUK_CASES"."ZAHLUNGEN")<1000)  OR   (("CEL_SHUK_CASES"."RESTRESERVEN") IS NULL AND (&quot

Hi, I want to calculate the throughput time between a certain activity and "now"; ideally speaking I'd like to do a query like this one that is forbidden: CALC_THROUGHPUT(FIRST_OCCURRENCE['activity name'] TO TODAY(), REMAP_TIMESTAMPS("ACTIVITIES"."ACTIVITY_START", DAYS)) How can I resolve this? Thanks a lot

Hi. I'm starting with Celonis and I was wondering if any of you guys have any suggestions of filters in AP, Cash Discounts that can show the customer the discounts for early payments that he is missing.

Hi guys, We are trying to connect Ariba with Celonis IBC to extract Supplier Contracts related data. Now we were able to test connection successfully, but while creating the data extraction task we are not able to see any tables to extract.

Hello, I was wondering whether it is possible to automatically export the KPIs as they are being displayed in Celonis. This either in the form of CSV data, or in the form of a image. The best would be if you can store this CSV or image directly in a Google Drive. Thanks for any advice. Paul

Where I can find Celonis installation document? What's the servers architecture to setup for an on premise installation?

Hello Community, I am a new member, learning Celonis. while doing the exercises(I am following a PDF document) I got the following error when trying to apply filter on join table. Error parsing filter: CDHDR.UDATE >= 01.06.2014 caused by: Lexical error at line 1, column 16. Encountered: \\u2018 (8216), after : The following is the statment i gave: CDHDR.UDATE >= 01.06.2014 Could anyone please help me to rectify this. Thank you, Malini

Hi,I am looking for a PQL code to solve the following.We have data for multiple dimension over a period of time. I would like to get the data aggregated on one dimension per month.All the data is within one table.|Dim1|Dim2|Dim3| Month | KPI ||----|-----|-----|------|---|| A    | X1   | Y1   | Jan-21 | 300 || A    | X2   | Y2   | Jan-21 | 200 || A    | X3   | Y3   | Jan-21 | 400 || A    | X1   | Y1   | Feb-21 | 200 || A    | X2   | Y2   | Feb-21 | 100 || A    | X3   | Y3   | Feb-21 | 500 || B    | X1   | Y1   | Jan-21 | 300 || B    | X2   | Y2   | Jan-21 | 200 || B    | X3   | Y3   | Jan-21 | 400 || B    | X1   | Y1   | Feb-21 | 200 || B    | X2   | Y2   | Feb-21 | 300 || B    | X3   | Y3   | Feb-21 | 500 | What I would like to get is.jan-21feb-21diff.A900800-100B900100200 I have been trying with the domain table and PU functions but I was not able to make it work.Thank you

Dear All, I remember linking SAP CRM URL to Celonis so from detailed Tab, I can jump to the transaction in URL. I dont find the steps to do that. Can someone help here? Thanks

Let's talk about Creating a Single Source of Truth for Business Knowledge, such as KPIs, with Knowledge Models 💫 💫   If you haven't watched the Celosphere Basecamp Session you can still attend today 15.04 or watch the recording after the event https://www.celonis.com/celosphere-2021