Skip to main content

Product Q&A

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

4438 Topics
S
Level 3
sooraj.edayaLevel 3
asked in General Product Q&A
Sorting the Filter Selection Views

Is it possible to sort the Celonis In-built dropdowns for Filter Selections (In Component Filter) in an alphabetical order? We do have the table names sorted alphabetically but not the column names (It is shown in the order as we defined with the Data Jobs). Is there a sorting function available so that our users can easily identify the column name in case large number of columns. Thank you 

121
S
Level 1
C
Level 1
chiara.greseLevel 1
posted in Process Improvement
Dear Celopeers,

Dear Celopeers, On March 24th, we are hosting the Celonis & EcoVadis Webinar:  Buying into Sustainable Procurement. You will understand how to use sustainability data in your procurement process to drive changes including:Report on sustainability performanceOnboard unrated suppliers and improve spend coverageIntelligently prioritize sustainable suppliers  You can directly register here!   

20
C
Level 1
M
Level 1
martial.renauLevel 1
asked in General Product Q&A
BMC Helix

Have somebody already use Celonis with BMC Helix for process mining ?

61
S
Level 1
.
Level 2
.1460077856Level 2
asked in General Product Q&A
How to Calculate Total Amount with Multiple Filters, Each with Three Constraints?

Hello,We want to write a formula to collect the NOV amounts of the people with all two constraints, can you help? CASE WHEN "_CEL_P2P_ACTIVITIES"."USER_NAME"='X' AND ("_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Submit Purchase Order') AND "_P2P_TCL_POSITIONS_V3"."eylem_sahibi_division" = 'CORPORATE LEGAL AFFAIRS'THEN KPI(NOV)WHEN "_CEL_P2P_ACTIVITIES"."USER_NAME"='Y' AND ("_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" = 'Submit Purchase Order') AND "_P2P_TCL_POSITIONS_V3"."eylem_sahibi_division" = 'CORPORATE LEGAL AFFAIRS'THEN KPI(NOV)...ELSE 0END

33
P
Level 1
I
Level 2
ivo.steinLevel 2
asked in General Product Q&A
individually, the dividend and divisor are correct, but when the quotient is calculated, the result is wrong

My case: (  SUM (    CASE      WHEN        PU_COUNT (          "Vorgänge_mElement_xlsx_Sheet1_CASES" ,          "Vorgänge_mElement_xlsx_Sheet1"."Aktivitätsbezeichnung" ,          "Vorgänge_mElement_xlsx_Sheet1"."Aktivitätsbezeichnung" = '<%= Abbruchaktivitaet %>'          AND          "abgeschlossen_xlsx_Sheet1"."ABGESCHLOSSEN" = 1        )        >        0      THEN        1    END  ))/( SUM ( CASE WHEN "abgeschlossen_xlsx_Sheet1"."ABGESCHLOSSEN" = 1 THEN 1 END ) ) If I only calculate the dividend, the correct value appears, also if i individually calculate the divisor. But when I try to calculate the quotient, the result is wrong. For example the dividend = 4 and the divisor = 9 the result need to be 0.444 but it appears 0.797 as result. Is that a bug by Celonis or what did I make wrong? Thank you in advance. Kind regards,Ivo

12
I
Level 2
.
Level 1
.1460051292Level 1
asked in General Product Q&A
Demo pack for Sustainability

In content.training celonis. We have demo packs for P2P and order Management , can we access similar demo packs for any Sustainability package?

41
B
Level 1
J
Level 1
jane.hangLevel 1
asked in General Product Q&A
The account type is selected as guest instead of partner when signing up. How could I change the account type?

The account type is selected as guest instead of partner when signing up. How could I change the account type?

41
S
Level 1
M
Level 2
mohammed.zoherLevel 2
asked in General Product Q&A
How to remap values in one table based on attributes on another table using PQL?

Hello, I want to create a custom dimension for the variant explorer in order to remap certain activity values to NULL. However the activities need to be remapped based on a corresponding table which holds information regarding which activities need to be remapped to NULL. For Example -> In the above images which are connected to each other in the process data model. What should basically happen is that activities A,B,D should not be changes but activity C should be remapped to NULL. Is there any way to implement this using PQL while building the analysis?

173
E
Level 1
M
Level 3
marco.baren11Level 3
asked in General Product Q&A
Using custom KPIs in Process Explorer View not possible?

Hi,adding custom KPI such as "Automation Rate" can by done in the Process Explorer of an Analysis. But this option is not available in the Process Explorer within a View. Is this by purpose? If yes, what's the intention behind it? I would like to show a low automation rate in order to use ML to automate incoming orders. Thanks!

283
L
Level 1
K
Level 1
kuni.matsuLevel 1
asked in General Product Q&A
I am going through Business Architect Value courses specifically in 'Guided Tours: Create Benchmarking, Dynamic Drilldown Table' and the Guided Tour, "Create Benchmarking", in the Academy icon is nowhere to be found. How can i retrieve this guid

I am going through Business Architect Value courses specifically in 'Guided Tours: Create Benchmarking, Dynamic Drilldown Table' and the Guided Tour, "Create Benchmarking", in the Academy icon is nowhere to be found. How can i retrieve this guided tour?

11
L
Level 1
M
Level 2
mercedes.mill√Level 2
asked in General Product Q&A
We need to upload files of more than 1 Gb size. Is the IBC Loader that can be downloaded from GitHub recommended by Celonis?Is there any other way to upload big files?Thanks

We need to upload files of more than 1 Gb size. Is the IBC Loader that can be downloaded from GitHub recommended by Celonis? Is there any other way to upload big files? Thanks

62
M
Level 2
M
Level 2
maximilian.emmri12Level 2
posted in Data Ingestion & Infrastructure
Hi, my Average of a PU-Function outputs two different values, when used in a table or a single KPI, when filtered for a dimension.

Hi, my Average of a PU-Function outputs two different values, when used in a table or a single KPI, when filtered for a dimension. When I use this simple PU function:  AVG(PU_COUNT("_CEL_RADAR_ACTIVITIES_CASES", "_CEL_RADAR_ACTIVITIES"."PROCESS"))  this happens: I have validated, that the output within the KPI is the right one, when filterd by a Dimension (in this case by "Deutschland"). Within the table however, the very same formula leads to wrong results. How can I fix it? What is the reason for it? I am just getting started with PQL. Since I could not find an answer within the forum, I hope you guys can help me. Thx Best, Max  

64
M
Level 2
S
Level 2
so.yahatLevel 2
asked in General Product Q&A
How to use LIKE in CALC_THROUGHPUT

Hi Community,I have a question : I'd like to use LIKE operator in CALC_THROUGHPUT function like this.​---FILTER (CALC_THROUGHPUT(LAST_OCCURRENCE[LIKE 'A_%']TO FIRST_OCCURRENCE[LIKE 'B_%'],REMAP_TIMESTAMPS("TABLE"."TIME_STAMP", DAYS))) <= 7 /* only within 7 days duration.*/​---but this doesn't work and I found the page* that is similar to my question.​This page is helpful, but in my case, the first half of the first argument(LAST_OCCURRENCE[LIKE 'A_%']) requires LIKE operator as well. ​Please let me know if you have any ideas.Thanks.​*Reference : https://www.celopeers.com/s/question/0D50700000GC6lJCAT/using-ldquolikerdquo-in-process-functions-as-calcthroughput?t=1645409602164

247
S
Level 2
S
Level 3
shritej.thorv11Level 3
asked in Data Ingestion & Infrastructure
Cannot able to extract tables from MongoDB using Python script/Python Connector

I have written a python script & it has no error. But still it cannot able to extract tables from Source. The uplink connection is successful. The script is returning data in json fromat. Can anyone please suggest solution?

195
janpeter.van.d
Level 8
R
Level 3
ricardo.basso11Level 3
asked in General Product Q&A
a3ERP

Hi all! Anybody knows or have information if there is a connector for a3ERP?

11
A
Level 1
.
Level 3
.146003860Level 3
asked in General Product Q&A
How to calculate the % for a specific selection?

Hi,  I am currently using this code: SUM("Sheet1"."Column1".'1' / SUM("Sheet1"."Column1") and I am essentially trying to find out how many 1s, 2s, and '-' there are, in the form of a percentage. I tried doing "Sheet1"."Column1".'1' so specific which value I am trying to calculate but I don;t think the code is correct? Thanks,Terence

11
E
Level 4
.
Level 3
.1460057128Level 3
asked in General Product Q&A
Pie Chart Dimensions Issue

In my current UseCase i do have the following issue: I have five transporters. Each of the them transports 5 packages.Therefore i do have 25 rows in my table. I also have the time when the packages need to be delivered and when the transporter delivered them. I want my pie-chart to show how many transporters delevered their entire load of packages on time and how many did deliver at least one package to late.  

35
E
Level 4
M
Level 1
matthias.eislLevel 1
asked in General Product Q&A
Export KPI to Share

Hello, is there an easy way to automatically export singe KPIs from an analysis to a shared folder? Data type is not important.  KR, Matthias

11
janpeter.van.d
Level 8
EBrozio
Level 2
EBrozioLevel 2
posted in General Product Q&A
Ready to seize unlimited opportunities?

Ready to seize unlimited opportunities? Visit the EMS Store from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners. Visit the EMS Store or find your team. Recently Added: Payment Behavior Advanced:Incoming invoices that are paid too early or paying dunning charges for invoices that are paid too late can lead to a considerable decrease of the liquidity. The analysis of the payment behavior and the optimization of payment based on this analysis is therefore essential for liquidity management. With this app you can analyze your Payment Blocks, see where you are not taking advantage of Cash Discounts and avoid losses due to Early/Late Payments.SAP ECC O2C Customer Scorecard Advanced:The Customer Scorecard App provides an easy way to gain an overview on the performance of important insights regarding a specific customer as well as KPIs of the own company performanc

10
EBrozio
Level 2
.
Level 2
.1460066609Level 2
asked in General Product Q&A
Are there Use Cases focused within the health care industry?

Are there Use Cases focused within the health care industry?

92
.
Level 2
T
Level 2
thomas.boehmLevel 2
asked in General Product Q&A
Could it be, that the Download data does not correspond exactly to the training examples anymore?

e.g. Last Question about number of connections for the concurrency matters data does not correspond

01
D
Level 1
rui.peixo
Level 2
rui.peixoLevel 2
asked in General Product Q&A
Is it possible to restrict users' access to dashboards by company code?

Hi, We are a shared services company and we would like to provide differentiated access to users depending on client/company code.For example: User A Access: Company codes 1000 & 1001 User B Access: Only company code 1010 Is it possible? Thanks 

73
gabriel.okaba11
Celonaut
J
Level 1
joonas.vuoreLevel 1
asked in General Product Q&A
Exporting analysis from Celonis cloud and importing it to other cloud environment

Could you advice if it is possible to export analysis from our Celonis cloud environment and import that (data model and visualizations) to other cloud environment? I have been trying to search but have not been able to find clear answer if and how this could done. Thanks!

21
gabriel.okaba11
Celonaut
D
Level 3
daniel.danie12Level 3
asked in Celonis Free Plan
Anonymization and Pseudonymization

Hi together, In Celonis Snap it seems that the Anonymization & Pseudonymization feature is locked. Just out of interest, how exactly does the feature look like in the enterprise edition? So it is possible to a.) anonymize (not possible to trace back / recover), and b.) pseudonymize e.g. with custom string or hash (possible to trace back / recover) ? In particular I would like to know whether its possible to trace back information of pseudonymized columns. Thank you in advance! Best regards, Daniel

1043
gabriel.okaba11
Celonaut
S
Level 3
sooraj.edayaLevel 3
asked in General Product Q&A
Data Reload Status Logs

I want to create an alert which sends e-mail to a group of recipients when the Data Load is successful. Is it possible to trigger an alert directly from Celonis? I can subscribe to a data pool to get alerts on reload failure but not when It is successful. In addition Is it possible to get the Log history of the reloads for analysis?

32
S
Level 3

Badge Winners

  • Qualified to Build Analyses
    pandiri.ravishas earned the badge Qualified to Build Analyses
  • Celonis Technical Expert
    Marlijnhas earned the badge Celonis Technical Expert
  • Qualified to Write PQL Queries
    Marlijnhas earned the badge Qualified to Write PQL Queries
  • Qualified to Build Action Flows
    Marlijnhas earned the badge Qualified to Build Action Flows
  • Qualified to Get Data Into Celonis
    Marlijnhas earned the badge Qualified to Get Data Into Celonis
VIEW ALL
Community Code of Conduct