Product Q&A

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

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 ?

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

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 ?

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

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

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

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

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