General Product Q&A

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, 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.

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 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.

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? 

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, 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 ?

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