Product Q&A

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.

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?