Product Q&A

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

Hi Celopeers,In My Activity table , 1 case has 10 Activities. I am creating a report in which I need only 6 out of this 10 Activities. So, I introduced a Compound Filter and restricted the not-required 4 activities. Now, I was asked to find out the time taken between activities. I used the PQL query 'DATEDIFF (hh, ACTIVITY_LAG ( "_CEL_CS_ACTIVITIES"."EVENTTIME", 1),"_CEL_CS_ACTIVITIES"."EVENTTIME" ) - It has two issues. Due to Compound filter, the 4 activities are not showing up (which is the requirement), but the above PQL calculates the DateDiff for the 10 all Activities. So,When the 6 Activities showing up in the report, the DateDiff does not makes sense, that's because datediff is calcalated for all the 10 activity at the background. Any thoughts on how can I fix it? 2.Activity A happens at Jan 10th 8 O'clock.Activity B happens at Jan 11th 10 O'clock.DateDiff of Hour function gives only the value as 2. But logically it should

How can we create second Process Explorer in my Analysis?

Are there any experience reports from the connection of the Data Warehouse to Celonis?I want to connect the data warehouse and still have some questions about the concept. Have you created an intermediate database and duplicated the required tables? Or did you let Celonis access the entire data warehouse directly? I would be pleased if suggestions were made here, taking data security into account. 

I have process sequence:  BCADBCBA..... I would like to calculate the throughput time between the first instance of activity "A" and the immediate next instance of activity "B"

Hi Team, What will be best solution to resolve below error to load data model. "The load failed: Could not load data model. Disk quota exceeded"

Hello,I need to display in an Olap Table only the “Codes” appearing twice or more (same code for different Building) : the user doesn’t want single “Code” but I am facing difficulties as I can’t put a count in my Case When statement. Do you know any way to do this ? Thank you for your time !Best regards,François  

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. ?

How do you convert date column from string to datetime at the extraction stage? I tried configuring the column but keep receiving an error.

Hi Folks! Does anyone knows what this message means in Celonis Starter kit 'NaNM'? We have this value for those KPIs regarding currency conversions.

Hi all, Every job I try to run, which every table, i receive the INFO: Job not yet started in SAP. Current status: SCHEDULED. How to solve this? I just downloaded the template AP from Marketplace, configured the connection and I am trying to test an extraction. Every time I try to run the extraction, this error occurs. I didn't schedule anything

Hi guys, any idea why a particular task does not appear even if there are data that satisfy the filter for the skill?

File already exist in the folder with data but the fie is not loading in the celonis action flow module, attached the error screenshot

Design Pattern : Using action Flows to write data into the data pool. Hi Team,As per the process mining concepts we need to use action flows for taking actionable insights outside the celonis EMS.This would essentially mean writing back to ERP's or sending emails and so on...In some of my discussions i have seen that there are suggestions to use Action flow for writing back into celonis EMS.Like writing the data back from action flow into the data pool and then again refreshing data model to use that data. As a recommended strategy should action flows write back into the Data pool?

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.