Data Ingestion & Infrastructure

SAP Note: 3345663 - Termination of reseller agreement: On-premise solutions by Celonis  I read SAP Support note 3345663 and it says "SAP Support for the on-premise Celonis products will end." Is Celonis no longer supported on the SAP platform to extract data?

Is there a way to centrally managed the creation of process copilots? I know I can do it with the permissions to "create and maintain an studio package" but that is for everything within the package. Isn't there something that can be used to choose the studio packages where the process copilot can be created? https://docs.celonis.com/en/process-copilot.html

Would any of the possible permissions in here can help me with that:https://docs.celonis.com/en/managing-your-data-integration-service-permissions.htmlEdit Data Pool or Manage Data Pool I want to only let some groups have that possibility (creating new data connections)

Hi team, wanted to know does task mining recorder works properly and give accurate results for Windows 11? I've windows 11, but I was able to install the recorder, however few things didn't worked, like screenshots didn't got captured and I was unable to get process flow view of the task even after uploading the configuration file from task mining documentation app.

I have a “Case Table” table. This has 2 columns “Case ID” and “Target date”. I also have a 2 table “Horizon” with 3 columns “Case ID”, “Start date” and “End date”. The relationship between the tables is as follows: “Case Table” N : 1 "Horizon". The primary key is “Case ID” Target with the help of a PQL:I want to build a graph where on the X axis are the days and on the Y axis are the number of target dates.If the “target date” from the “Case Table” is between the “start date” (exclusive) and “end date” (inclusive) from the “Horizon” table, it should be counted.  Example (The case ID of both tables is the same “Case ID” = 1): Target date = 20.09.2024Start date = 18.09.2024End date = 22.09.2024 Result:X axis: 17.09.2024; Y axis: 0X axis: 18.09.2024; Y axis: 0X axis: 19.09.2024; Y axis: 1X axis: 20.09.2024; Y axis: 1X axis: 21.09.2024; Y axis: 1X axis: 22.09.2024; Y axis: 1X axis: 23.09.2024; Y axis: 0 A 1 is added for all days where the target date lies between the start date (

Removal of SAP on-premise extraction (OPE) client for data integration (2024-08-20) We removed the SAP on-premise extraction client from the Celonis Platform Download Portal on 2024-08-20. While any OPE instances that are already in use are unaffected, you now won't be able to set up a new SAP extractor or upgrade any existing SAP extractors. From 2024-08-20, you should use our on-premise client (OPC) instead. For information about accessing the OPC, see Installing on-prem clients. For information about the benefits of using OPC, see On-premise clients (OPC).

Is there a possibility to integrate data from Elasticsearch(where relevant journey data is present in an index) with Celonis. Also if new data can be pulled via a schedule again if the source is Elasticsearch

Is there a way to extract data from image or PDF and relate it with respect to the document number and We need to visit external URL and provide the document number. Each document will have its attachment which can be in PDF/Image format. We need to extract data from PDF/Image and prepare a table of the details (tabular format output) This table needs to be push to backend data model. Overall, we want to extract data from image/PDF relate with the PO Number/Accounting document number and push this data to backend data model.

HAs anyone tried moving Data ingestion and transformation out side Celonis like in Azure DB or Google Big Query?and what is the Pros and Cons in this approach

Would like to add fields from the AR_KNVV_KNVP_PA002 in an OLAP table along with fields from the BSEG table. However, have the error below - will the PQL functionality BIND ( ) work here?

Hi,Is there any way for a team admin to extract/gather view statistics for analyses and views?Ideally - event logs with events like object (analysis/view) + timestamp when it was viewed. Also it would be great to have user as well. The goal is to get an objective picture of how often particular objects are used instead of interviewing the users.For example, users say: "We use this report every day!", but you look into the stats and see that this report is open once per week/month. Therefore, maybe smth can be done to improve user experience. Thanks in advance!

Hi everyone, I am trying to calculate Automation Rate at Case Level.Within my dataset, each case have more than one activities. And, any of the activity could be either manual or automated. However, in my calculation, if case does have any manual steps; automation rate should be zero. Do you know how can I calculate it as a KPI?

Hi, I have the followng case, where I need to write the same code but in PQL:some ideas needed, I'm trying to implement this in PQL: "tbl_xxx"."date" + COALESCE(CAST("tbl_xxx"."time" AS TIME),'00:00') AS Date_Time As you see, "tbl_xxx"."date" is of type DATETIME, and "tbl_xxx"."time" is of type STRING.In PQL you have to use || instead of +, which only takes STRING, so the "tbl_xxx"."date" needs to be converted to STRING, but the issue is with "tbl_xxx"."time", because it can be NULL... Any ideas. Thanks

We are experiencing issues where a copy of an analysis or data model, when deleted, also deletes the original asset used to create the copy. It seems the copied object retains a link to the original object. Is there a way to create a copy of one or more objects such that the copy can be manipulated without impacting the original? Thank you in advance for your help and support.

Dear Experts , I was searching for Oracle procure to pay process connector from market place but it appears its not available , is it true ? has this been removed ?

Hello While extraction from SAP I am getting this error.  Does anyone know what could cause this ?

Hello Celopeers, whats the best way to handle NULL results in PU-Functions when I need 0 if no PU results are available? Here a example how I do it today: CASE WHEN ISNULL(PU_SUM(VBAK, VBAP.KWMENG)) = 1  THEN 0 ELSE PU_SUM(VBAK, VBAP.KWMENG) END Is there a way to make it better? BR, Thomas   

The PQL statement is FILTER ("ACDOCA_AP_SUSPENSE"."AUGBL" IS NULL OR "ACDOCA_AP_SUSPENSE"."AUGDT" >  {d '2024-06-02'}) AND  "ACDOCA_AP_SUSPENSE"."BUDAT" <=  {d '2024-06-02'};The above PQL statement works fine when I hardcode the date. I have created a date variable in a view(Is it possible to default it to the current date?). I want the user to select a date from the date range component, the date variable gets updated from the END date of the Date range and the PQL statement gets executed based on the selected date. But for some reason, it does not work for me. The PQL Statement is FILTER ("ACDOCA_AP_SUSPENSE"."AUGBL" IS NULL OR "ACDOCA_AP_SUSPENSE"."AUGDT" >  {d '<%date_filter%>'}) AND  "ACDOCA_AP_SUSPENSE"."BUDAT" <=  {d '<%date_filter%>'}; The error I get is attached in a screenshot.Any suggestions on fixing this or alternative solutions would be appreciated.

Is there a variable in PQL that I can use to display the datamodel refresh date & time?

Level 1: Newbie (0 - 10 points)I just join Celonis. Help me to explore Celonis Platform!

To join these 2 tables I use the fields "MANDT" and "AUFNR".In the table B, there can be several dates for the same order (AUFNR) and in table A I want to have only the most recent date for the order.So I tried the formula LAST(table.date ORDER BY table.date ASC) but it did not work. CREATE VIEW PP_QALS AS (  SELECT DISTINCT    "QALS".*,    LAST("AFRU"."IEDD", ORDER BY "AFRU"."IEDD" ASC) AS AFRU_IEDD,  FROM QALS_U_PP AS QALS  LEFT JOIN "AFRU_U_PP_TEMP" AS AFRU ON 1=1    AND "AFRU"."MANDT" = "QALS"."MANDANT"    AND "AFRU"."AUFNR" = "QALS"."AUFNR"), Do you know how I can add this date field in table A ? @lovise.helln​ (FYI)

Filter on the most common variant #3 and #4. Make sure the two variants are superimposed on top of each other. Looking at the Process Start and Process End dotted lines, which of the below statements are accurate? Select TWO options.

I am trying to find a way to modify the following PQL code to change the KPI by the selection of the specific time frame.  KPI("days_considered_for_inv_lt")*MOVING_MAX( PU_SUM(  DOMAIN_TABLE(ROUND_MONTH("o_custom_StockHistoryStorageLocation"."CurrentPeriod")),  FILTER_TO_NULL(COALESCE(   CURRENCY_CONVERT(    "o_custom_StockHistoryStorageLocation"."BaseTotalValuatedStockQuantity"    *     BIND(     "o_custom_MaterialMasterStorage",      PU_LAST("o_celonis_MaterialMasterPlant",     "o_celonis_StockHistory"."UnitPrice"))    ,FROM(     BIND(      "o_custom_MaterialMasterStorage",       PU_LAST("o_celonis_MaterialMasterPlant",      "o_celonis_StockHistory"."BaseCurrency")))    -- ,FROM("o_celonis_MaterialMasterPlant"."BaseCurrency")    ,TO('EUR')    ,PU_MAX(CONSTANT(), "o_celonis_StockHistory"."CurrentPeriod")    ,&

Hi, Can anyone help me to calculate time difference between LAST TWO activities in the process where last two activities are not fixed ones. Thanks in advance!

Hello good, When I work with a Pandas dataframe with the intention of transforming it to parquet to load it into Celonis, it is necessary to use "use_deprecated_int96_timestamps = True". Otherwise in Celonis the dates are recognized as integer type. However, what alternative is there when we work with Polars instead of Pandas to avoid this problem? Thank you so much