Data Ingestion & Infrastructure

Both the functions are used to retrieve rework, what is the difference ?

Hi Team,I am working on pulling sum of values from a particular table column in Celonis using PQL. I want the sum of distinct values of the table column. However, when I do SUM(DISTINCT Table.Column) it is giving me sum of all the values in the column and not the unique ones.Is there any way in which I can find the sum of unique values of a table column?Thanks in advanceRegards,Soham Potdar

The goal is to retrieve the 'Status' information to highlight the "Invited" users (fetching data using SCIM doesn't give this information). 

Hello everyone,Were trying to connect SAP ECC to CIBC. We have installed RFC and extractor but when we test, it says:Connection test failed, please check the Data Connections configuration and ensure that the system is running: Error during connection validation: OPEN DATASET - No OS Permission to open file /tmp/CELONIS/CEL_EX_If anyone can help usThanks!

Hi, Does Celonis have best practices on how to automate the deletion of old day (say data older than 1 year)? I understand that I can write my custom scripts with delete statements and execute them. However, given the underlying data model (that also has relationships) and timestamp definitions in each table, is there a way to leverage that and easily automate deletion of old data (ex : older than a year)? Thanks,Bhasker

Dear community members, We encountered a strange case where in SAP ECC in table MSEG we have a document with ‘PC’ as unit of measure (field MEINS) while after importing the data in Celonis we have ‘ST’ as unit of measure (see the attached images). Have you any similar issues? How did you solve it? Thank you! 

Error: Could not load screenshot. As the screenshot is non-zero, there should exist a screenshot that could not be loaded 

Example: A(1)-C-B(1)-A(2)-B(2)-N-A(3); In this case I need the throughput time between A(1)->B(2). any ideas?  For the rest it should show me values like C->B(1),B(2)->N and N->A(3)  Currently I use something like the following  DATEDIFF(dd, SOURCE ( "ACTIVITIES"."EVENTIME" ),TARGET( ( "ACTIVITIES"."EVENTIME" ))) However this works for the rest of the flow but for A(1)->B(2) it will just return 0

We are currently working on an implementation work where we are trying to capture two parrallel process using multi event log approach. But with the upcoming feature of Process Sphere we are trying to assess whether the multi event log will be replaced by Process Sphere due to its similarity. Need other people view and suggestions on the same.

Hello, i would like to know how can i setup my view to be able to see my screenshots made with the task mining.

Is there any standard practice available to back up the old data from Celonis tables in CSV, Text format in IBC itself?

Want to leverage all the P2P metrics.  Please note that i have completed till Data Model load, only thing i want to leverage all the KPIs from the Market place.

Dear community members, is it possible to integrate data processing tool like Alteryx with celonis ? have you ever tried this ?

Hi, in phase to upload a file into Celonis, i m getting this particular error:Failure type DATA_PUSH_JOB_NOT_SUCCESSFUL. Failed to start data push job executions Has anyone had this problem before? Thanks

Dear community members, Is it possible to integrate Data processing tool like Alteryx to support easy extraction and transformation before creating a data model in Celonis. ?

Hey, I have a use-case where events can happen super fast. Hence, I build an activity table with a Millisecond Timestamp. When I read it in via file upload, it detects the Milliseconds with the format yyyy-mm-dd HH:mm:ss.SSS. But after loading it does not show the miliseconds in the respective timestamp column, only with seconds. Do you support Milliseconds for the timestamp column? Do you have a workaround for proper ordering, when Sorting column would not work? I would appreciate any help.

Hi, I am setting up the data permission for our organisation.We want to grant access to certain data models by Profit Center.However a certain Business Unit may have more than one Profit Center. When I limit the access to a data model to these Profit Center, only the data associated with on of the Profit Center is shown in the Analysis in Studio. ExampleBusiness Unit A uses Profit Center Offline, OnlineTherefore the data model access is granted for Table.Profitcenter --> Offline, OnlineBut in the analysis only Profitcenter Online is shown Do you have any idea why the data permission works like this?Or did I miss something? I am grateful for your advise.Dan

I need to count the number of invoices which follows a process flow 'Payment after Due date passed'.

I have the PQL query as follows:  it returns:   How can i amend my query to remove the '0' counts for processes that do not have any rework on them? Thanks

We have table A (case table) and table B connected to A as 1:N relationship, 1 A has N BsWe want to show in an OLAP table A and B, and we want to aggregate SUM(B) for each A, so we can use SUM or PU_SUM. We are using SUM because we want the result of SUM(B) to be affected by filter selections. If there is A with missing values at B side we would expect to see A and NULL at the B column However we won't see anything unless we apply PU_SUM(B), and as said above, PU_SUM doesn't support filter selections so it cannot be used for this use case.Is there another way to see the A values together with NULL values at B column?

Hi, I have the following use case and challenge: Use Case: Add a line as second KPI to an existing column diagram that shows the average of a KPI value for each labor week Dimension: ROUND_DAY("TABLE"."TIMESTAMP") KPI 1: COUNT("TABLE"."NUMBER" || "TABLE"."FIELD") - columns KPI 2: Show the average of KPI 1 from Monday - Friday for each week - line My attempt: WINDOW_AVG(COUNT("TABLE"."NUMBER" || "TABLE"."FIELD"), 0, 5, ORDER BY("TABLE"."TIMESTAMP"), PARTITION BY(ROUND_WEEK("TABLE"."TIMESTAMP"))) This does not work unfortunately as I can not use the COUNT within the WINDOW_AVG function. Does anyone know any alternatives?

Hello Peers. Have have a requirement from customer to calculate the Time Duration B/w Customer PO in Sales Order (VBKD-BSTDK) Vs Production PO (via PR MRP Run -MEPO_TOPLINE-BEDAT). Br/VM

Hello, I use my formula (CASEWHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-S%'   THEN 'South Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-A%'   THEN 'Saxony-Anhalt'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-W%'   THEN 'West Saxony'WHEN "/RWEE/PMCP_TAUFK"."ARBPL_AN" LIKE 'S-%-B%'   THEN 'Brandenburg'ELSE ' ' END) to cluster values. Works great, except that it always gives me the ELSE values as 0 in my graph. 0 means that there is actually no ELSE, or in other words, everything is clustered. How can I hide the 0 in the formula or in the component filter?  thx :-)

Hey Peeps,  can someone help me. I try to connect, the correct PO to the corresponding SO in the IM Datamodel.See picture below.  I tried the BIND() and several PU functions.  Would be great if someone could help.  Thank you.  Daniel

===============================Usability of MarketPlace Connectors in "REALITY"================================= Hi Team,I have started my market place journey by installing SAP "Order to Cash" Connector. Below was my experience :1)I tried to install the app in studio but it gave multiple errors for the Data Model.2)I looked at the data model and tried understanding it. -There are no documents to understand why that data model is build in the way it is.3)I looked at standard SAP tables and tried to understand it by looking into transformation.4)Transformation does have big quereis and most of the places there is no explanation of what does those quereis mean.5)I finally reached SAP functional consultant and technical resource to help me understand the quereies.6)Currently i am working with them and reverse engineering to understand what has been provided with connector.7)Parallely i raised a ticket to Celonis support for providing comprehensive documents but they re