Product Q&A

Hi everyone,  as the title of the topic suggests, I'm searching for the possibility to connect Celonis and Marketing Cloud Salesforce. The official documentation doesn't say anything about, and there isn't a specific connector to make possible this operation. Does anyone have news of this implementation? It would be ok for me also building a custom API to retrieve data from the Marketing Cloud. Thanks in advance for the help,Regards,Emanuele

Is there a connector for IBM Maximo?

Hi All, Together with my colleagues we have started trainings in Celonis, however we are facing the issue, that the UI that we are seeing on training videos is different that the one that we see on training environment that we have established.Is there any option to change this view in training environment? Currently we are unable to follow training materials. 1) My training environment 2) Video environment: Thanks in advance for your support.

Hi, i am looking to build a histogram in a view with a KPI which gives a throughput time between 2 activities. I need the frequency of cases on Y axis, and a (automatic) grouping/bucketing of the KPI values on the x axis. I have tried to use the Histogram option in the View, but it seems not to accept KPI's (only data value columns). So i created a Record (attribute) in the activity table with the same formula as the KPI and use that as attribute in Histogram instead. But i get an Error: "Aggregate expressions cannot be nested inside aggregate expressions." Is there any other way of producing the desired result? I can use a normal chart but it will not do the buckting automatically and i don't know how or where to create an extra buckting table. Thanks in advanceHimanshu 

What is the difference between Signal and Object Links? Hi, i am investigating how to best create network graphs for a BOM and I came across the Signal Link and Object Link. I already have a basic BOM using Signal Link but as i want to use the LINK_PATH operator i now need to switch the BOM to Object Links. I'm having trouble in understanding the difference between the two and what are the pros/cons of one or the other.  Does anyone have experience using the Signals, and can expand on the differences? Thanks in advance for your insights.

I would like to identify the incidents for which the assignment group is changed more than two times. I am able to write this in SQL but need some help in converting this to PQLSELECT INCIDENT_NUMBER,COUNT(*)FROM "_CEL_INC_ACTIVITIES"WHERE ACTIVITY_EN = 'Change Assignment Group'GROUP BY   INCIDENT_NUMBER ORDER BY 2 DESCThanks in Advance

Hello everyone, has anyone experienced this in Celonis? I'm doing a date filter, but in the frontend it's bringing me an extra day, but in the database it brings the period that I filtered.Below images showing.Thanks.

Hi for my use case requires me to add a 5-10 sec delay for each iteration of the data i.e. 6000 -7000 rows i.e. (6000* 5-10 sec) I believe that adding this delay should not cross the 1 hours execution limitations. Any thoughts on the same ?

How to add concatenated column in benchmarking dropdown and filter that column with KPI's and process explorer

Can i change the font colour from a component in a analysis via pycelonis?

I am trying to create a custom KPI using Visual editor but somehow the visual editor is empty (can't access/see the visual editor option)?Any idea why this is happening?

I wanted to use the following filter statement which unfortunately doesn't work:FILTER "Table"."type" = (<%=type1%>) AND "Table"."type" = (<%=type2%>); Strangely enough, the filter does work if I replace the 'AND' with 'OR' like the following: FILTER "Table"."type" = (<%=type1%>) OR "Table"."type" = (<%=type2%>);. However, this would have the same result as an 'IN' statement like the following:FILTER "Table"."type" IN (<%=type1%>, <%=type2%>); But I need an 'AND' or an 'IN' where all selected 'types' are true and not only one from the 'IN' list. Can someone please help me with that issue?

what is celonis?

uploaded parquet file the timestamp is different how to convert into readable way in transformation using sql

Hello All, Looking for some Benchmarks in KPI's associated with Accounts Payable, E.g. What is the Exception % Allowed generally?, What would be Automation Rate at? First Time Resolve / First Time Yield %? Any leads will be helpful.

Hi,  I am using Augmented Attributes in a Knowledge Model to build a View App. The A. Attribute is defined to have 4 possible values (dtype string) and it is meant to be updated manually by the end-user in the app to any of those 4 values. It has a Default Value as well for all those cases where the end user did not manually updated the attribute (which happens frequently). The problem comes when I want to use the "VALUE" field stored in the augmented table from the attribute in the Knowledge Model. I want to filter a chart based on the Attribute´s values (again stored in the VALUE field) and also define a KPI with a CASE WHEN logic based again in the value of the attribute. When I do so, it just returns the rows or datapoints where the Attribute was manually updated, filtering out all the rows for which the default value should appear.  I have not found a way to include the default value in the PQL queries outputs that I desire, so that I do not get most rows filtered out wh

HiWe are currently exploring process mining capabilities on SAP Kofax/ Readsoft data regarding potential opportunity with one of our Clients. We already identified process connector, however the specification in Marketplace is not available. Therefore looking for detailed list of activities which come with pre-defined model, specifically the action in performed Readsoft.We would like also to check there are any analytic apps matching data model from this connector. Thank you in advance for your helpregardsMichał

What are the limitations of Celonis Free Plan in capabilities and GB size compared to the commercial plan? How can one estimate the GB required for certain number of processes?

In order to have an accurate calculation of the throughput time between my process activities, I would like to specify the following workdays calendar: from Monday to Friday, 9:00 - 18:00. Something similar is already available for some components, like the Throughput time search:I would like to do the same also for other components where I'm going to use the throughput time as KPI.  Thank you in advance, Giulia

Hi Experts,Our IT is asking for predefining all the data fields for each table for them to create views to be used for process mining by Celonis. We need the same for P2P, AP, O2C and AR (all possible major use cases for now) but not able to get anywhere. IT has not approved to make tables available fully due to security reasons and space constraints. please guide

I want to calculate the week average daily number of employees doing one action. For that I need to calculate the number of different usersID's (thus a count_distinct) each day And then calculate the average of of those values in the same week. That will tell me, during that week, what's the average daily employee attendance to that action. How to do it? It should be fairly standard by I can't get it! I have a case table with timestamp of the action, and the user that did the action. And I want a OLAP with Week number - average of daily users I have used this struct: AVG(PU_COUNT_DISTINCT(DOMAIN_TABLE(ROUND_DAY(CASE.TIMESTAMP)),CASE.USER)) but the results are incorrect Can anybody tell me what I am doing wrong? TIA

The date format that appears in the CSV output file from Celonis action flow CSV module is not showing correct date (showing wrong time stamp) for example in my data initial date is 8/12/2021 1:52:00 AM but in csv 8/12/2021 2:52:00 AM. Can anyone help?

Hi, During initial implementation there was a decision to pseudonymize column USNAM in multiple tables. Currently it was agreed that we need to have actual (not pseudonymized) users data in Celonis just like it is in SAP.Usually unticking the Pseudonymize box in extraction setup would do the trick and I will do it for some smaller tables for which we have full loads. However we have couple tables for which we are doing only delta loads, as they are way to big for full loads (over 40 GB). Doing full load for them would take ages and I'm not entirely sure how Celonis would manage with such a huge load done at once. The idea is to create one time mapping by downloading second iteration of that big table (BKPF is original one, the second one lets call it BKPF_RAW), that would only contain the 4 key columns and USNAM that is not pseudonymized. Next step would be to add new column (lets call it USNAM_RAW) to original BKPF, then update it with data from BKPF_RAW.USNAM by matching the two

What can be reasons for Open Invoices. Any Available views for Open Invoices in Accountz Payable.