Product Q&A

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

How to convert string(format YYYYMMDDHHMMSS) into the timestamp(date) value using either SQL or PQL?

I want to complete the elective course Data Integration Case Study - Accounts Payable inside Get Data into the EMS, but I have some problem at the step Transform - Add an Activity: Enter Invoice in SAP. No problems when I write the code with the INNER JOIN, but I'm not able to run the code whit clause WHERE EXISTS. In attachment you can find both codes. The "WHERE EXISTS" code returns the following error:Execution error: ERROR: Missing FROM-clause entry for table "BKPF". Where I'm wrong? I tried to follow the syntax reported in the Get Data into the EMS course but I'm in a dead end. Thanks in advance.

Hello all, How can I output the data model with a python command in the pycelonis package? in pycelonis 2.0.0this was done with the functionspool = celonis.pools.find('my_datapool')dm = pool.datamodels.find('my_datamodel') In pycelonis 2.0.1 this doesn't seem to work anymore.I get the data pool via:pool = celonis.data_integration.get_data_pool(celonis_pool_id) but how do I get the data models and the tables they contain? Many greetingsChristoph

I have a table like this: "Table1". And I want the records count (Single KPI) between the MIN("Table1"."Posting Date") and TOday-7 and "Table1"."Status"='In Progress'. I tried following PQL query:SUM( CASE WHEN ( DATE_BETWEEN ( ROUND_DAY("Table1"."Posting Date"), ROUND_DAY(MIN("Table1"."Posting Date")), ROUND_DAY(ADD_DAYS(TODAY(), -7)))=1 AND ("Table1"."Status"='In Progress') )THEN 1 ELSE 0 END) Note: Formatting = Rounded Number  But it is giving me following error:The aggregation function MIN cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs. Could anyone please help me out on this?

We have installed extractor in VM and established successful connection between them. We are creating extraction Data Job and trying to load tables but not moving ahead from log "Job not yet started in SAP. Current status: SCHEDULED", so it could be issue in SAP RFC module, unable to understand the issue please suggest.

Hello all, I want to know if is it possible to visualize the output of PyCelonis in EMS. For example, if I have any diagram in Python, I can show it in the EMS environment?Thanks

Hi Team, have built an action flow to push data to data pool. Getting status code error "409" and "runningJob":"34a865e3-f92a-491c-b05b-4e95cdb45420","message":"A job on the same target is already running. Parallel job executions are not allowed"

"Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Telnet connection to the host 3.120.99.40:1433 failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions."

Hi .. ..can anyone help on the Free sourcing (Contract Management) connector and detailed activity list. We also required best practice used to develop a connector.

Good day, Is it possible to save grouped activities and then do calculations on them, such as throughput time between grouped activities? Would REMAP_VALUES be the right statement to group activities in PQL?

How can I enable the Transformations Center in my Sandbox team? Currently I don't the the option in the "More..." drop down menu.

We want to migrate our Views and Analysis from 1 Celonis environment to other. Is there any quick and easy way to do this? Our last option would be to make the data model from scratch.

Hi Team, Objective : We are doing holistic assessement of our current lanscape.We requrie list of all the componests in related sequence:1)Data integration : i)Data Pools ii)Connections iii)Schedules iv)Data jobs v)Extractions vi)Transformations vii)Data models2)Studio : i)Workspace ii)Assets Could you please advise how we can get this in a faster way not doing it manually.Are there any standards scripts which Celonis has to provide this information?  

I am trying to connect my SQL Server to Celonis to extract data from one of the created databases. It's unable to connect with the following error "Test ConnectionThe connection test failed, please check the Data Connection's configuration and ensure that the system is running: Telnet connection to the host ###### failed. Telnet failure indicates that either host/port combination is incorrect or the extractor is not allowed to access the database due to firewall or access permissions."I have enabled telnet, and checked host/port settings,. Also, I tested the connection using DBeaver and it works well there.Has anyone faced a similar kind of situation? Any help would be highly appreciated.

Hi, If a Data Job fails, then an email has to sent to a DL (which contains 10 emails) - Is this possible? I don't see an option for it. All I could see is 'Enable Alerts' in the Data Job Settings, but it will send an email only to me. Any Thoughts?

We have a model with four event logs. If a case has activities in three event logs and no activities in one event log, it appears in the Case Explorer but not in the Process Explorer. What could be the reason for this and how can I fix the problem? Many thanks!  PS: This problem is only in the view, not in the analysis. 

Hi all, I need to filter some instances occurred on sunday and on holiday. Is there a PQL function that can help me out?Something like this:CASE WHEN DAY_OF_THE_WEEK("EVENTTIME") = 'Sunday' or HOLIDAY("EVENTTIME") = 1 THEN "ID" ELSE NULL END Thanks! EDIT: Solved the day of the week part, still missing the holiday one

How to upload data(in csv format) to studio?

I was thinking of reading all the fields of the table and then performing a group by. Is this the right way?

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

I'm doing a date change analysis to understand how many days a sales order delivery date is changed up or out. I have the change from and change to dates. Anyone know of a way to incorporate the day of week? Ex, changed from monday to tuesday?

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 responded they do not have comprehensive document but shared the b

Hi team! we downloaded the procurement starter kit and the P2P S4HANA Connector. There are some KPIs that request the TCURR, TCURF, and TCURX, but there is not any transformation for these tables inside connector Do you know how to add those tables?