Product Q&A

Hi All,Currently I have a dropdown button with manual entries. All of these entries set two variables, of which one concerns the name of the selected entry.Preferred value to set for the name:Exclude Invoice Value of Zero: YesHowever, so far I didnt find a way to get this Yes in bold. Regular ctrl + B as well as and (double asterisk) operators dont work. Is there any way to get this done?Thank you!Jeroen

Hi,I have a problem that was addressed in another topic however, I have tried the solution and it did not work.Basically i would like to sum up the euro value of invoices that have been completed within 2 working days. We dont have the calendar table in our data model so using the working day formula does not work and therefor I have tried the below work around that has been suggested. However, am getting an error.Can you please let me know where my error is?SUM( CASE WHEN DAYS_BETWEEN( REMAP_TIMESTAMP (ROUND_DAY(BKPF.BLDAT, MONDAY 08:00-17:00 TUESDAY 08:00-17:00 WEDNESDAY 08:00-17:00 THURSDAY 08:00-17:00 FRIDAY 08:00-17:00 ),REMAP_TIMESTAMP (ROUND_DAY(BSEG.AUGCP, MONDAY 08:00-17:00 TUESDAY 08:00-17:00 WEDNESDAY 08:00-17:00 THURSDAY 08:00-17:00 FRIDAY 08:00-17:00)) <=2.0 THEN BSEG.EUROELSE NULLEND)Thanks for your help!Anna

Hi Team, Like list of supported connectors available with celonis. Where I can find list of supported and unsupported Database with celonis ? Thanks.

Hi, I have loaded table BSEG, however when I run AP analysis, the values only sum for posting key 31 as that is what the invoice is based on . However, for validation purposes I need to total across all the posting keys in BSEG. How can I structure a query to do this ? Thanks Geoff

Hi all, Id like to compare the Purchase Requisition (PR) value to the PO value and to the Invoice value. Therefore, Ive added an OLAP table with the PO document numbers, PO Items and the PR number as dimensions and the PO Net Price (EKPO.NETWR) and the PR valuation price (EBAN.RLWRT) as KPIs. Afterwards, Ive calculated the difference in percentage between PO and PR value which works fine. Now, Ive tried to add the Invoice value as a third KPI to this analysis in order to see all differences within one view. Therefore, Ive added the Invoice Value (EKBE.REEWR) to the KPIs, however received following error message: No common parent between tables could be found please check your schema. The tables EBAN and EKBE do not have a common parent in the schema I do understand the issue, however do not know if and how I could solve it, in order to have all three values (PO, PR, Invoice) in the same table. Any ideas? Thanks, Oli

Hello Community, I am playing around with the backup content function for Celonis analysis. https://python.celonis.cloud/docs/pycelonis/en/latest/notebooks/99_Use_Case_Version_control.html#Create-backups-of-all-analyses-that-are-published-in-separate-workspace-directories While investigating, I realised that you have to store your file locally, before you can push it to Git, or AWS S3. I was wondering if anyone tried to directly send the backup to S3, or Git?

Hi there I would like to use nested variables:I have a dropdown button with two items: 'dont filter and filter according to parameters.When I choose the option dont filter I, well, dont want to apply filtering on certain components.When I choose the option 'filter according to parameters I want to apply a filter that also takes one or more other variables into account.Currently I have a variable that I use for filtering, where the variant including filters looks something like this:FILTER "MY_TABLE"."MY_COL" > <%= myvar %>;However, this does not seem to work as the myvar variable is not replaced by the value of the variable.Any ideas how I can have a filter that is disabled, or executed using other variable(s)?

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