Product Q&A

Hi I am Having Enterprise Trail Cloud, when iam giving my Credentials it is showing me Invalid Credentials . Please help on connecting it .Thanks

Hi, I am trying to solve a case. How to count numbers (MAX and MIN) of events in single KPI. Need to know how many events take on one user. I have two users. They have different numbers of events min 1 and the other one max 20. I need to make a count of events per user to get max 20 in single KPI. I tried to use a standard KPI maximum events per case but it is not what i need. 2020-07-30_12-57-17769203 9.74 KB

Hi, we are developing a usecase in which we want to automaticaly import a csv / excel on daily base from a fileshare. Until now we have only worked with scheduled databse connections or manual file upload. Is there any possibility to automate a daily csv import into a datamodel? kind regards Benedikt

Hey Guys, I had a quick question about filters on Pull up functions. I am trying to create a dashboard that displays Sum of spend by vendors. But i do this by Pull up function (because I use it as a dimension to categorize). I know we can put filters on the pull up function PU(child table, parent table.column [,filter expression]). My question is can we put more than one filter in the expression? I want to be able to filter for the month and year. I was able to filter for month but couldnt filter for year. Is there any way to put filter for year and month in date format ? Because I want the user to be able to input year and month to display information

Hello Everyone,I would like to create a table that list all the variants and then for each variant calculate how many unique activity there is.example,Variant acitivity countstep1,step2,step3 3step1, step3 2thank you for your help.regards

Hi Team,This is my first post. Please let me know if this is not the place to post a question like this. I need help with a statement.I want to know how I can convert this statement: max("_CEL_AR_ACTIVITIES"."_CELONIS_CHANGE_DATE") to a timestamp in CST. I have put this in a text component.The statement above works, but I have to keep telling my users that take that time and minus 5 hours. It always causes my team to break for a second and do that math, :).I would like it if I can just have it converted to CST if possible. Thanks in advance.Paresh

We are working on an issue where we would like to list the lowest order number activity within a certain case key, within a certain change number. E.g. picture attached might clarify the situation a bit more. We want to do this in the front-end (the dashboards) of Celonis.

Hi everyone, I am fairly new to Celonis. We have the O2C process loaded (SAP ECC), with, as I understand, more or less standard activities defined. Now, one of the business stakeholders asked me if we can add pricing data. In particular he would like to have the data from Conditions tab of the Display item details: Active / Condition type / amount and so on. As far as I can see the data there is coming from KOMV, which is a so called structure. Do I understand correctly that loading such a structure directly to IBC is not possible? Or is there a way? Thanks a lot Masha

Hi everyone, I need to create a drop down that will allow me to filter cases shown in the analysis by the value of a specific attribute of a specific activity. In particular: I need to filter cases where activity remove billing block was performed either by user type A or B. Process O2C in SAP, if that is important. Thank you very much in advance Regards Masha

Hello, in our analysis we have a lot of sheets. On every sheet is the same navigation pane (various components like button, dropdown and so on) At the moment, we have to maintain/edit the navigation pane on every sheet. Better solution 1: Select all components of the navigation pane and set a new option Grouping. After grouping the components to one big component set to new option "show on every sheet. Better solution 2: New sheet-type Background sheet. All components on the background sheet are visible on all sheets who have assigned the background sheet. Kind regards Thomas

With a button action it is possible to show a message box. This should also be possible as a configurable right click action. So we can provide users with help on KPIs and keep the design clean (no buttons) right_click968443 33 KB

Hi, Celonis Community! I am calculating the time between events for employee as: demension1 SOURCE (20_DOCS_EVENT. EVENT, CASE WHEN 20_DOCS_EVENT. EVENT = event1 OR 20_DOCS_EVENT. EVENT = event2 OR 20_DOCS_EVENT. EVENT = event3 OR 20_DOCS_EVENT. EVENT = event4receive OR 20_DOCS_EVENT. EVENT = event5approve THEN 20_DOCS_EVENT. EVENT ELSE NULL END) demension2 TARGET (20_DOCS_EVENT. EVENT) and filter FILTER SOURCE (20_DOCS_EVENT. EVENT, CASE WHEN 20_DOCS_EVENT. EVENT = event4receive OR 20_DOCS_EVENT. EVENT = event5approve THEN 20_DOCS_EVENT. EVENT ELSE NULL END) = event4receive; FILTER TARGET (20_DOCS_EVENT. EVENT) = event5approve; demension3 20_DOCS_CASES.EMPLOYEE KPI AVG(HOURS_BETWEEN(SOURCE(20_DOCS_EVENT.EVENTTIME), TARGET(20_DOCS_EVENT.EVENTTIME))) This calculation works, but it calculates all days, how can I count only working days?

Hello Celonis team, In IBC Process Analytics, Is it possible to hide or unhide an analysis or even entire workspace ? Over time with continues development of analyses in IBC, workspace might be crowded, and Its getting more and more difficult to the right one to continue work with.Also, sometimes when an analyst present some analysis to the audience, she or he may not want to show all of the analyses to avoid confusion etc. So, is it possible for analyst and admin to hide and unhide analysis/workspace based on proper authorizations? Thanks, Denny

Hi folkshow to define a1 tabLe and N table in pull-up function. I mean which table belongs to a1 and which table belongs to N. I just wanted to know the definition of a1 and N table.as its creating confusion. As I am new in celonis.Folks you help will be appreciated.Best RegardsInder Mehta

How to analyze your SAP Supply Chain in Snap The Supply Chain Quickstart is the first step of your process mining journey with Celonis! With just a few clicks you can learn how to optimise your finances in regards to your supply chain. Simply export the relevant data from your SAP system to start your analysis. In order to use this Quickstart you need to request the Supply Chain SAP extractor first to export your data from you SAP. This is applicable only for: SAP ECC 6.0 or higherS/4 Hana on-prem How does it work? First, navigate to SNAPClick the New Analysis button 1.11920970 175 KB Choose Supply Chain 2.21918968 126 KB Extract data from your SAP system In order to visualise your process, you first need to extract the relevant tables from your SAP system: Enter the company codes you want to analyse and request your Supply Chain SAP extractor (ABAP report)You will receive an email with the Supply Chain SAP extractor and a documentation on how to use it. Note: ABAP reports are a prov

Hi All, We have a requirement to load a few data models in parallel. Currently our celonis system allowing the data model loading in sequence. Is it possible to load 2 or more data models in parallel? Thank you.

Hello,I look everywhere and seem that theres no way to perform a negative like in a statement.Im trying to create a save formula by doing something like the following example:CASEWHEN VBAK.VKORG = E100AND VBAK.VTWEG = 11AND (ISNULL(VBAP.ABGRU) = 1 OR VBAP.ABGRU IN (, 50, 99, Y8))AND VBAK.AUART IN (YOPA, YOPB, YOPD, YVPE)AND VBAP.BS_UNIT_TEXT NOT LIKE %CS%THEN ProductWHEN VBAP.BUKRS_LAND1 = USAND VBAP.ABGRU = AND VBAP.DIVISION = SSIAND VBAK.VKBUR IN (BIL4,BNJ4)AND VBAP.PSTYV NOT IN (YFP4,YOP4)AND VBAP.BS_UNIT_TEXT NOT LIKE %CS%THEN ProductWHEN VBAP.BUKRS_LAND1 = USAND VBAP.BS_UNIT_TEXT LIKE %CS%THEN ServiceELSE UnclassifiedENDIs there any workaround that let me use this type of approach?Thanks in advance.BR,Joo Bu

Dear Celonis Community, We would like to implement Use case: O2C - On Time Delivery Prediction on our on-premise AS which is version 4.5 We checked the sample coding but it seems its prepared for cloud, Unfortunately we couldnt adapt sample use case for our data. Many thanks in advance, Best Regards, Vahide.

Hello to Everyone,I have a question related to PQL,In one of the analysis, I am using the Input variable where user can enter a number which written to assigned variable.However, I want to do a check here,When the user doesnt provides any input or deletes the already assigned value, the variable value becomes NULLHow can I write a PQL query to check if the variables value is NULL, because when it will be NULL, I want to assign a hard-coded value to it.Like:CASE WHEN ISNULL(<%= test_variable %>) = 1 THEN 100 ELSE <%= test_variable %> ENDThis is the logic I want to use however, I do not know how to construct this query,Any help or ideas will highly be appreciated. Thank YouBest Regards,Khushboo

I am trying to get the total count of ticket between submitted and Completed and also workdays W-6 to W-14I am using the below code but am getting error , could you please help me how to get between W-6 AND W-14WHEN ("_CEL_REMEDY_ACTIVITIES".WD_NEG=WD-6) BETWEEN ("_CEL_REMEDY_ACTIVITIES".WD_NEG=WD-14)(CASE(CALC_THROUGHPUT(FIRST_OCCURRENCE[Submitted] TO LAST_OCCURRENCE[Completed],REMAP_TIMESTAMPS("_CEL_REMEDY_ACTIVITIES".Task_end, Days))) > 5THEN1ELSE0END)

Hello, i have uploaded the input data through File uploads option within my data pool and i havent connected to any Database / connectors. Now when i created a data job and tried to do extraction task, it requires a data connection to do extraction. My question is how to do extraction task with just file uploads and not a data connection setup? is it even possible ? or do i need import the data to a database and do the extraction? please help

How to analyze your Cash Preservation Process for SAP in Snap The Cash Preservation Quickstart is the first step of your process mining journey with Celonis! With just a few clicks you can learn how to preserve cash within your processes. Simply export the relevant data from your SAP system to start your analysis. In order to use this Quickstart you need to request the Cash Preservation SAP extractor first to export your data from you SAP. This is applicable only for: SAP ECC 6.0 or higherS/4 Hana on-prem How does it work? First, navigate to SNAPThen click the New Analysis button 1.11919970 174 KB Click the title for Cash Preservation 2.11919970 128 KB Extract data from your SAP system In order to visualise your process, you first need to extract the relevant tables from your SAP system: Enter the company codes you want to analyse and request your Cash Preservation SAP extractor (ABAP report)You will receive an email with the Cash Preservation SAP extractor and a documentation on how

How to analyze your Accounts Payable Process for SAP in Snap The Accounts Payable Quickstart is the first step of your process mining journey with Celonis! With just a few clicks you can discover your Accounts Payable processes. Simply export the relevant data from your SAP system to start your analysis. In order to use this Quickstart you need to request the Accounts Payable SAP extractor first to export your data from you SAP. This is applicable only for: SAP ECC 6.0 or higherS/4 Hana on-prem How does it work? First, navigate to SNAPClick the New Analysis button 1.11919970 174 KB Choose Accounts Payable 2.11919970 128 KB Extract data from your SAP system In order to visualize your process, you first need to extract the relevant tables from your SAP system: Enter the company codes you want to analyze and request your Accounts Payable SAP extractor (ABAP report)You will receive an email with the Accounts Payable SAP extractor and a documentation on how to use it. Note: ABAP reports ar

How to delete your data in Celonis Snap? You can delete your data in Celonis Snap in Event Collection. First, navigate to SNAPClick the Event Collection button Screenshot 2021-04-08 at 18.08.4916771018 163 KB Choose the data pool you want to deleteIn the data pool, click Click Delete Screenshot 2021-04-08 at 18.10.441660445 45 KB Confirm by clicking Delete Your data will be deleted Screenshot 2021-04-08 at 18.13.291666704 52.2 KB

Hello ,I have a question regarding the REMAP_TIMESTAMPS function.How can I avoid, that the result of the REMAP_TIMESTAMPS Code below is rounded:REMAP_TIMESTAMPS ( HOUR_NOW ( ) , HOURS , THURSDAY TUESDAY MONDAY FRIDAY WEDNESDAY )Many thanks in advance for the support.Best regards,Jonas