Product Q&A

I assumed one is actual data size and the other is allocated storage space, but that does not seem to be the case as in some cases A>B and in some B>A.

I loaded data into EMS (C4C+) from an Excel file, using the Quickstart for CSV/XLSX. The load works Ok, but when I try to do an Export Data from an Analysis component, I get the error message "Failed! Bad Request. Data Export is not supported". How can I resolve this issue? (The export to Excel is activated in the Analysis Settings). If I try the same steps using a model I created from scratch, the export works fine. Regards,Pablo

Dear community members, is it possible to integrate data processing tool like Alteryx with celonis ? have you ever tried this ?

Anybody has been able to use KM from an Analysis?  I am trying but, although I can use any KPI defined in the KM, I can not use a Record from an Analysis (i.e. in a OLAP table)

After last year the system update, I uploaded a file and then clicked the action button, which kept showing file status failed. I tried to use the file that successfully uploaded and generated the flowchart in studio, but it also showed failure. The failure reason of this case is in the picture below the text. Please see how I should deal with it. Could you please give me a copy of the latest template format file for reference.Many Thanks!

I get this undefined error when I click Create at the Create New Analysis screen in Studio.I've tried it in different packages and with different names. I've tried variations of the data model variable as well. Every time I get this same error. What should I do to resolve this so I can move on to create the analysis?

Connect to SAP BW? We have Celonis EMS connected to our SAP ECC system and there is a request to also connect it to our SAP BW system to bring a table of forecast data which will be joined with the ECC data. Should this be connected as another ECC system (e.g. using a system/instance id) or as a HANA system? We don't need predefined business processes since there are not any, in BW. Just to extract specific tables. When we originally set up the ECC Celonis extractor there were several transports that needed to be imported into the ECC landscape in the \\CELONIS\\ namespace. Trying to understand if these same transports need to be moved to the SAP BW system as well. Thanks, Aaron

Hello everyone, I am writing here because I couldn´t solve my issue with other questions asked. My Situation: I have an OLAP-Table with a lot of Data and dates regarding finances.Now I want to add an Input Variable where User can input a single date.Depending on that input, the OLAP-Table should change (2 columns)The field is OPTIONAL and I am struggling with handling the case of "null" as input. My current idea: FILTER "Table"."SomeDate" >=  CASE WHEN <%=DATE_OPEN_ITEMS%> is not NULL      THEN TO_DATE( <%=DATE_OPEN_ITEMS%>, FORMAT ( '%d-%m-%Y' ) )     ELSE ignore the filter all together     END;  Now if I type in '31-12-2022' it works great! But 1. If the input field is empty there is an errorand 2. the User has to use ' ' while typing it in. Any ideas? Thanks! 

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?