Product Q&A

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

I am trying to do dynamic filtering using a variable. I have another variable which checks for date. When I try to use, it gives my date error as it doesn't recognize the variable as treats that as string.

Dear Celo Comunity, one of our customers is looking to improve it´s credit management - carrying out credit checks and credit rankings of its customers/ making credit decisions and extablishing credit limits. Any tipps on how can we do that with Celonis?

Filter on the most common variant #3 and #4. Make sure the two variants are superimposed on top of each other. Looking at the Process Start and Process End dotted lines, which of the below statements are accurate? Select TWO options.

answer

Hello Community, We have problems with the action flow when it is triggered automatically after loading a data model. The action flow is triggered several times (if the filters of the triggers are fulfilled) at the same time (see screenshot).  In the Action Flow we send an email to a specific recipient. In the action flow, we use an MS 365 connection. Due to this "parallel" triggering, the connection reaches a limit and issues the error "[429] Application is over its MailboxConcurrency limit.".  Microsoft has set the limit for concurrent requests to 4. Have you had a similar problem? Have you solved the problem? Thank you very much!Pablo

Hi Community I have the following PQL Query as an KPI: AVG (  CASE    WHEN      MATCH_ACTIVITIES ( NODE [ 'Proposal Submitted' ] ) = 1    THEN        CALC_THROUGHPUT (          First_OCCURRENCE [ 'Proposal Stage' ]          TO          Last_OCCURRENCE [ 'Proposal Submitted' ] ,          REMAP_TIMESTAMPS ( "ACTIVITIES_TABLE_HUBSPOT"."EVENT_TIME" , DAYS )        )           ELSE      'No Proposal was Submitted'      END) I would like to have the string value 'No Proposal was Submitted' for the business in thr ELSE statement. I know I can simply replace it with the INT value 0, but I don't want that.  Any help is appreciated 😊  The error reads: Operator requirements are not met. CASE WHEN expression is not compatible with an ELSE case of data type STRING when at least one THEN case is of data type INT Kind regards,Sverre Klein  

We are currently migrating to Celonis EMS, however we are experiencing an issue with the Impala connector. Celonis creates queries such as  Select * from "schema"."table" where Impala interprets " as string delimiter. Other tools that are talking to our Impala database, including Celonis on-premise, do not have this issue. Does anyone know how to configure the Celonis Impala data connection to change this? Many thanks in advance! Joos Buijs - APG

Let’s look at the code JOIN MERGEJOIN (inputs presorted) [Cost: 750, Rows: 1200] (PATH ID: 1). What does the number 750 represent?

Dynamic loading to respective table

I would like to know if it's possible to fix a view component in the top section of a dashboard, so it doesn't move vertically when scrolling.

I am having a really hard time.. a client asked me to update the augmented attribute for the unbilled status from 'In Progress' to 'New'. I created a bulk option, selected all that applied (only realized in app orders) and updated the statuses, but now he is asking me to revert back, I am not sure how I can only selected the orders that I changed. I was trying to create an AF to revert it, but is updating everything. I was thinking on filtering by change date, but is not appearing the date I make the changes... I want to filter byt the action 'Augmented Attribute 'Status' value changed from 'In Progress' to 'New', but I am not sure where is the record. Can anyone give me an idea? I am really frustered right now..

Hi everyone! I am facing a really tough situation. My client asked me to update an augmented attribute that was making the dash to not work well. The update was basically to revert the 'In Progress' statuses to 'New', the problem is that the client realized that this was not a good practice, so he asked me to revert that back, the problem is I am not finding the records for the updates for some of the orders, the activity was registered, but did not track all of them, now I do not know where this information is stored, I already checked the augmented status table, activities table, nothing there, I talked with support and they told me that when we update the status to a default value, the activity is not recorded, they suggested me to update about 2 million orders manually, if there´s any insights on this, It will be much appreciated.