Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3154 Topics
.
Level 2
.1460039628Level 2
asked in General Product Q&A
How can I show the ratio after applying a specific filter?

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!

30
.
Level 4
S
Level 3
sooraj.edayaLevel 3
asked in General Product Q&A
Headers of OLAP Component on Studio View not visible for Users

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

00
joost.herma
Level 4
A
Level 2
aakash.kulkaLevel 2
asked in General Product Q&A
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, 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

00
A
Level 2
A
Level 1
anton.kozhiLevel 1
asked in General Product Q&A
How to use dynamic parameter for SAP column that have TIMESTAMP type?

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

110
janpeter.van.d
Level 8
S
Level 3
siddhesh.naik11Level 3
asked in Process Improvement
Not able to find option to add action flow into the package.

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.

00
S
Level 3
partner.porta13
Level 1
partner.porta13Level 1
asked in General Product Q&A
When he/she clicks on the Library section after logging into the Partner Portal.It says that Error "you do not have access to the Apex class named 'qsydFileExplorerController'.How can he/she has access to the Asset Library?

10
R
Celonaut
B
Level 1
barbara.mangoLevel 1
asked in General Product Q&A
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.

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.

00
T
Level 1
F
Level 1
florian.mansfLevel 1
asked in AI
How can I get the connections from the process explorer/process graph via Python?

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?

10
T
Level 1
S
Level 3
sooraj.edayaLevel 3
asked in General Product Q&A
Deactivate Dashboard Public Link options for Analyst users.

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

40
T
Level 1
.
Level 2
.14600957Level 2
asked in Data Ingestion & Infrastructure
Connecting Celonis4.7.2 to GCP BigQuery using Simba JDBC Driver

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

00
V
Level 1
M
Level 2
marcia.cristina.silvaLevel 2
asked in Data Ingestion & Infrastructure
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?

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?

00
R
Level 3
J
Level 2
jaco.kacheLevel 2
asked in General Product Q&A
When deploying a task mining agent to a desktop, is there another way to create an install package and deploy the task mining agent without using the invite method with a download link for an user?

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.

30
R
Level 3
S
Level 3
siddhesh.naik11Level 3
asked in Process Improvement
What is the difference between action engine and action flows?

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

80
S
Level 3
C
Level 3
claire.chen12Level 3
asked in General Product Q&A
[Action Flow] Webhook Error when I duplicated a Action Flow.

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? 

40
T
Level 1
R
Level 4
raman.silot14Level 4
asked in Data Ingestion & Infrastructure
Data Model VS Joins

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 ?

00
T
Level 1
V
Level 4
vasco.caron11Level 4
asked in General Product Q&A
Can I schedule my Action Flows to execute differently, according to the day of the month?

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

60
T
Level 1
C
Level 3
claire.chen12Level 3
asked in Process Analysis
[Action Flow] How to pass the csv file from Action Flow to Skill?

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

30
V
Level 4
steven.bernd
Level 3
steven.berndLevel 3
asked in Data Ingestion & Infrastructure
Count days between activities, but with condition

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

00
steven.bernd
Level 3
A
Level 3
antoine.leducLevel 3
asked in General Product Q&A
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 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

10
A
Level 3
A
Level 3
antoine.leducLevel 3
asked in General Product Q&A
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 :)

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 :)

00
A
Level 3
E
Level 3
ewa.aniśkLevel 3
asked in General Product Q&A
How can we apply colours to charts/process explorer/tables in Views?

How can we apply colours to charts/process explorer/tables in Views?

110
E
Level 3
J
Level 1
jan.ploegLevel 1
asked in General Product Q&A
How can I display costs of activities in the variant explorer or process explorer?

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

10
F
Level 3
Y
Level 2
yuyao.wang12Level 2
asked in General Product Q&A
Something went wrong with component filter

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.

00
F
Level 3
C
Level 3
claire.chen12Level 3
asked in General Product Q&A
[Action Flow] Empty popup when click a data field in Action Flow module

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

00
C
Level 3
Y
Level 2
yuyao.wang12Level 2
asked in General Product Q&A
Calculate Ratios

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.

50
Y
Level 2

Badge winners

  • Qualified to Prove Celonis Value
    lasse.muellhas earned the badge Qualified to Prove Celonis Value
  • First Post
    SHASHANKhas earned the badge First Post
  • Qualified to Manage Implementation Projects
    anna.jakub12has earned the badge Qualified to Manage Implementation Projects
  • Qualified to Identify and Drive Opportunities
    kalparup.paulhas earned the badge Qualified to Identify and Drive Opportunities
  • Qualified to Prove Celonis Value
    schahram.hamrahas earned the badge Qualified to Prove Celonis Value
VIEW ALL
Community Code of Conduct