Product Q&A

Hi everyone, I have noticed an abundance of posts of people posting academy questions like this below:It's also always the main question, but they never post the statements. I don't want to cause a stir, but is this normal? 😓

Let say i have predefined columns in sheet2 which has employee details ,So i willl send the employee id from sheet 1 to sheet2 and show employee info based on employee id. How can i achieve it. Please help on this. Note : Dynamically passing employee id

I have noticed in various contexts that Data Pool IDs can obviously change without being actively edited. For example, data pools saved some time ago have different IDs than the same current data pools in Celonis. I also noticed that access via a workbench script no longer worked after some time because the connection to the data pool was no longer valid.  And this is exactly what describes the problem of changed data pool IDs. It leads to ML scripts no longer working. Hence my question: When and why do the data pool IDs change? Can this be avoided? I look forward to your explanations. Best regards,Conny

How to find if any specific analysis is using incremental data?

Is theer anybody look my Celonist ticket #00284495, I submmitted @21th, Feb.

The KPI is : COUNT_TABLE("EKPO") and I have added the next component filtersFILTER "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" NOT IN (<%=Blacklist_Activities%>); (this one works) FILTER "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" NOT IN (INDEX_ACTIVITY_TYPE <%=Rework_activity_more_than_1%> > 1); (this one is the one that doesn't work. Error: Missing '('

Hello,  I have setup ActionFlow that is using the Watch Trigger module connected to KM Trigger. I would like to know when will the AF triggered. Is is connected to underlaying data model reload - so it will be trigger every time the DM reloads new data or it can be even more often? Thank you!Jan

I have a requirement to display 3 KPIs as rows and their respective values across each month as columns. In Celonis 4.7, I can define multiple KPIs but can select only one KPI to display. And this KPI is also displayed as vertical. is there an option to display multiple KPIs horizontally ?

Dear community, I need your help with pql. I want to create a table which should display only the LAST document for each case (based on Document creation date). The documents table is directly linked to the casetable. I tried with component filter but syntax error is appearing:FILTER PU_LAST ( CaseTable.CaseID, Documents.Technical_ID [, ORDER BY Documents.CreationDate DESC)  Based on the last entry/document for each case I have additional filterings like "documents.type" = 'A' etc. - but even when deleting the further condtions the querry is not working. Do you have an idea? Thanks in advance!Best Felix

I am trying to use uplink connection to create the connection between celonis platform with MSSQL database, but it's failed, can anyone help? thanks a lot!

Hi,  I'm working on an action flow and want to send a small summary table in the body of the mail I'm sending. I can't find a way to transform the string that stores the csv data into a table format, maybe in HTML or another format supported my outlook.  Thanks for the guidance,Julio :)

Hi All,'In the past couple of days we are facing an issue in the ML workbench, while running a specific python code which is long and also complex , the kernel suddenly becomes unknown from the busy state due to which we have to rerun the code again from the beginning and this goes on happening as a loop ,we have raised a ticket regarding this to celopeers, but would also like to know if someone had faced this issue before.

Hi,There is a employee table with 4 columns. The column values are employee first name, last name, age and location. One employee can have multiple records.The first three columns value does not change for any employee. Only the last field value changes. Eg. if a employee have 4 records, then it means first name, last name, age remains the same and the Location only changes. Please refer the attachment. Now the requirement is, if a employee has 4 records, then instead of showing all the 4 records, i have to show only ONE row , with fields such as First Name, last name , Age and the fourth column 'Location' should be a drop down which should show all the 4 different locations. Is this possible? I am not sure how to integrate a drop down inside a OLAP table. Your help would be greatly appreciated. 

what is the ratio for the process deviation “maverick buying” for the purchasing organization “ides deutschland”

Could anyone provide insights on the best practices for calculating SCI? Are there specific tools, methodologies, or resources we should consider? Any advice on how to improve our software to reduce emissions would be highly appreciated.

Hallo together,I like to select a dataset(date) within an App via dropdown. However the dropdown always sorts ascending. Is there any posibility to have earliest days on top?So like:2024-02-272024-02-262024-02-25...2018-01-01 instead of  2018-01-012018-01-02...2024-02-27  

It seems that the 7 minute window is related with connection session or its equivalent? Are we able to increase this period and if so where is it set? Or is the 7 minute window related with something else? What options do we have?

Hi there! Is it possible to show in views the last data load date? Users would like to see in app when data have been loaded in Celonis. Thank you in advance for your help!

Please help me to understand how would I able to change the font size of the numbers appearing on chart bar?

In Pycelonis , when I had used get_celonis i got permission error , so I need to know how can I tackle these error.

How do clients use Celonis in the Coupa environment?

Hi Celopeers, I need to have a ratio of corrected documents to all documents issued in a given period. I don't want the total number of docs to change. Currently I am doing it in several steps: I select issue date range to get the number of documents, I insert this result into an input box (variable) and then I select correction date range. As you imagine the number of issued documents changes due to selection but thanks to the input box I can still refer to the original value stored in the variable in my ratio calculation. I am wondering if there is another possibility. Could I somehow write the result of issue date selection into a variable to replace my input box? The crucial thing it to keep the original number, so it is not affected by all other filters and selections made. I would be grateful for any tips.

I am currently trying to extract a large amount of data (CDHDR, 50+ GB) I am receiving the following error response:"SAP HANA error: cannot allocate enough memory!. SAP DBTech JDBC" The troubleshooting manual tells me to use the partition dropdown in the extraction UI. Unfortunately, applying some of the columns (e.g. Changenr or the primary keys) gives me another error response that distinct values cannot be found in the selected fields.

Hello team Is there any way to fetch user login history to data pool?  Thanks In Advance  Regards,Ankit Chatterjee