Product Q&A

Hello,can someone from Celonis please provide proper documentation for RCALL and RAGG functions? I do not understand how to do the syntax of the code (it is obviously a bit different than in R studio) and errors in Celonis do not really say anything.Best Regards and Thanks in advance,Vclav Juren

Dear all, in the past 11 months we implemented several data models from the content store now facing the following issue, that the content store evolves over time but being a complete black box for us, which I would like to describe with a short example: We implemented PTP almost one year ago. As the content/app store is enhanced over time we now face the issue, that we do not know, if there happened any update to the data model / basic analyses. E.g. we found a new basic analysis (Three-way-matches) which was not available when we initially implemented the data model. After downloading we noticed that our data model is missing tables for this new analysis meaning that there was also an update to the data model. As there are 20++ analyses for certain data models it is impossible to track manually on a regular basis, if there were any new analyses added or if further if there was any adjustments to existing ones. Additionally, as the data models are provided seperately, we have no insig

Hi everyone, I am analyisng a P2P process and in my data model I have an activity table, which is linked to the tables Vendor and Position via a vendor-/position-number. The Vendor table contains master data for all vendors which I buy stuff from, i.e. one row for each vendor. And the Position table contains master data regarding the purchas-positions I buy, i.e. one row for each purchase-position. So there is a 1:N relationship between the vendor- / position-table (1) and the activity table (N). Now I would like to display the amount I pay for all positions bought at one vendor. But if I sum up the values for all positions belonging to a certain vendor i do not get the desired value, but I get the sum for all positions for the vendor multiplied with all activities which have been carried out for this position. E.g. if I have 2 items I bought from a vendor, each costs 10, the formula does not calculate 20, but 180, as for both items 9 activites have been carried out. (10 * 9 * 2 = 180)

Hello Celonis and others, I am trying out the Machine Learning workbench, and in the examples I see the API secrets out in the open. I would prefer to hide the secrets in a secret management system. Does the Machine Learning workbench support something like that, and how can I setup a secret management system? Inspiration for in my opinion good secret management is in: https://docs.databricks.com/security/secrets/index.html For managing SSH keys inspiration can be found in: https://help.github.com/en/github/authenticating-to-github/adding-a-new-ssh-key-to-your-github-account

Hello, I am investigating the data pool connection via the Python API. I am following the guide in : tenant.realm.celonois.cloud/documentation/data-push-api-python/ If I then try to enter the datapool according to the documentation in: tenant.realm.celonois.cloud/documentation/data-push-api-python/ I get the following error: dataPoolId.Pool does not exist If I try it via the curl command: curl -X GET --header Content-Type: application/jso --header Authorization: Bearer <YOUR_API_KEY> https://<YOUR_DOMAIN>.celonis.cloud/integration/api/v1/data-push/<DATA_POOL_ID>/jobs/ -X POST -d '{targetName:<TABLE_NAME>",type:REPLACE} I get the following error: dataPoolId.Pool id may not be empty For the data pool id I entered the datapool id of my connection. In the picture attached you can see that the 1st mark is the data pool id. I took this as my data pool id. image2019-8-22_17-1-111197512 101 KB

Hi, I would like to understand, which data base that Celonis used to calcul is ratio. I have 3 406 PO with a PO Doc. type (ZNS, ZNB or ZST) I would like to see the % of each PO Doc type. I had use this formula : KPI(Ratio, EKKO.BSART = ZST) The result is 14.67%, while I should see 37.70%. I create a OLAP table, if I put the same formula but add a Case Count Column, the result is good. If I retired the Case Count column the result is wrong. Whats happened ? SHould I add a case count in my ratio formula ?

Helly everyone, I am currently searching for an opportunity to display two filtered KPIs stacked on each other. I have already found out about the stacking function. Now I am struggling with counting the cases filtered within the formular. I tried something like COUNT_TABLE(Table1(CASE WHEN Table1.Filter_Column = Filter_Word THEN 1 ELSE 0 END) I also tried it with the simple COUNT function as well. Both do not work, respectively give the intended result (Count Table does not work, Count simply gives a number for every occurence of that criterion) But what I want is the number of cases where that exact criterion is true. As a background, my filter criterion is always valid for the whole case, so if one activity of a case has that criterion, every activity of that case will have it. It actually seems so simple, but I just dont get it right. I am very thankful for your help. Kind regards Matthias

Hi, I have got the feedback from our users that they miss the select/deselect all feature in the attribute selection, which has been removed with release 4.5. They are not entirely happy with the invert selection feature as replacement. Could you consider including it again? Even if redundant, I think the users would appreciate to have the choice with which feature they prefer to work! Thanks, Stephanie

Malloc%20size%20error1358614 68.9 KB Hi All, While trying to get data using Python API, I am getting below error : ArrowIOError: Arrow error: Out of memory: malloc of size 5823262912 failed. I am using Query() method to extract data. Expected data shape is (20000,4) and using Celonis version 4.5 Please help with this error and share any related documentation. Best regards, Pushpendra

Hello all, What is the best way to get human readable field names (one loaded from Names Mapping settings) in Pycelonis API? And specify language. In pycelonis.objects_cpm4.Analysis property I can only see technical column names even if human readable names are visible in UI. I am integrating with CPM4.5

Hello celonis team, Is it possible to enable just integer values for the entry in the Variable Input component ? Many thanks

Hi, I would like to understand why when I extract the movement type for a cancellation of reception, the result appear in positif in Celonis ? SAP : CELONIS : I verified that are the same ligne (mvt type 102, same PO, etc) Thanks in advance.

Hi, Im trying to calcul the difference between to column in the same OLAP table. I used this formula : {TMP_CDHDR_CDPOS.VALUE_OLD}-{TMP_CDHDR_CDPOS.VALUE_NEW} but the system alway run he never give me a results why ?

We are trying to filter out yesterdays data. We know how to filter out today: FILTER ROUND_DAY(table.timestamp_column) != TODAY() Please let me know if anybody knows how to filter out yesterdays data. Best regards, Paul Velthuis

Hello, I am trying to use the DIFFDATE formula to calculate the days until cash discount but I get an error when I try to run it datediff(dd, PU_MIN(BSEG, _CEL_AP_ACTIVITIES.EVENTTIME, _CEL_AP_ACTIVITIES.ACTIVITY_EN = Cash Discount Due Date passed)) regards Tatiana

Hello Celonis Team and community, Im currently working on topics like planning adherence and schedule adherence. The last one is basically an OTD (on time delivery) KPI, but only related to the plant performance. Based on my company process, the GR date (goods receipt date) is the moment when the clock stops and the plant on time delivery is measured. To my surprise, there are different GR types (see list below) and Ive asked internally the meaning and the original data fields in SAP. Unfortunately, it seems that these activities are standard Celonis content, whose definition/construct is not visible to us (not even in HANA - database level). Therefore, we are not able to determine the meaning nor the origin of them. It is appreciated to receive a clarification of all possible GR tasks and the logic behind it (e.g. SAP original data fields). Thank you in advance for your support. With kindest regards, Francesca GR for Order GR for sales ord.st. GR f. sls.or.st. rev GR for acc.assgt rev

Hello Team, a quick question: in Celonis chart components is it possible to perform sorting on the dimension which is then hidden? In OLAP we can hide the dimensions, I dont see such option for example for column chart. In our case we want to sort payment terms with their due date from earliest to latest (so 00 is due immediately, 30 is due in 30 days etc.) But now we need show a combination of payment term and this additional number with days). image1397586 29.6 KB

Hi Celonis Community: I am following introductions of Use case: O2C - On Time Delivery Prediction from CelonisMLSuite. When I start training the trainer, the following error occurred. Could anyone tell me the possible reason for this error? image1369247 21 KB image1308227 17.5 KB Best Keith

Hello everyone, I am currently trying to set up a conformance analysis in Celonis. Thereby, I want to create a new process model for comparison. I have the new process model only available as a graphical version of the target process. However, as I am talking about an engineering process, return loops within this process are allowed and not a violation. Basically, I need the opportunity to allow some of those return loops as conforming processes. Whitelisting every violation case is in this case very troublesome. Therefore, I tried simply reconnecting the activities with arrows (see attached image) and gateways. Both do not seem to work. If anyone created process models like this or might have an idea for me, I am very grateful. Kind regards Matthias Ertl Example_New%20Process%20Model854260 6.35 KB

Hello all, how is it possible that the combination of calendar week and year is sorted correctly on my timeline? Starting with 1-2019, 2-2019, 3-201944-2019, 45-2019 image1338212 24.1 KB Many thanks! Best regards, Jonas

Dear fellow process miners, Im currently struggling implementing a normalization of a result in a table. It seems to be impossible to achieve that an OLAP table in Celonis. Heres my problem: Every case has a list of 0 to N events that affect the duration of the case. Its a simple parent-child relationship in the data model. If no event happened to a case, there will be no record in the child table. Now I created a simple OLAP table with the event category (event.category) as dimension. My two KPI columns so far are The number of events of that category as COUNT(DISTINCT event.key) The sum of delay in the process, caused by that event as SUM(event.delay). Now, I want to normalize the delay to 100 total cases. Say, I have 15 events, causing 15 minutes of delay. In total, I have 250 cases. What Im trying to achieve is the following simple formula: (SUM(delay)/Total number of cases)*100, which should be (15/250)*100 = 6. However, this seems to be impossible to achieve in Celonis as GLOBAL(

Hi there, I work on an analysis to monitor, which sales order channel our customers use. Therefor I need a button for each order channel, where a viewer can select all customers ordering e.g. via EDI at on click. So the Viewer can analyse all customers with the possibility of ordering via EDI and can identify which other order channel those customers use. At the moment, the viewer has to select via a filter order channel EDI, then select all customers and remove the EDI filter, because otherwise the viewer can see only sales order items received via EDI. Can someone help me with the formula please? Best regards, Carina

Dear Celonis Community, I have a tricky statement to built and could not find a solution yet - maybe one of you have a nice idea! In our company we have so-called local customer hierarchy which is used on the one hand for grouping of customers and have settings on higher level than customer number. On the other hand used for reporting on different levels. This hierarchy is our a-level-hierarchy and it is usually used by the local affiliates. Technically the assignment can be found in entries from KNVH, where KNVH-HITYP = A. When reporting in headquarters a-level-hierarchy-numbers are grouped into f-level-hierarchy (also called GCN=GlobalCustomerNumber) and reporting is based on f-level. Technically the assignment can be found in entries from KNVH, where KNVH-HITYP = F. Basically as not always the lowest level of a-level-hierarchy is assigned to the lowest level of f-level-hierarchy, I have to check every a-level-value against the lowest level of f-level-hierarchy. I built a statment t

We have some exciting news to share with all Celonis Snap users. Furthering our goal to democratize access to process mining, Celonis is taking the next big step, after the announcement of Celonis Snap, and makes all of its Online Training content for the Intelligent Business Cloud available free-of-charge. All Snap users now have access to our training tracks and can become Celonis experts today! This step-by-step guide will show you how to start your training. Log-in to your Snap and navigate to Training as it is shown in the picture below. 1600851 377 KB Then click Activate Online Training. 1600851 383 KB After that, you will be redirected to our training platform. Enter your details to sign-up, watch the introductory video and start with the training track that suits your role. 1600851 60.8 KB For instance, if you want to learn how to create advanced analyses choose the Analyst training track. 1600850 199 KB

Hi all, Currently we are doing an analysis on late Goods Receipt (i.e. Invoice receipt happens before Goods receipt). This is done based on the data model below: image.png1032482 32.3 KB However, now we got stuck on the issue how to calculate the time difference between the goods receipt and the invoice receipt. Using DATEDIFF(dd, MSEG.BUDAT_MKPF, RBKP.BUDAT) results in the error that these tables do not have a common parent in the schema. Any ideas on how to link these fields and calculate the delta in days? Thanks!