Solved

Hello everyone,I hope you can help me understand the difference between the two PQL functions CASE WHEN and STATIC CASE WHEN.I can't find the difference using the documentation, and unfortunately, I couldn't find any content about it in the forum either. I would really appreciate your help and hope someone can explain it.Thank you for your support!Best regards,Robert

Hi all,I’m a beginner of Celonis. I belong to process office department, I’m in charge of CPM.I’ve done the 5 learning contents “Celonis Process Management (CPM)”. What should I learn next effectively?It seems that there are the cource which is “Your journey”, so I think this is effective for me.

Hi Team, Has anyone built solution for Tax reconciliation analysis based on General Ledgers for Indirect Tax. We are trying to automate tax reconciliation which will have analysis basis documents types, credit, debits for each GL account. Any suggestion on the SAP tables, logic are welcome.

I would like to create a use case to analyse the throughput times of finished goods flow from one warehouse to another.Unfortunately, there are no pre-existing data connectors available for this particular use where i would be especially looking into goods issue and goods receipt.I did go through the celonis academy trainings but the trainings were basic and i cannot seem to apply what i learnt in the trainings to my use case.Does anybody have any help/ leads?Best RegardsKenny

Hello celonauts, I have a question. I'm creating an action flow that will access an API, but it needs to generate a token and then go to access. In the first step, I generate my token, but it comes composed. I would like to get only the part that brings the token: Example{"token_type":"Bearer","expires_in":3599,"ext_expires_in":3599,"access_token": "value-token"}.I need to get only the "value-token" part after the "access_token":Is there any way I can do a spit or something like that? I don't know how to get out the other side.  

As evident from the above image, there are further sub categories in the metrics column. Can we create an OLAP table in similar fashion? 

Dear i am puzzled that the calculated throughput time in Celonis is different from the source (excel) data. For example order  O4892 has a throughput time of 12 minutes (according to the raw data in Excel). However the output in Celonis is 1M (1 month?). . Could you please assist by advising on this difference.Below you can see a screenshot of the data set and output in Celonis.Many thanks!     

I have successfully set up an Action Flow to output my Celonis Query in an Outlook 365 email. I use The Celonis Query Data module  → CSV module (create CSV) → Tools module to compose a String for the CSV file to be inserted as a file attachment in Outlook → MS 365 Email Outlook module to Create and Send an email. (see image below).This all works great and we filter to output specific customer data. Today, we manually fill in the customer email contact info.However, we would like to use the Customer Contact data from the Query (name/email_address) to automatically populate the MS 365 Email Recipient. I have observed that the Tools module is limiting what data flows into the Outlook module and within the Outlook module I do not have access to all of the individual Data values from the Celonis Query.When I remove the Tools module, all of the Celonis Query Data module data is readily available for use in the Microsoft 365 Email Outlook module. (but I don’t have the CSV file formatted the w

I've written a basic script to access a knowledge model and want to edit its PQL and update it to the cloud. space = celonis.studio.get_spaces().find('Value Monitoring')package = space.get_packages().find('Value Monitoring')knowledge_model = package.get_knowledge_models().find('Value Monitor-devFlo2')content = knowledge_model.get_content()kpis = knowledge_model.get_kpis()kpis[0].pqlkpi = kpis[0]kpi.pql = "Test"knowledge_model.update()  # local to EMS The ML Workbench has "USE" rights on the knowledge model (no other options available) and "USE and EDIT" rights in the package. These are the logs:[2025-01-09 18:38:30,804] INFO: No `base_url` given. Using environment variable 'CELONIS_URL'[2025-01-09 18:38:30,805] INFO: No `api_token` given. Using environment variable 'CELONIS_API_TOKEN'[2025-01-09 18:38:30,853] WARNING: Your PyCelonis Version 2.11.1 is outdated (Newest Version: 2.12.0). Please upgrade the package via: pip install --extra-index-url=https://pypi.celonis.cloud/ pycelonis py

I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'

how to change the nanme

I am trying to make an action flow which gets triggered when the data load is more than a day old i.e., when the data load failed, and we are unaware of the failure. Current problem is that I am able to get the last refresh date from event log which is the MAX of the time stamp but to put a trigger to see if the MAx is more than a day old, the FILTER function in general does not allow aggregations. Is there a way out of it or any other path that can be taken to create an action flow to trigger a mail if the last refresh date is more than a day old.

Hello Community,I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:Within “Analysis” the table component has the function “calculate share in percentages”.Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.How does it work in the new views?Thank you so much for help.Best, Thomas  

Hi, I am just learning about Trigger with Action Flow in an academy.But I am in a trouble how to use a trigger for Action Flow that I made in KM.After making this, I tried to use it but It could not be shown in a setting field.How do i solve this problem?  

Hello, I have received the data set I want to analyze in several CSV files (due to the row limit of 1 million rows). Now I would like to merge this split CSV data set in Celonis, but I have not found the function to do so. The data set is structured in such a way that CaseID, Activity, Timestamp and other case information are each in one line, as can be seen in the screenshot. Thank you for your help.Edit: Sorry for posting in the wrong category, it looks like it can't be changed.

Hello all, I would like to know if it's possible to extract the user adoption data/login history from the Platform Adoption View via Pycelonis 2.0.1 (I have the CSV export feature enabled, btw).  I'm trying to navigate to the specific object, but I can't even reach the Admin & Settings panel. Thanks in advance for any help.

Hi All - How can I add a line on the secondary axis to this stack graph in the new views?  

Hello everyone, I am an employee from a technology company called Terus. I am assigned to learn and know how to use Celonis, then bring it back to apply to the company's process, but I currently do not have a clear plan for this move because in my country, not many people use Celonis.By chance, when I was researching, I noticed that this community and everyone shared a lot of information related to Celonis. I want to ask about the roadmap that everyone learned to use and apply Celonis? I hope everyone can give me an answer!

The data model looks like this. (1) is VBAP(2) is VBEP(3) is MARA(4) is MVKE   Now I created an OLAP table with columns from different SAP table. When I now want to include the SAP field MVGR1 from table MVKE is receive following error message.  How should the formula look like by using e.g. DOMAIN_TABLE or BIND together with PU-Function so that I can display the field MVKE.MVGR1 in the OLAP-Table?

Hello everyone, I want to use the WORKDAYS_BETWEEN function, however, in preparation for this function, I need to create a Workday Calendar. How do I do this within data integration/KM?  Thank you so much! BRJulia Bauer 

Hi everybody! I’m pretty new to celonis development and never ask a question here before, but I hope you can help me! I’m extracting data from SAP for Production data and now have the issue that I want to join the JEST table to two other tables (AUFK and AFVC) on the column AUFK.OBJNR and AFVC.OBJNR. How can I do that since downloading the whole JEST table means like 200 million entries :-( I hope you can help me!  Thank you very much!

Hi, I am trying to replicate an environment a 3rd party has set up for me (I have no access to them now).  I have data and transformations but they are all dependent on a Schema Parameter but his does not copy over. Can anyone confirm how I create one please? 

I am looking for a solution to automate changes to large number of analyses, where I need to occasionally add/delete columns from tables and graphs, when they become obsolete and replace them with new columns from the data model.Ideally, I would like to know if there is a way to access analysis content (various components) and manipulate them via pycelonis.The content is so far only accessible via celonis.apps, where it is not possible to change anything.Is there a possible solution in pycelonis (or something else) right now?

Has the On-Premise Environment in Celonis been deprecated or is there a plan for this? I'm looking for clarification and insights on why this shift might happen, and how to best handle the transition if we're still using the on-prem version

Hello, I have a problem linking two SAP tables in Celonis. Below I'll show you a picture of my publisher. I'm following the error. One table contains my costs per CUSTOMER/ORDER NUMBER, the other contains my remaining liability per CUSTOMER/order. EditorMistakeI'd like to merge these, but I don't know what to do.Thank you in advance.