Product Q&A

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.

SIR I HAVE USED ALL THE ATTEMPTS OF RISING STAR ASSESMENT PLEASE GRANT ME ONE ATTEMPT 

I'm getting this PyCelonisPermissionError. Even though I provided all permissions to user key  Please find the attachment,   

I am sharing an attachment for reference .   Thanks, Kandi Ajith Naidu.

I've gotten stuck with the idea that process mining the Incident process must be very beneficial but as there's not that much information to find on the topic, I wonder if there's any caution here. I can find plenty along with the academy examples for various other processes but none for the incident process. I understand that the figures 'saved' could be harder to calculate vs something like duplicated invoices, but am I barking up the wrong tree or is there potential in it?

Hello everyone, I am trying to count distinct number of shipment ids from ShipmentTable and i want to count only the ones occured in 2023. Celonis doesnt allow me to use count distinct in case when function.How can i write it,thanks a lot

If a client has already designed their TO-BE business processes, is it possible to ingest their data into their designed TO-BE processes, in order to confirm/simulate how the processes would perform before being implements?

Hello everyone, I'm trying to set up a new DM as the P2P Data model (with join EKPO and EBAN) only makes requisition numbers visible that were already converted into an order. With a separate DM I only want to see the requisition numbers that are open and not processed yet (with some other filters from other tables). Does anyone of you already set up such a data model? I'm currently getting this error message and I have already all the keys that should provide distinct data rows.  Thanks so much! BR Julia Bauer 

In the Windows under Data Integration where I write SQL Code for Transformations I sometimes have dark mode (white font on black background) and sometimes the other way around. It seems this changed from time to time and from environment to environment.Where can I set this? How is this being influenced? Obviously being a developer I want dark mode all the time 😁

In my project, I'm experiencing an issue with PQL pull-up functions. I am utilizing pull-up functions because Level 2 and Level 3 Columns are generated based on augmented attributes (User Updated in Celonis). If I use those fields directly in the Logics, I get a common table error as we are pulling data from multiple tables.Using PU_FIRST gives me the oldest first record. Using PU_LAST gives me the latest record.I looked over the documentation, but I couldn't find any alternatives.I tried with BIND and DOMAIN Table Functionalities those are also not working. Please let me know if you have any knowledge on the aforementioned question Thanks in Advnace.

Payer: Combined Number and Name Logic- One Payer Name can have several Payer Numbers, so Table A always shows a list of Payer Numbers/Name Combinations. Table B should show only the SUM of the Costs of the Payer name. The Customer would like to have in Table A Number and Name combined in one column, Table B should always show the SUm of the above selection.  Table A: Variable: Payer Number/Name Combined Column A, Costs Colmun BTable B: Payer Name Column A, SUM Costs Column B I think the solution could be working with variables: I added two variables: Drilldown_dimensions and drilldown_text so if I select a payer both tables respond.  In Data Transformations I combined three different payer colmuns and also three different payer number colmuns to one column. So it is not possible to select only the payer_name for the selection.

Hi group! I am working on an action flow that will send a table with some information, the action flow is looking good, but it is sending separated emails, I need the full information in one table, being sent one time. The source is pointing to the query data, so not sure why is doing that..

Good afternoon, Just wondering if there was a way where I could use the variables we've set up in the Knowledge Model, inside the dashboards, for page filters, etc. Thank you!

I have 5 sheets in Analysis.When I select the dropdown value from sheet1 the data is getting filtered in all the 5 sheets.Instead of that how to apply the dropdown filter applicable to only the sheet1