Product Q&A

Hi, Im currently looking for a way to create a scatter plot where both axis are representing a KPI. If I do this, only one point is shown, but I want to represent all customer as a point. Is there a way to get this done. Best regards Steven

Hi, I have a query relating to saved formula / dropdowns that are derived (i.e. using a CASE WHEN for example). I have an analysis where the dropdown has required updating but when published the updated logic is only applied when the dropdown is reapplied which makes sense. However, this also means that if the selection is made and the user reopens the analysis after the change is made that the view will not show the updated logic unless they manually clear and reapply the selection from the dropdown. A feature that used to exist prior to Celonis 4.5 where Selections could be cleared on opening an analysis either using the Analysis / Tab Load Script Clear Selections;. This forced users to apply filters. This would allow me to ensure that users are always making selections from the latest logic and not just viewing old selections that have not been updated. Despite the help pages suggesting this is possible Help Pages the error message Select is not supported anymore. Use Filter instea

Dears, Im trying to calculate Payment terms mismatch. For MM related Invoices,Payment terms should be equal to PO payment terms.For this motivation, Im trying to obtain the field EKKO.ZTERM to compare it against BSEG.ZTERM. But Im block because of no not have a common parent in the schema message.I try different approaches using pullout functions but Im stuck . Can you please advise? below the relations available and the error messageMy formula should look like something like this:CASE WHEN (EKKO.ZTERM)<>(BSEG.ZTERM) THEN NOK ELSE OK ENDI read that somehow this can be achieved through the DOMAIN_TABLE but to be honest I could not manage to get it. Below Im including a screenshot of the data model mapping.image1589721 136 KB

Dear Celonis community, we have built the following OLAP Table for our Automatic Order Entry (AOE) types. image1101180 5.54 KB We have two KPIs for that: AOE Header and AOE Item calculating either the ratio of the Sales Orders (header) or Sales Order Items (item). We would like to switch between the KPIs via the yellow highlighted dropdown. Clicking on the header item in the dropdown will fill a variable with the value header; same for item. My Formular for the column EDI % is: CASE WHEN <%= dropdown_aoe_header_item %> = header THEN (SUM(CASE WHEN VBAK.AOE_MAPPING =EDI THEN 1.0 ELSE 0.0 END) / COUNT(VBAK.MANDT)) WHEN <%= dropdown_aoe_header_item %> = item THEN (SUM(CASE WHEN VBAP.AOE_MAPPING =EDI THEN 1.0 ELSE 0.0 END) / COUNT(VBAP.MANDT)) ELSE NULL END I wanted to check the value of the KPI based on the variable value. However if i click on header/item it does not make a difference, but only the first calculation is done in both cases: SUM(CASE WHEN VBAK.AOE_MAPPING =

Hello,I try to count the number of sales order items based on a filter on headers.I manage to do that:SUM(CASEWHEN VBAK.BSARK NOT IN (ZWEB, DFUE, ZMYP, ZMWS, ZTEL, ZPBI)AND VBAK.ERNAM NOT IN (BZTLK, BTS16)AND VBAK.VBTYP = CTHEN 1ELSE 0END)But it only counts sales orders and not sales order items.Note that I manage to do it with a Pivot Table (since we can choose on KPI to count VBAP or VBAK) but I also want to have percentages on the same OLAP table.Thank you in advanceAntoine

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 ?