General Product Q&A

I am a beginner and doing the process mining course from Celonis academy. I have successfully create a data pool and corresponding data model. It is showing that data model is successfully loaded too but when I try to do analysis, and create a new data model variable, it does not show in the drop downs. I have attached the screen shots below

Any innovative research or point of view or use cases that are beyond P2P , O2C or any traditional use case.

Which Algorithm does Celonis use for Process Discovery and Conformance Checking?

How can I calculate the Share of Product Type for each Delivery Number? In the enclosed screenshot, I'm trying to calculate the yellow column. I tried by using the PU_X functions, also combined with 'DOMAIN_TABLE', but I couldn't get any kind of result.

How to enable Action flow to execute the skill only if we have records from query data?

Hello togheter,  currenty im trying to set up an action flow which is triggered by new Data in an Action Engine. I read that this can be done via a Skill. The Action Flow starts by using a custom webhook and then quering data from Celonis. For the skill, i first set up an Action Engine Sensor and secondly an "Execute Action Flow" command. Within the Action Engine i filtered the data for the data im looking.  Currently I am facing the problem that if I delete all manual inputs in the 2 commands of the skill the skill seems to trigger the action flow but the custom webhook component within the action flow doesnt receive any data. Based on this if I want to put data into the webhook it will be done manually, which is not the point of the aciton engine.  So my question is: how can i set up all these components that the skill, based on new data in an action engine, only triggers a action flow without trying to provide data to the action flow? Is that possible? Thank you very much!

Hi, would you recommend any specific course related to the Studio for an end user? The ones I saw are recommended for development matters.

download user list as .csv  invite new users

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

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​

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.

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?

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!   

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?

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

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

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?  

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.

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

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

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

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.

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

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

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