Skip to main content

Product Q&A

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

4438 Topics
abhishek.chatu14
Level 7
abhishek.chatu14Level 7
posted in Process Analysis
How to change color in Chart based on category in Celonis Views?

How to change color in Chart based on category in Celonis Views? I wanted to understand if it is possible to change color in Chart (Celonis Views) based on category, this is what I am looking for In the following image let's consider activities as the category, my requirement is that all category should be displayed the same color, i.e. Format Book should be yellow in both the cases, Edit draft should be orange, etc. Change in Y axis should not change the color scheme  I can achieve this in a KPI , by using the Custom Object option, however is there something similar for Charts or any alternative solution for the same ?

215
M
Level 3
I
Level 1
ignacio.eguigLevel 1
asked in General Product Q&A
¿Como puedo cambiar la cuenta de customer a cuenta de partner?o¿Como puedo eliminar la cuenta?

¿Como puedo cambiar la cuenta de customer a cuenta de partner? o ¿Como puedo eliminar la cuenta?

01
teuku.faruq13
Level 5
C
Level 3
chakradhar.pokalLevel 3
asked in General Product Q&A
How to delete customer data permanently from C4C

Successfully completed project. My client wants to understand how one can delete customer data permanently from celonis tool. My company has used C4C license to complete the project. ​Could any one share me standard process followed by Celonis to delete customer data permanently? If any documents on this pls share. ​If we want to delete manually once they give approval to delete is there any method. ​Thanks in advance​

24
C
Level 3
J
Level 2
jai.jainLevel 2
asked in General Product Q&A
Dashboard development, Testing , Production methodology

Team - We have one Celonis prod environment and would like to set up Development, Testing, production structure for multiple business areas(5-6 business areas). Do we have any methodology, document etc.

112
janpeter.van.d
Level 8
B
Level 1
bert.scheeLevel 1
asked in General Product Q&A
I've set up a weekday calander in Process Data Models that consist only of the working days (Monday-Friday, all day). Unfortunately in the Process Explorer, Case Explorer etc. the througput times aren't adjusted. Do I have to set up additional t

I've set up a weekday calander in Process Data Models that consist only of the working days (Monday-Friday, all day). Unfortunately in the Process Explorer, Case Explorer etc. the througput times aren't adjusted. Do I have to set up additional things?

111
teuku.faruq13
Level 5
luis.carra12
Level 2
luis.carra12Level 2
asked in General Product Q&A
Error in the eventtime of the activity table after copying data between teams using pycelonis

Hi, all.I've followed all the steps to copy (pull+push) data between two teams that are detailed in the documentation in pycelonis: https://celonis.github.io/pycelonis/1.7.6/tutorials/api_tutorial The transfer of data is ok but when I process the data model in the target team I get the next error: The load failed: Load failed. Error Message: Timestamp column ["_CEL_SF_CASE_ACTIVITIES"."EVENTTIME"] of activity table ["_CEL_SF_CASE_ACTIVITIES"] must be of type DATE, but got [INT]. It seems that the "push" loads the eventtime data as INT type instead of date time type.An example: the time stamp 15/11/2022 12:02:00 of the source tabla is loaded as 1668681300000000 in the target table. I've checked the source data when extracted in the pandas dataframe before uploading it ot the target table and it's OK.I've checked the data once loaded and it's NOT OK. Any help?? Thanks!   

01
teuku.faruq13
Level 5
H
Level 1
hiroaki.mori11Level 1
asked in General Product Q&A
Regular expressions use ^ as the starting metacharacter and $ as the ending metacharacter, but Celonis doesn't support end-of-line metacharacters. What are end-of-line metacharacters?

Regular expressions use ^ as the starting metacharacter and $ as the ending metacharacter, but Celonis doesn't support end-of-line metacharacters. What are end-of-line metacharacters?

21
teuku.faruq13
Level 5
W
Level 2
willem.van.d11Level 2
asked in General Product Q&A
Pivot Table Columns Order Changeable?Hello fellow Celopeers,I was wondering if there is any function to change the order of the columns in a Pivot Table.

I've looked in the documentation library but it didn't show me the options I'm looking for. I found the option underneath the 'Configure' button which allows me to change the ascending or descending order.  If anyone knows more please let me know :) Else I'll make it work with the descending order changes. Thanks in advance for your time. 😀

11
teuku.faruq13
Level 5
jascha.eul
Level 1
jascha.eulLevel 1
asked in General Product Q&A
What would be the best approach to analyse accounting data for the Newcomb-Benford’s Law?

What would be the best approach to analyse accounting data for the Newcomb-Benford’s Law?

22
teuku.faruq13
Level 5
dany.moual11
Level 3
dany.moual11Level 3
asked in General Product Q&A
How to update Augmented attributes through skills in the O2C and P2P value discovery app on EU-1 cloud project?

Hello, While framing some value which the Value Discovery App, I realized that the Inefficiency Augmented table are not getting actuallized, neither for O2C, nor for P2P on EU-1 cloud, although it works well on EU-3. While digging More, I realized that the Update Augmented Atribute Skill is not availble as shown in the following image. How could I fix the issue snd have the value discovery app working properly?  

82
dany.moual11
Level 3
naval.singh
Level 2
naval.singhLevel 2
posted in General Product Q&A
If I may suggest for your previous question, there are tools that calculate the sustainability impact of operations across the business.

If I may suggest for your previous question, there are tools that calculate the sustainability impact of operations across the business. A REST API connection can bring in that data for the processes and the same can be ingested in Celonis. Thanks.

00
naval.singh
Level 2
frederick.coutr12
Level 3
frederick.coutr12Level 3
asked in Data Ingestion & Infrastructure
The server selected protocol version TLS10 is not accepted by client preferences [TLS13, TLS12]

Here is the context of this error message (from EMS) when trying to connect to the DB:Extractor has been installed on client premises (Windows Server 2019) with OpenJDK11Target DB is running on Windows 2008 server. We're using Celonis to analyze processes prior to a system (legacy as you can see) migration.The same error message appears in the extractor logs obviously.Any insight on how to fix this problem ?

01
D
Level 1
felixkonstantin.allgö
Level 2
felixkonstantin.allgöLevel 2
asked in General Product Q&A
I have two activity tables and would like to select the one for the Throughput Time Search Component which is a type of Process Analysis Components.

Ín the documentation for the settings of such components it states in point 5 of the Throughput Time Search section that you can select the activity node and it refers to the selection of the Background Options which unfortunately does not offer the functionality? For the Variant Explorer there is a selection for the process nodes where you can set a custom dimension. Is this also possible for the Throughput Time Search Component or is there a workaround?

11
H
Level 2
.
Level 3
.14623407Level 3
asked in Process Analysis
I am doing the Process Discovery training - Lecture 2- DFG. In the Celonis Hands-on, I was able to add the suggested excel file as Data Pool but when I try to create new Data Model- it does not show me the data pool.

Although the file has been successfully uploaded. Because of this I cannot proceed forward. Also the display shown in the video is much different from what I can see in my cloud. I am attaching relevant screenshots

24
.
Level 3
michael.chung
Level 2
michael.chungLevel 2
asked in General Product Q&A
How to get average of record count for 90 day period

Hi All,I need some PQL coding help. I want to get a flat (or mostly flat) averge line for a 90 day period, but am not quite sure what I am missing. output table format:[created date] [id count] [90 day avg of id count] 90 day Avg (PQL):PU_COUNT(DOMAIN_TABLE("Account"."AccountNumber"), "Account"."Id", (CASE WHEN ROUND_DAY("Account"."CreatedDate") BETWEEN ROUND_DAY(TODAY()) AND ROUND_DAY(ADD_DAYS ( ROUND_DAY(TODAY()), -90)) THEN 1.0 ELSE 0.0 END) = 1) /90 Any suggestions on what to adjust?Thank you

12
michael.chung
Level 2
C
Level 2
christian.huppeLevel 2
posted in Process Analysis
Hi everyone,

Hi everyone, I would like to access a variable input/ dropdown component within an Analysis in the Studio using pycelonis 2.0.0. So far I get to the point where I can access the Analysis "ContentNode", but can't figure out how I can access those components. Alternative: Can someone tell me on how to access the Analysis variables? I can access the package variables but not the once from the Analysis. Thanks,Christian

55
G
Level 8
V
Level 4
vasco.caron11Level 4
asked in General Product Q&A
Unreliable Filter Extractions when using a mix of ANDs and ORs

Like the title says, I'm trying to filter a BSEG extraction as follows: (KOART = 'K' OR BUZID = 'Z' OR EBELN IS NOT NULL) AND (AUGDT >= <%=startDate%> OR AUGDT IS NULL) In English:One or more of the following 3 must be true:Account Type (KOART) = 'K'Line ID (BUZID) = 'Z'PO Number (EBELN) IS NOT NULLAND, One of the following 2 must be true:Clearing Date (AUGDT)>= 2021.01.01 (startDate parameter)Clearing Date (AUGDT) IS NULL Screenshot: However, when looking at the data, I'm not getting any cases where Clearing Date (AUGDT) is nullWhereas, in a previous extraction that omitted AUGDT as a filter field, we have 50K+ Cases with a NULL AUGDT Field, and adhering to the other Filtering Conditions: Therefore I can only assume that there is something wrong with the way that the filtering works.....that OR should always include cases with a NULL AUGDT. Not being able to use AUGDT as a filter is causing me to have to extract a gigantic amount of

12
V
Level 4
R
Level 3
roshan.kumar13Level 3
asked in General Product Q&A
Read the content of attachment

We have a use case where we want to read the content of attachment and find some pattern. If the pattern is there then we want to extract this data in to some table using action flow. Is there any action flow module which can read the content of pdf/word.We want to use the Salesforce action flow module to download an attachment. Next action is to read this data find pattern and then put the data in to some table in celonis ems.

14
R
Level 3
frederick.coutr12
Level 3
frederick.coutr12Level 3
asked in General Product Q&A
Which firewall rules are required for the on-premise extractor to reach the EMS ?

We are installing a Celonis extrator on a internal network and firewall rules must be configured in order to reach the EMS. Address "p-s-business-process-management-ciussse-chus-c4c.us-1.celonis.cloud" on port 443 has been opened as mentionned in the Celonis doc but it looks like authentication also tries to access https://id.celonis.cloud.Can you please provide the precise rules that need to be opened (from Extractor to EMS)? Thank you,Frédérick

43
teuku.faruq13
Level 5
M
Level 2
mohamed.amer13Level 2
asked in General Product Q&A
Hi All,is there anyone having documentation for MS Dynamics on-premise?thanks

Hi All, is there anyone having documentation for MS Dynamics on-premise? thanks

03
B
Level 1
muthappan.alaga
Level 4
muthappan.alagaLevel 4
asked in General Product Q&A
Is there a way to visualize the EXPLAIN query plan? like how we can visualize in graphviz

trying to see how to improve this query and what are the high run time and what to change to improve the run time. QUERY PLAN Access Path:+-JOIN HASH [RightOuter] [Cost: 52M, Rows: 6M] (PATH ID: 1) Outer (RESEGMENT)| Join Cond: (vbap.VBELN = VBRP.AUBEL) AND (vbap.POSNR = VBRP.AUPOS)| Join Filter: (VBRP.AUBEL <> '') AND (VBRP.AUPOS <> '000000') AND (VBRK.VBTYP = 'M')| Execute on: All Nodes| +-- Outer -> STORAGE ACCESS for vbap [Cost: 708K, Rows: 380M] (PATH ID: 2)| | Projection: 8e9add16-f209-4968-8e45-d1442c21cccb_cb2d42c8-e4fe-422e-8ac2-cf82c740f17c.VBAP_super| | Materialize: vbap.VBELN, vbap.POSNR, vbap.YYBOFLAG| | Execute on: All Nodes| +-- Inner -> JOIN HASH [LeftOuter] [Cost: 34M, Rows: 6M] (PATH ID: 3) Outer (RESEGMENT)(LOCAL ROUND ROBIN) Inner (RESEGMENT)| | Join Cond: (vbak.VBELN = VBRP.AUBEL)| | Join Filter: (VBRP.AUBEL <> '') AND (VBRK.VBTYP = 'M')| | Materialize at Input: VBRP.MANDT, VBRP.VBELN, VBRP.POSNR, VBRP

167
G
Level 8
andres.naran12
Level 4
andres.naran12Level 4
asked in General Product Q&A
Hi guys! Is there any way to reload only updated data inside the process data model? I mean I need only the updated data supplied but the process data model always makes a full reload, deletes the old data, and leaves only the new one.

Hi guys! Is there any way to reload only updated data inside the process data model? I mean I need only the updated data supplied but the process data model always makes a full reload, deletes the old data, and leaves only the new one.

64
andres.naran12
Level 4
luis.carra12
Level 2
luis.carra12Level 2
asked in General Product Q&A
Tech info on how works the pql.PQLColumn() function of Python for Celonis?

Hi, all.  I need to know how works the pql.PQLColumn() function of Python for Celonis. Does anybody knows where is the technical documentation?  I've tried https://celonis.github.io/pycelonis/1.7.6/ , and docs.celonis.com but is not enough. In this case I need to know how to use the format argument. Thanks!   PD.I've found only this short info when hovering over the function in the VS Code editor (class) PQLColumn(query: str = None, name: str = "Unnamed column", format: str = None, sorting_index: str | int = None, sorting_direction: str = None, not_included: bool = False) A PQL Column dictionary that can be added to a PQL query statement. Behaves like dict. Corresponds to Dimension and KPI in Celonis.Args:    query: The PQL query of the column (KPI or Dimension).    name: The name of te column.    format: The formatting of the column.    sorting_index: The sorting index of the column in a table (starts at 0).    sorting_direction: The sorting direction. One of [ASC, D

72
luis.carra12
Level 2
K
Level 2
ketan.sathe11Level 2
asked in General Product Q&A
what is a difference between EMS IPs as Target and EMS IPs as source, though for whitelisting we need to give EMS IPs as target. Please refer to the image attached

02
K
Level 2
E
Level 1
edina.varga12Level 1
asked in General Product Q&A
--Business Miner--Does anyone know where can I find the Process Workspace needed for setup this new feature of Celonis? Thank you!

--Business Miner-- Does anyone know where can I find the Process Workspace needed for setup this new feature of Celonis? Thank you!

01
muthappan.alaga
Level 4

Badge Winners

  • 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
  • Qualified to Build Views
    Marlijnhas earned the badge Qualified to Build Views
VIEW ALL
Community Code of Conduct