Product Q&A

I’m trying to determine how best to calculate order backlog by using the activity table and event statuses. The calculation would be used to render the data into either a table, histogram or bar chart grouped into week (Round_Week(Event_TimeStamp)). Please share any ideas or code examples.

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!

I have a trigger which is link to 2 subscribers. I'm not able to delete the subscribers, so when I delete the trigger, it gives following error.

When I try to look for the following package at the marketplace:  The marketplace only shows me this one to download: I don't need this one, since this is designed for OCPM models, in my case I want the first one but I don't know how to get it. Does anyone have the same issue?  

I want to connect Azure MySQL to celonis. I am not able to connect. Getting error message "Connection test failed. Please check the data connection and ensure that the system is running. Extractor responded with an internal error."

Hi, Can you help me with a PQL that can showcase total time spent by each workgroup on an incident? The incidents can be re-assigned between different workgroups in its life cycle. output required Workgroup Avg time spent on incidents Volume of Incidents handledA XX mins. 10 incidentsB XX mins 20 incidents Example data below.

Hello,  I need a line chart showing created/open/resolved cases count every day. ​For x axis, I used GENERATE_RANGE function to generate DATE values as below. GENERATE_RANGE ( '1D' , TO_DATE ('2024-01-01', FORMAT('%Y-%m-%d')), TODAY()) For y axis(KPI), I use: COUNT_TABLE ( "casetable" ) However, the problem is there's no common table between this generated temporary table with the case table or activity table, so the case counts cannot be calculated based on this temporary table.   ​Does anyone know a good way to create that analysis, ideally only in frontend and not change the data model?

Hi, I'm trying to show a target inside a column and line component, but for some reason I'm not able to add it.I already created the target in the desired KPI, but I don't know how to show it. Did anyone have a similar scenario before?  

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?

Is there a way to create dynamic content using the Enhanced View Variables? For my use case, I’d like a column header to update automatically to the current month, in numerical format. So as the months progress, the column would go from October (10-24) to November (11-24) to December (12-24), etc.I used this functionality a lot in the old analyses, as a dynamic variable.  

Does anyone know of an online place (URL) where we can view sample use cases and practice PQL query?

Enhanced variables and updates to existing Knowledge Model variables in Studio (2024-09-16) You can now create and use enhanced variables in your Studio content. Enhanced variables allow you to centrally create and manage information that is referenced and reused across components and assets in Studio. They act as placeholders for information, either based on dynamically inserted context (such as company names, countries, and sales orders) or with manual input by the app user (such as entering the cost of an item). There are two types of enhanced variables:Enhanced View variables: These are specific to individual Views and can't be reused across Views in the same package. To learn how to create and manage enhanced View variables, see: Creating and managing enhanced View variables.Enhanced Knowledge Model variables: These can be used wherever the Knowledge Model is being used, as such can be reused across Views, Packages, and Spaces. To learn how to create and manage Knowledge Model

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

Hi Everyone, We are trying to automate extracting a weekly report and send it as a csv file via email to recipients. During this process, we found that some of the text specifically the one’s which are not in English gets replaced by some unreadable characters like /, $, *. Is there a way to avoid this?Help is much appreciated!Thanks,Vamshi D.

I have a question regarding a development I’m working on. I have an old view where I would like to add a button that, when clicked, opens an auxiliary filter view. This auxiliary view is newly created, using the latest version of the views, and has already been published.However, when I try to configure the button to link to this new view using the "link views" function, the view I just created does not appear as an option.I suspect this might be because it's not possible to link new views to old views, but I’m not entirely sure. Could someone confirm if this is the case, or if there's another reason why the view isn't showing up?

How would you use a button to navigate between tabs in the new version of views? I have a landing page and want to give users the ability to navigate directly to a page/tab.

How we can use symbio in celonis.Do we need to registered separately for symbio?

Celonis CPM - How can one import a Visio diagram in Celonis CPM? The steps in the Symbio documentation didnot help us.

Imagine I have two tables CasesCase IDCustomerActivitiesCase IDActivityEvent Time I would like to get the earliest "Upload" activity event time across all cases for a given customer. It is easy for me to get the earliest "Upload" activity for each Case with: PU_FIRST(Cases, Activities.Eventtime, Activities.Activity = 'Upload) But this returns a row for every case. I cannot figure out how to get the first of all these results. I tried domain tables, but couldn't figure out how to set it up. Any thoughts?

I wanted to use Get Message module of Microsoft 365 email in my Action Flow. But I don't know what does each field mean and what are the accepted values for those fields. For example in the screenshot below.I checked Celonis as well as in make.com documentation, but none of the place I found the proper documentation. Thus, can someone suggest where I should look for documentation on Microsoft 365 module.

PAID AMT is, by definition delayed because people have to do research and request payment before the money arrives. So, it's normal to have NULL in PAID AMT for a while. Any thoughts? Apparently, I wasn't authoring the conditional statements correctly. 

I have the following scenario, there is a component table inside a view each column is related to some KPIs, and in other columns, the values are coming from inputs that the user inserts manually inside the Apps. It means that some values don't exist in the data model or can be generated with any table since they are inserted manually. I would like to know if it's possible to create an action flow that reads all the values from that table in the studio and sends the data to a data pool. I was checking the documentation, but it seems that all modules from Celonis are only capable of reading data that exists in a data model or a knowledge model but not from a table component.  

Hello community,I am struggling to set extraction filter statements for Jira tables. Some column names has a $ character that causes the following error:Extraction failed to start. Error for table 'issue': Field 'project$id' does not exist or you do not have permission to view it.With the INFO:additionalFilter: "\"project$id\" IN ('1234', '5678')" Furthermore, operators such as LIKE do not work. Error executing extraction. Unknown operator: LIKE. Any hints or best practices to share when configuring Jira extraction filter statements? CheersIrfan

Could you tell how to set up the Share Link button?(Attached below) The permissions are also fine for the administrator in the target environment.I would be grateful if you could let me know.