Product Q&A

For example, in P2P data model we connect EKPO and EKKO using foreign key relationship, but then also we mention that in data jobs while creating EKKO. So my question is why we are doing the double work here? Also what is going to happen if I do not connect two tables that are required to be connected in the data model ?

Good afternoon, We've set up an Action Flow that we want to run at different times, depending on the day of the month, ie:If we're on the 5 First Days or 5 Last Days of the month, we want the Action flow to run 4x a day, at specific times;If we're Not in the above mentioned interval (M+6 to M-6), we want the Action flow to run 1x a Day, at a specific time Thank you in advance Best Regards, Vasco Carona

Hello. This is a question about Action Flow and Skill.In my company, it is not allowed to give Microsoft or Gmail permissions to Celonis, which means I can't use Microsoft 365 Mail (or any other Microsoft module) and Gmail in Action Flow. So I'm trying to generate csv files in Action Flow, pass them to Skill and send them via Celonis e-mail address. Could you please tell me how to pass the csv file from Action Flow to Skill?Thanks. Regards,Chen

Hello, I need your swarm knowledge. I need a combination of the following formulas.... TRIMMED_MEAN(CALC_THROUGHPUT(FIRST_OCCURRENCE[<%=Process_Start_1%>] TO LAST_OCCURRENCE[<%=Process_Start%>], REMAP_TIMESTAMPS("T_CEL_AT_HP5"."EVENTTIME", DAYS, MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY)), 5, 5) ...if the condition beforehand... "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%' ...grips. Hope for help :-) thx

Hello, i would like to have a global KPI where its value is not modified by the filters that we select in different dashboards. I am using the function GLOBAL but it doesnt work

Hello, I am currently running an Action Flow which is delivering and modificating a Gsheet and i would like to sort the sheet in ascending order on 1 column. Can i do it on the query who's generating the gsheet ? Thanks for your help :)

How can I display costs of activities in the variant explorer or process explorer?

Hi, all I have a button dropdown with settings: load entries, write to variable 'a'. I want to use this to do a dynamic analysis with a table. I set the component filter of the table as below: FILTER "table"."column" = <%=a%>But it doesn't work and give me an error message about this component filter. I am thinking if i have overlooked any settings of component filters...Anyone who has used component filter before and have any idea about this issue would be more than appreciated. Thank you in advance.

For example, as shown below, when you click a data field, a popup with choices should have appeared automatically.However, I get an empty popup from today's morning (JST 9:00). Could you tell me why this happened?   Yours,Chen

Hi, Im new to Celonis and currently doing trainings in the academy. However most guided tours are not working. Is this normal? How do I fix it? I'm using google chrome as browser. tyia.

I want to benchmark/compare based on vendor, country and city. Is there any way I can get that in a single bitton dropdown instead of using 3 different button dropdowns. I want to achieve this in cascade, like if I select vendor I should see the option to select country and city values. Thank you​

Hi, I have a table with numbers and ratios in it. And I also have a dropdown list. I want to use the dropdown list to filter the table. And for ratios, I want those sum up to 100% even after filter. I tried to use variables in the component filter to do so, but it doesn't work. Any great ideas would be appreciate.

Is there a use case highlighting the process of analyzing ServiceNow ticket dump? Kindly help :)

Has anyone replicated the usecases of Process Simulation in your Sandbox/Test system ? Am finding issue while generating Simulation assets using KM. Any inputs or link to explore the fully functional Process Simulation cases ?

Hi,  I would like to extract a BPMN model from my Event Log but want to include additional attributes (like user role that is related to the activity, application in which the specific activity takes place, etc.) in order to generate a complete model of the process.  Is this possible, or can you only extract a simple BPMN model with the activities and connections?  Thanks in advance!

There used to be quick reference guide earlier for each topics in the form of PDFs. Now, I'm unable to find any.

Hello. Although the Tranformation Scripts create Activity names in German and English, only the english expressions for the activities are shown throughout the analysis (process explorer etc.)How to change the visual labels to German? thanks a lot, Marco

Hi there,I am looking for an efficient way to reduce the size of my data model: I already reduced the time period of the ingested data. As a second step I want to get rid of some unused table columns. To identify unused table columns I thought about doing the following:Export a .txt documentation of each analysis, then search for a specific table (ctrl+f) (i.e. LIPS) and document which columns are really in use in this analysis. I do this with all analyses and then I know which columns I can exclude in the extractions because they are not used anywhere.  It's not as much manual work as it sounds but still a lot. Do you know a better way to do this? How do you avoid such work in the future? Is there a standard procedure how to handle this problem or not run into it in the first place?  Thanks for your helpDaniel  

Is it possible, that I have a C4C+ project, which is only available over an VPN? And if yes, how can I set up this connection? Are there any technical specifications?

Does anyone know how I can create a histogram in a view? In the standard analysis sheet it is out-fo the box available but not in views. Or a way how I can create 'ranges' of a dimension?  

How can I get access to Celonis Sandbox? I did not get any mail from no-reply ID after registering to the client portal

Hello community, we are trying to create a task mining use case but we struggle with the event processing rule  Could you please support with the following: Process start should be only be triggered when the URL = a specific URL Process end should be always when an email is sent When another URL than a specific URL is used then task mining should not capture that informationSee screenshots attached of how the event processing rules are being configured.  

Cannot Connect to Data Model on ML workbench

I have given my App Key the following permissions:Space permissions: Use all packagesPackage permissions: Use packageAnalysis permissions: UseData Pool permissions (of the analysis): Use all data models celonis.spaces.find("Space123") works nicely, but then space.pockages will return an empty list. Consequently, space.packages.find("Analysis123") would not work. Which permissions do I miss? Cheers

Hello! For a project we want to embed a Celonis dashboard in our own website. I am looking for the best way of doing this. For example with Power BI we were able to embed a dashboard using a iFrame and were happy with the results. Is it possible to embed Celonis using iFrames as well? Or is there an other solution with similar results? Any leads are more than appreciated! Regards,Anshul