Product Q&A

Hi, I am trying to calculate the so called calendar week of a date-attribute in the course of a transformation. The function to be used is CALENDAR_WEEK; however, I get an error message: "Execution error: Function CALENDAR_WEEK is not supported". Why?

I do not understand the difference between an extractor builder and an extractor. Are both types of data connections? For example, when making a data connection, should I look for a connector and if there is none, use an extractor, or if there is no extractor either, use the extractor builder?

How we can find change activities occurring at PO level ?

He guys, tl;dr how to: One chart with created & completed & open orders, with slightly different filter (including / excluding activities) Long version I am analyzing order data and I am interested in visualizing both: created and completed orders, on a monthly basis (The cherry on the cake would be a line with the cumulated difference between created and completed orders increasing amount of open orders). It is not a problem for me to build a Column Chart for created and completed orders (separated): Created: Dimension: ROUND_MONTH(PU_FIRST(S2AE_FINAL_V2A_CASES, S2AE_FINAL_V2A.EVENTTIME)) KPI: COUNT_TABLE(S2AE_FINAL_V2A_CASES) Completed: Dimension: ROUND_MONTH(PU_LAST(S2AE_FINAL_V2A_CASES, S2AE_FINAL_V2A.EVENTTIME)) KPI: COUNT_TABLE(S2AE_FINAL_V2A_CASES) Created_and_Completed_Orders.JPG495509 29.1 KB But how can I combine these to charts? I would like to see two columns for each month, with the respective values of created and completed orders. Ideally with the lin

Access the Order Management demo to answer this question. How many cases are covered by the five most common variants. A. 734,890 B. 404,562 C. 988,000

Currently, we are able to create custom extraction within the 'extraction builder' using the GET method. However, we are facing an issue with the expiration of the tokens (Authentication) that we provide for establishing connections. Each token expires after one hour. I wanted to inquire if it is possible to associate an endpoint with the POST method, which would allow us to retrieve a token using the username and password, and then pass it to the specific endpoint before execution. Alternatively, is there a way for us to execute from a Celonis Jupyter Python script to obtain the token and pass it as a parameter for extraction into the Celonis data pool? 

I have installed "CelonisTaskMining.Installer-2.13.0" and it is asking for an activation link. so where will i be finding activation link in celonis.?

I have installed Task mining App now its is asking me to give a activation link , So which link should i provide ?

Hello, I have installed "CelonisTaskMining.Installer-2.13.0" and it is asking for an activation link. Any idea where to get the same?

If we have 2 tables with category1 and category2 as their data respectively  How to get C table with all the fields from category 1 and category 2 ? note : tables are not connected with any case key

Hi Celopeers, I want to make a calculation in an OLAP table, where I divide a COUNT value through a sum of COUNT values. To be specific: I want to divide the SUM 1 which consists of all the cases related to a single operation through the SUM 2, which consists of all the cases related to a single operation that are classified as 'NOT CORRECT'. The Sum of Changes is calculated through a COUNT statement. Thanks for your help!

I want to schedule my Action Flow to first Tuesday of each month. While it shows me option to schedule to a particular date but I don't see anything related to days. Is there a way I can do that?

Hello everyone, due to the nature of implicit joins in Celonis, I wonder if something like this is possible to do in Celonis FrontEnd. Imagine this: Table EKPO with many purchases of different materials, including their quantity and their price.Table EBAN with many purchase requisitions of materials with their quantity but NO price (planned purchases in the future). I already have created an OLAP with all purchases from EKPO aggregated to the material and the total price for that.I now want a similiar OLAP with all planned purchases (purchase requisitions) from EBAN aggregated on material number. But EBAN has no price. So I wanted to do a VLOOKUP like this: We bought material X multiple times with the price of 10$ and that is shown in EKPO.Now we still have 10 purchase requisitions with a total quantity of 100 of material X that are not a purchase order YET. All these purchase requisitions have NO purchase order since it wasnt created yet. But since we bought material X for 10$, I wan

Is is possible to 'capture' the Action Flow Status (active, paused etc.) so we can create a View or Analysis to monitor if different Action Flow are working properly?

I have mistakenly registered as a customer in place of partner, how to fix that

As you can see on the print the cases selected is 211 and the graph is showing 217.

Celonis Support ID: 5d3473fe-679f-42ae-ae24-e61c96f4d126

Hi all, I was testing the JDBC Connector 2.85.0-Snapshot on out testing environment, I have test it both in and outside of Docker, I can get the image up and running, however in the logs I have found one line of main] org.ehcache.sizeof.impl.AgentLoader   : Failed to attach to VM and load the agent: class java.io.IOException: Can not attach to current VM --EOM--Does anyone know how can I solve this? Thanks in advance

How we calculate Automation Rate for PR to PO conversion ?

Hello guys,I have this column MAX(TO_TIMESTAMP(LPAD("gb"."demat_entry_date", 19, '0'),'DD.MM.YYYY HH:MI:SS')) AS "date reception" and i want to reduce the date by 2 hours. Exemple : From 2022-10-22 11:51:28 to 2022-10-22 09:51:28 I have tried a lot of formulas without success...

Hello Developers, I am using a dropdown option to select the KPI to display in the world map. My requirement is when i select 1st KPI 100% should be Red but when i select 2nd KPI 100% should be green. Is it possible to update color pattern in this way, if yes could you share details.

I am trying to upload XLS file (just in KBs) . I get the following error. Could you please help?File validation failed. The following error occurred during upload: A part with the name '/docProps/core.xml' already exists : Packages shall not contain equivalent part names and package implementers shall neither create nor recognize packages with equivalent part names. [M1.12]

Hi Team,I am trying to retrieve the data received from the data connection in a table to machine learning workbench to do some manipulations and write it to another table in datapool.Is it possible?I have tried so far . data_pool = c.data_integration.get_data_pools().find(<pool name>)a=data_pool.get_job(<job id>)b=data_pool.get_table(data_source_id=<sourceid> name=<table name>) But from here i am unable to get the function get_data_frame. Is there any other way?Please let me know.Thank you

Hi Team, would like to know if there is any default integration with the SideTrade (Accounts Receivable) in Celonis?

Is there a use case whereby Celonis was implemented in an Amdocs environment? T-Mobile and Vodafone are both using Amdocs and they are both using Celonis. Was Celonis implemented for Amdocs by these Celonis clients?