General Product Q&A

In Detail I want to know how I could get the times of my (20) activities (P2P-Process from Celonis). Specially the time between the activities without working in an activity and the time which is needed only for the progress itself.

Hello everyone,  i would like to build Line Chart from this following data structure:   I would like to set up the line chart with different lines with dates on the x axis and each line presents an group of column A, where Column B are the y-values for the corresponding x value.  I tried "CASE WHEN column A = 'AA' THEN Columb B END" as KPI and date as dimension but it doesnt work since the NULL values for BB and CC in Column A are still presented in the line chart. Also a component filter did not work with it.  Thank you for every help. Best regards, Jurgen

hello to everyone, is there an example how action flows interact with rpa ?

Hi, can someone help me with a filter script. I need to show a KPI with a date filter for today at 5:00 am. The client wants to see a snapshot every day of the cases open at 5:00 in the morning. Thank you, Denise

CASE WHEN "AE_SIGNALS"."AE_SKILL_NAME" LIKE ('%Veredelung%') THEN COUNT ( "AE_SIGNALS"."SIGNAL_ID" ) * 30 / 60 ELSE NULL ENDI get the following error:The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.

I wanted to create a KPI with reference to Variable <%= Discount %> (Users could define their Discount value). For example KPI as Actual Sales: (KPI (Sales)- KPI(Sales)* <%= Discount %>)).I'm able to create it in Analysis by defining Variable and adding the VARIABLE INPUT (Users may add their discounted values) Component however not in Views.

Slider Bar component like below:

Is it possible to create a Gantt chart like the image?If so please tell me how. Thanks!

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

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!

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

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

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  

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 guys, any idea why a particular task does not appear even if there are data that satisfy the filter for the skill?

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.

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 t