Product Q&A

 How to use Celonis predefined template apart from workforce productivity like Task documentation ? How to access it ? As I am not able to locate it in MarketplaceI enabled screenshots while recording but I am not able to locate them in analysis. can anyone pls help navigating ?How do you create Task maps / PDDs here. can anyone pls help with steps ? Thanks in advance

Hi community, I would like to create OLAP table which is shown in the attached pic. The table includes kinds of fruits, amount, and ratio. [QUestions]How can I calculate the ratio after applying a specific filter? [tried]Using SUM(filter to null(amount)) Thank you for your support!

We have an OLAP table on one of our Studio Views. Our analysts were not able to see the headers of a table(Column Names) while us admins can see those. All permissions to use this View have been provided.  Is there any feature/function or permission settings which blocks the user fom seeing the header of a table?  Best Regards, Sooraj Edayattu

Hi, I'm unable to access the link provided above. Can you please provide a step by step guide with screenshots? I want to extract the list of users in Celonis based on their access level (Viewer/Analyst) and the data models they have access to

Hi experts, I try to define delta filters for a SAP table that has columns with create/change dates as timestamp (for example, 20220615023536):when I use "date" type for the dynamic parameter - I get error during extraction: Value 2.0220804014626E13 could not be read as Date, expected formats: yyyy/MM/dd, yyyy-MM-dd, yyyyMMdd, dd/MM/yyyy, dd-MM-yyyy, ddMMyyyywhen I use "text" type for the dynamic parameter - I get error during extraction: Value 2.0220804014626E13 could not be read as Textwhen I use "integer" type for the dynamic parameter - I don't get error, but the value is calculated as 2147483647 instead of the original value - 20220804014626 Could you advise if there is a proper way to work with timestamps like columns? As the table holds different SAP objects at the same time, I can't use max ID or something like that. I could divide the extraction job into several separate jobs (for each involved SAP object) and create delta filters based o

Hello all. I tried to filter the column "Year-Month" but the problem is that there is a warning. I also checked if there is an error in my PQL coding, so I copied the code to the process engine and checked all the columns below separately. No errors.  Anyone has an idea how to solve this? The code for year-month is:  YEAR(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE)) || '-' || MONTH(MAX(_CEL_P2P_ACTIVITIES._CELONIS_CHANGE_DATE)) Another problem is that if I use "year-month" as a treshold my signals don't show. If i take the filter off, I see all signals. Thank you all.

Hi Team,  I am the administrator of Birlasoft Sandbox, facing issue around creating Action Flows. As an administrator I have all the privileges'. But when I opened the package to add action flow, I can't see the option. Can you help me here?  Screen-shot attached for more details.

Hi, I'm new to Celonis. I would like to know technical requirements for a Celonis Engine Server (on-Premise) used with IDEA PMX Client and minimum hardware requirements for a Client.

I have found two ways to get the activities via python. But I need the connections betweens them. I can check for all activities wether they have a connection to each other but with the complexity of O(n²) thats very inefficient and costs a lot of time for complex processes with many activities. Is there a more efficient way to get the connections?

In order to ensure the security of our data, we were thinking about deactivating the Public Link option on the workspace. Is it possible to deactivate the option on User Role levels ? So that we can control the access to the dashboard outside our company's network. Regards, Sooraj

We are trying to connect Celonis4.7.2 (onprem) to the GCP using the BigQuery Simba JDBC Driver supplied by Google. The .jar files have been unzipped into <installDir>\\lib but trying to connect from the frontend, we encounter the following errormessage: Has anyone successfully connected Celonis4.7 (or any other onprem version) to the GCP?  Thank you for your help! Cheers, Felix

Hi! I'm working with Celonis task mining, capturing data with filter by applications and URL, I have two different users, one can capture the URL and the other cannot. What could be the problem? Would it be firewall?

We have a corporate client, and they do not want the user to follow the download link... they want to force / manually install the task mining agent and make it active on the desktop. And that task mining agent needs to be linked to the correct corporate analysis platform.

Hi, I am in the middle of deciding on automation steps and want to understand difference between action engine and action flows.

How to calculate median for this ask. Requirement: Casetable count for a specific activity per document type?

Hello everybody.Two weeks ago I signed up for Training-Celonis-Cloud to successfully perform the exercises. Since yesterday I have not been able to access to the system (the log error is "Email or password are incorrect.". Although the credentials are correct).I tried to re-enter the new password with the "Forgot password" function but the error persists. Do you know the reason? Thanks. 

Hi. There is a webhook error when I duplicated an existing Action Flow. I duplicated Action Flow A to B, then I added a new webhook to B and tried to save it, but the following exception occurred.Am I doing something wrong? 

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?