Product Q&A

what insights generation can be done for production order

Hi All, I need a filter that filters out all activities where activity “A” is not first. So i only want to see all cases where the correct acitivty sequence is A → B → C → D...

Hello Celonis community,I’m building a new view and I need to set-up a line chart with multiple lines. Basically, calculating the same value but for different types and plotting them in differently colored lines.In the analysis set-up I used to duplicate the metric for each type and force filter within the PQL metric for the specific type. Now, with the view set-up we can plot only one line, sicne we cannot add multiple Y-axis.Is there a new way (ex. like the “hue” attribute in seaborn library for python) to do this? Or a tip workaround to be able to do it ?

I got the following message. but I do not know how should I solve the problem. Could you please explain the detail? Data model load failed during load to engine: Could not load data model. Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "A": key column ("E"), key ('00058B2D25244258B806'), rows 1 and 2. Table "B": key column ("E"), key ('EEE3E74B186040F48522'), rows 29 and 35. Celonis Support ID: e9012fd3-bf7c-4e59-9d7a-6b92484458a2

I created an Action Flow for PDF Reporting, but can only select my Analysis. Do you have an idea how to or if it is even possible to get my view(s) automatically into a PDF File.Kind Regards, Max

Hi all, The Celonis module that creates PDF's in Action Flows can't find my View. The Connection seem to work with the App Key that also has the right permissions and the View is also published. I always get the error "Something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID: e9c4bdad-04c3-49ea-b834-0e2dc618323b" from the 'Analysis' dropdown within the module. Does the Module even work with the new Views (JAB) since the next Parameter I need to fill in is 'Sheets' but the new View doesn't have Sheets, it has Tabs?

I've been experiencing a recurring issue with the sign-in process for both my Bentley and ABB projects. I often get the same error message, and while clearing cookies and history sometimes helps, it doesn’t always solve the problem.Has anyone else encountered this? Any suggestions for a more permanent fix, or is there someone specific I should reach out to for support?

Hi all,I encountered some problems with the Conformance Checker Sheet in the Analysis.I did model a BPMN model and its rather simple but has some AND parallel arcs as illustrated below.In natural language “A,B,C has to be finished before D starts,but the A->B arc and C can happen independently of each other”.In the Overview I can now see Violations like:A is followed by C B is followed by C C is followed by DAll of which I would consider allowed in the sense of the model. Of course I can manually whitelist all of the violations, but this is rather high maintenance and distributes the single point of truth which should be the model. For me it is about understanding if this is a limitation of the Conformance Checker.Did anyone experienced something similar and solved it?Or is my model wrong? 

Hello,As a new user of Celonis, I wanted to check if it's normal that some process connectors, such as the Service Request Management connector (for ServiceNow), don’t come with out-of-the-box applications. In such cases, is it up to us to build our own package from the ground up?

Hi everyone! I am trying to built a Celonis query where I calculate the median time in a process between the Event “DRAFT” and the Event “FINAL”. I would like to additionally get the median value only for one country (e.g. Norway (NO).I have the following query which seems to work without a country condition:MEDIAN( PU_MEDIAN( DOMAIN_TABLE("ACTIVITY_TABLE."ProcessId"), CALC_THROUGHPUT( FIRST_OCCURRENCE['DRAFT'] TO FIRST_OCCURRENCE['FINAL'], REMAP_TIMESTAMPS( "ACTIVITY_TABLE"."TIMESTAMP", hours ) ) ))Now I have problems adding the country condition which would be found in the column ACTIVITY_TABLE.”country”. Maybe I have been starring at the query for too long :D. How do I add it? Best regardsAlex

Everything I’m doing on my OCPM projects (saving and previewing transformations, publishing, running data jobs, loading data models) is taking an obscene amount of time. I’m talking 2+ hours for something that used to take minutes…Is anyone else experiencing this?

Hello all, I would like to know if it's possible to extract the user adoption data/login history from the Platform Adoption View via Pycelonis 2.0.1 (I have the CSV export feature enabled, btw).  I'm trying to navigate to the specific object, but I can't even reach the Admin & Settings panel. Thanks in advance for any help.

Tried with Python script to extract table from the web page, however it didn't work.

how can we write a Pql Statement to count the activities passes through the cases

Hi everyone!I'm having issues with a formula, can you please help or tell who can help me?My goal is to have an OLAP with fields from EKKN and EKPO. I need a KPI to sum the PO item values in EUR. Formula: SUM("EKPO"."NETWR_CONVERTED" )Error: The aggregation function SUM is applied on a column from table "EKPO" which has a 1:N relationship to the common table "EKKN". This means that one input value can contribute to the aggregation result multiple times. For more information search for "Join functionality" in PQL documentation. I've checked the results and, in some cases, it is summing the same value more than once, as predicted by the error. The following solutions did not work: SUM ( CASE WHEN INDEX_ORDER ("EKPO"."NETWR_CONVERTED",PARTITION BY (FILTER_TO_NULL ("EKPO"."NETWR_CONVERTED"))) = 1 THEN "EKPO"."NETWR_CONVERTED" ELSE  NULL END)https://docs.celonis.com/en/sum.html PU_SUM("EKKN","EKPO"."NETWR_CONVERTED")Error: Pull-Up-function could not be executed. PU_SUM: Cannot execute PU-fu

Hi all, I'd like to know if we have one time SAP data extractor that optimized for OCPM Core 5 process. I know this extroctor but it is only available for specific case centric data extraction like O2C or P2P. (I also know it is able to extract specific table one by one with it.)https://docs.celonis.com/en/one-time-extraction-from-sap-ecc-or-sap-s-4hana.html Does anybody know optimized extractor for OCPM? (I found data uploader in OCPM data pool.) Thanks in advance,

Good dayI would like end users to be able to configure a time and then be able to use this time in various KPI calculations in the Views that we are building. I created a Runtime variable (package level) called COTime_USD, I then configured input-box Form Component in a view and set this to data type: time (the input-box can also take “date”, “number” and “string”). I would then like to use this variable ${{COTime_USD}} in calculations and typically add it to a date (ie ROUND_DAY("o_custom_Payment"."Date").I have seen for dates, the variable needs to look like this in order to get it to work in calculations: {t ${{COTime_USD}} }, but I am not sure what I should use in stead of the “t” to define it a time.  When I try to execute the calculation I get stuck at “Syntax error near [:]...”. I have tried the following calculations: ROUND_DAY("o_custom_Payment"."Date") + ${{COTime_USD}} ROUND_DAY ( "o_custom_Payment"."Date" ) + {t ${{CutOffTime_GBP}} } TO_DATE(TO_STRING(ROUND_DAY ( ""o_custom

Hello,Our team is in the process of setting up Linux 8 on our production server and are seeking to migrate the Celonis Connector from our previous Linux 7 server.The Linux 7 server currently uses JDK 11 and a 2022 version of the JDBC connector without the aid of an on-premise client.Would it be recommended to install the current version of the JDBC connector (and JDK dependency) separately, or would installing an on-premise client package be better?

Dear Community,  we would like to use the workday calendar feature in the data model, so that we can calculate the lead time excluding all public holidays + weekend.  Since our data source is not based on SAP, we don't have the TFACS-Table. Can someone help and tell me what kind of table I should update here as a workday calendar:which columns are mandatary?how should the table look like?what is the corresponding data format? An example table would be very helpful here.   Thank you in advance.  Kind regards,Liz

As explained in the documentation, we have added a TFACS-style calendar from our data pool in order to determine workdays between two dates: However, when trying to access the table from the Studio, for instance like this:  WORKDAYS_BETWEEN(  MIN("_CEL_P2P_ACTIVITIES"."EVENTTIME"),  MAX("_CEL_P2P_ACTIVITIES"."EVENTTIME"),  WORKDAY_CALENDAR("AT_TFACS", 'AT')) we get an error message saying that the table does not exist.  The workaround we have done to solve this issue consists on adding the AT_TFACS table to the data model without any connection to the rest of tables in the data model: This does indeed solve our issue. However, we ask ourselves: Is this a clean best practice? Should the table be automatically available in Studio once added as workday calendar option?What happens in the backend when adding a TFACS-style table to calendar options?   

We need for a use case the text which is stored in the SAP table STXL.I know that Celonis provides a converter program for the table STXL.https://docs.celonis.com/en/extracting-the-table-stxl.html We currently using SAP R/3 and S4H. Form the IT Department I got the message that the Celonis program only works for S4H. My question is, if some knows if it is possible to use the program for R/3 and what for changes we must do that it works for R/3. I hope someone can help me.Regards, Christoph

Hi everyone, I am currently working on optimising extractions in Celonis and applying delta for tables. But tables like BSEG, RSEG and CDPOS are not having the relevant date fields nor I can apply header table filters which I joined with these tables in delta filters. Is there any possible solution to apply delta on these tables ?

Hello,Can we create users in Sailpoint and can we integrate with Celonis so that user will be created automatically with a role in Celonis?

Hi all,I try to display the correct throughout time for the process variant in the Variant Explorer (shown to the right for the graph/list) for cropped process flows.I have cropped the process scope using CALC_CROP, both as a custom dimension and as a load script filter. The Variant Explorer returns the correct process of scope, but the total throughput time shown per process variant (shown to the right for the graph/list) is still based on the default CASE_START and CASE_END and not the process defined in the CALC_CROP.I.e, the sum of throughput times between the displayed process steps is not the same as the total throughput time for the variant.Is it possible to show the correct throughput time, given the process defined and visualized in CALC_CROP?Thanks!

 I did set up a record with identifier and the comment component of the "new View" which worked fine and created a new record called "... Comments" in KM. Now I got a change request to change the underlying record and consequently its ID. I did change the identifier of the record. But now (kind of as expected) the comments record is "misconfigured". I get a warning in backend data integration dataload:"Client Error: Can not find the join partner data model column [XXX] for the augmentation column [XXX] in the loaded data model. Querying this augmentation table will not work until the data model schema inconsistency is fixed." In Knowledgemodel "Comment Record" I also get error "Augmentation table wit name YYY_COMMENTS has an invalid configuration and will not be queryable until it is fixed. For details please check the load warnings." I would be fine just deleting the record and table and start from scratch. No need to migrate