General Product Q&A

I have created an OLAP table with a dropdown button where I can select dimension and I have linked the outcome of the conformance check by using:  READABLE (<%= conformance %>). I put a filter on it so that it doesn't include "Conforms". However, it now lists all deviations and I am only interested in the top 3. How do I limit it to only show the top 3 deviations per result?

Hi, in our celonis_integration PostgreSQL DB, we can see 4 different status (cpm_status) of data jobs: "ERROR", "NEW", "RUNNING", "DONE". I would like to understand what does status "NEW" mean? Can anyone help? Thanks!

I have a column chart component which displays for each status(activity) the number of cases for which this activity is the last per week. So in dimensions I have this kind of expression ROUND_WEEK("ACTIVITIES"."EVENTTIME") but I want to display for each week for each status(activity) the number of cases for which this activity is the last and from a week to another I want to sum the cases which have not moved to another activity. Is there a way to do that, so in dimensions I want to have a kind of calendar of all weeks and then according to the date of the activities I want to display what I explained above. Thanks in advance for your help !  

Hi there, intuitively I would have thought that this checkbox selects values that are NULL but this was not the case when I tested it. So what does it do? Kind regards,Sasa

hi, I would like to calculate number of cases that have some particular throughput time. I want to divide total number of cases for the cases that happened in less than 4 days and for hose that happened in more than 4 days. I tried to use avg but it calculates for all of the cases and put them all in one column. To be clear: there are cases with status "Closed" that have TT<4, but in the table I have 0 there (in column case count where TT<4)

Hello All, Is there any way to get the sum of the Throughput time other than what is there. For example want to group by with some activities, the throughput only available for the avg, median and mean. If we can get the sum of the same. 

Hi Team, I'm trying to build a KPI shows which column data has wrong fields. I'm using the KPI syntax as below but it is not working. Could you please help me on this case.CASE WHEN LEN ("TableA_xlsx_TableA"."Name") > 4 OR ("TableA_xlsx_TableA"."Name") IN_LIKE ('!','@','#','$','^','*','(',')','-','_','+','=','{','}','[',']','|','/',':',';','"','<','>',',','.','?','[%]') THEN 'Name, ' ELSE '' END ||CASE WHEN ("TableA_xlsx_TableA"."Country") IN_LIKE ('!','@','#','$','^','*','(',')','-','_','+','=','{','}','[',']','|','/',':',&#39

How to use OR in numerator and denominator while writing KPI in ratio format

Is there any way to integrate/add checkbox or any indicators into an OLAP table in an analysis ??

I want to get only numeric values from the column. I'm trying with the syntax '%[^0-9]%' but it is not working.

How can we extract execution logs such as transformation script logs from front end.

Hello, I would like to know what happens if you stop the execution of an extraction task. Will the data extracted until that point be removed automatically or you should do something to remove it?

I tried it with != '' or NULL but the result was not as expected. The Result of the example attached should be: Component > Number: 2 CasesComponent > OLAP Table: 1004 / A50 and 1010 / A50  Hope you can help me, many thanks Stefan

The response of the POST call is a ticket that must be added to the header of the other calls as a session id. It seems that the extractor builder doesn't support POST calls. Is there a workout for this as authentication seems only possible by a POST?

Hi Celopeers!I am wondering what is the most convenient way to get the average throughput time between two activities based on their occurrence in a case. lets say C and D are always related to one another but can occur any time in one case: e.g. for the following 3 cases:A-B-B-C-C-C-D-DA-B-C-B-B-D-C-DA-B-C-D What is the best way to get the average TPT between each C and D based on the index in the case?so always...A-B-B-C1-C2-C3-D1-D2A-B-C1-B-B-D1-C2-D2A-B-C1-D1 C1-D1C2-D2C3-D3... I have thought of: LEAD/LAG; ACTIVITY_LEAD/LAG, SOURCE/TARGET, CALC_THROUGHPUT, ... in combination with INDEX_ACTIVITY_TYPE but I have not come up with the perfect solution yet. Thanks a lot! 

Hi Team, I have uploaded a data using parquet file in Celonis . I have extracted the data but coming to data model i want make the case table but in the below i could not see any option with case table 

Hi All, as a beginner in Celonis, I am often confused with the use of Skills and Action Flow, is there any significant difference in functionality, use case or scenario? Thanks in advance!

Hello, I had the PQL Code for Pull-Up-function in progress for many months now. This Function contains two dimensions/columns in the order by statement: PU_LAST(DOMAIN_TABLE("TAB1"."ID"), "TAB1"."STATUS", order by "TAB1"."SORTING","TAB1"."TIMESTAMP") ='Anlage'THEN 'create' A few weeks ago after adding more records to the dataset I got the following error message: Sorry! Something went wrongWe couldn't find any data for this chartPull-Up-function could not be executed PU_LAST:Only one ORDER BY column allowed, but [2] columns were specified After I removed the second Order by statement ("TAB1"."TIMESTAMP") the code works. However, ordering across both columns is still required.Was there an adjustment (function) or could it have something to do with the new data import? br Stefan 

Hey Celonis world. I am trying to follow the Assistant Guided tour, but sometime it jumps and restart. is there some docs where we can do the exercises without following the assistant? Thks in advance

Hi, Would like to know if an action is resolved manually and post that if the new signals come depending upon the logics set? Eg: My Signal ID is A and it is was resolved on the 29th Sep post which there is a new trigger for the same signal ID A so would that come in the Signal Overview list? As I'm unable to see the new triggers for the same signal once resolved manually

Hi,Does Celonis 4.5/4.6 have a dedicated data extractor for GEP MyBuy data? - Thanks.

Hello everybody, I have a problem with our data types in Celonis. In our Oracle database, we have columns such as the sorting implemented with an integer value. However, Celonis shows us a float value for all of these columns, which is why the following error message appears for some functions:  Does anyone know what the reason for this might be and how the data type in Celonis can be changed? Thanks a lotLaura

So is their any way i can change all my tables names not manually one by one in analysis in visualization.

Hi, We are performing some tests with Celonis and our on-premise SAP system (both Sandbox). Since we couldn't install the most recent ECC 6.0 RFC package, due to our enhancement package level (lower than Celonis requests), we decided to install the ECC 5.0 version instead. However, we are not able to activate and execute all RFCs, because some objects are missing in the installation package. For example: table /CELONIS/CLMAN. Are there any complete packages with all objects for ECC 5.0? Or can we just force the import of ECC 6.0 requests into our system? Error:Request:Thank you