General Product Q&A

I'm using a CASE WHEN statement to filter out dimensions based on dynamic criteria. For example, take the following case when statement: CASE WHEN"Activities"."ACTIVITY_EN" in ('Closed','Open')THEN'Closed'END I would expect that there will only be rows for 'Closed' and 'Open', however, I am also seeing a row with the dimension of '-' . There is no way to filter this out and leads to misleading dimensions.

I have crated a basic analysis for my team with only 1 sheet as case explorer. In the case explorer i want to hide few columns and publish the analysis. I don't want to show few columns to the team. Is there any functionality to hide columns in case explorer and publish? Regards,Ashok

Hello all, in the event-collection I create a new table, wherein I join two tables based on the following rule:JOINWHERE "Alarm"."Starttime" > "Transport"."Starttime" AND "Alarm"."Starttime" < "Transport"."Endtime" This works. Now I would like to extend this timeframe by 5 Minutes. And neither the function:add_minutes("Transport"."Endtime", 5) is supported nor the function REMAP_TIMESTAMPS("Alarm"."Starttime") < (REMAP_TIMESTAMPS("Transport"."Endtime") + 5) How can I change/remap a timestamp in the event collection?

Hi, I want to add a column to an OLAP table that shows whether all orders from a given supplier exceed the value of 100 or not. So the final table should show a supplier name, the number of orders, the net worth of orders and either: The net worth value sum if its above 100, else 0An 'x' when the sum of orders exceeds 100 Also, it would be great to see how many single orders exceeded the value of 100. I was trying around for a while with PULL functions and CASE WHEN but I can't seem to make it work with the restriction of '> 100'. For example the query below gives me an error message stating that CASE is not compatible with FLOAT and INT. SUM(CASE WHEN "EKPO"."NETWR_CONVERTED" > 100THEN "EKPO"."NETWR_CONVERTED"ELSE 0END) Thank you very much in advance. Best regardsAram

Hi, When i show the same formula (standard throughput time calculation) in an OLAP table vs a number they fail to show the same outcome. Whereas they should. In the olap table I have applied the formula in combination with a priority dimension. WIth the number I have applied a specific priority as filter. Hence, both the throughput time should be equal. However, they are not.  Any idea what could go wrong?

I need to change it from %b-%Y to Q%q on the basis of time scale selected by user

Hi All, I have more number of SQLs as part of one transformation in celonis. I would like to include a info to be printed on the transformation log after it completes a particular statement for debugging/tracking purpose(same like SQL's print command).  Could you please help me with option for the same? Thanks in Advance. :)

I need to import data and create data model from the demo data that was extracted from the eventlog file as shown in one of Celoinis training video. Where i can get that eventlog file? I'm unable to connect any live system to get data feed so trying to use demo data instead but unable to find any event log data to import to create data model. The one training guide uses 'p2p_Demo_Eventlog.xlsx' file to upload data. I'm unable to locate this file. Can someone have this file or any other event log file that i can use to import data in my environment.  

The logic is as follows:if a category repeats (like C1), then:for each category, calculate the date difference (DATEDIFF) between "closed at" date of a row with "closed" status and the "opened at" date of the rows with an "open" status. The objective is to have an extra column to the right, with these values:Difference (in days)18 (DATEDIFF(dd,17.09.2021,30.08.2021)16 (DATEDIFF(dd,15.09.2021,30.08.2021)N/A (because its status is closed)N/A (because the category doesn't repeat)N/A (because the category doesn't repeat) Suggestions?

Good morning, My client has 4.6.1 on-prem Celonis license. I was asked to overwrite the old data model with a new one. I'd like to make sure it is possible to recreate it in the future. Do you know if it is possible to create automated documentation of the data model? Thank you in advance,Piotr

Hi, How can I customize the he Throughput-Time-Search element in Celonis 4.5? - In the attached picture (TPT) the intervals for each bar is consistently 14 hrs. Can I change this to e.g. 50 hrs per bar? - Thanks.

I'm trying to use Celonis provided pre-configured demo application in TryCelonis. During the creation of data pool, it asked to create Data connection. From the list of available connections there is one connection named as 'SAP Demo'. Is this build in connector to connect with demo data related to SAP? When i tired to use this connection, it pre populated connection details like Host, client, systemNumber and user id. In order to complete connection, it need password and i'm not able to find it anywhere in any documentation. I'm not sure it is correct approach and i'm making correction assumption about 'SAP Demo' data connection.I'm trying to setup an environment from demo data without creating actual connector with SAP. Is this possible? if I do not specify data connection, then i'm unable to get 'Data model' object from PyCelonis for the analysis that is using that data model. Any help shall be greatly appreciated.

As soon as our CSV file for the activity table exceeds the filesize of 4GB Celonis is throwing an error and I suppose this is due to the filesize.I cannot reduce the dataset any more so I hope there might be a way to upload 2 seperate files and join them together within Celonis. Unfortunately I can't find such a function anywhere. Or maybe there is another way to bring big activity tables to Celonis without a database connection? Would that work in IBC? I work On-Prem 4.6.0-RELEASE_2babc1e_20200831_0915

I have a table in the 'Filter_Option' attachment that is filtered based on a client and it shows different values with relation to no.of cases and amounts based on different periods in days.  I have a further drilldown option when you click the orange button which directs you to the `Drill_Down` attachment But, even though the client filter is global it only applies to half of the table. I observed this when I added up the red circles which is reflected in the drill_down attachment

The screenshot with the red circles is filtered on Avg throughput time and the screenshot with blue circle is filtered on median throughput time. If you some up the values in the explorer (Example: Red circle image:- 4 + 20 + 13 = 37) it is not equal to the median red circled day of 66.5 . Th difference also exists when I filter on median throughput time. Any suggestions?

We need to connect Celonis to SAP CCS, but we don't know if the SAP ECC Connector can be use.

Execution error: ERROR: Join [("27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".USR02 x "27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".CDHDR) using USR02_v1_b0 and previous join (PATH ID: 7)] inner partition did not fit in memory; value [100,BATCH]

How to connect HANA database to celonis IBC? What are the requirements or inputs required?

Please see the attached video to grasp the issue.

How does rest API works to connect with Celonis

For example: column_a"one""two""three" Then: STRING_AGG("column_a", ',') => "one,two,three" STRING_AGG is not available as an error message tells me. How can I perform this action then? (I am working on a Transformation in a Data Job.)(CONCAT() concatenates across columns, but I want to concatenate across rows.)

I am using Celonis Task Mining and I was trying to create a process/variant explorer tab to show task mining activities as a process map. Here I had used column "ActiveWindow" from TM_Activities table. I was trying to get a more informative name for the task mining activities to make it more presentable and easily readable.Below are the things I tried and how they did no work:Updated the values from the active window name in the table, but they were not reflected in the process/variant explorer even after a refresh or reload, or starting a new analysisAdded a column to enter activity names manually, column was added in the table, but the same did not reflect when I tried to select different column dimensions in the process/variant explorer.I tried to use annotated activity column (comments) from user_interaction_event_log table. Even after selecting it as activity table, the process explorer would give error as not selected as activity table or the map created would be of rho

Hello everyone and thanks in advance for the help. I have a little problem calculating the throughput time. I can calculate it according to the timestamps without problem but I need to calculate it removing the weekends, that is to say counting only from Monday to Friday, the working days. Is there any way to do this?

How do I calculate the working days between two activities with a work calendar from a non SAP system? Hello community, I am having difficulties calculating the number of working days between two activities. As I do not have SAP connected to Celonis, I want to connect a work calendar using another table. I have added an additional table with the following structure. It is linked to the time stamp of the cases. Now I want to sum up the flags of all days between the two activities. However, I only get the timestamps of the activities from the added table (This means I always get two as a result).  I have assumed that this could be due to the link via the timestamps of the two tables. Does anyone have an idea how I could solve this problem or how I can do the calculation in PQL? Basically, I would be interested to know if it is at all possible to integrate a work calendar with a non SAP system? Unfortunately Celonis only suggests a TFACS table? Which table structure would be advisable? Ma

I have attached 2 screenshots of the same variant explorer, but filtered with case frequency and activity frequency. I wanted to know why the numbers on the process map do not change when these filters are switched