Product Q&A

I want to get the days in this current month like if the month is june i want all the dates in june . How can I get that??

Is there a way we can highlight top 3 defaulters by company code based on the volume. So far i have seen the option which says background color if the value is less than, greater than , equal to etc etc. Any help here will be much apprecaited.

I am not sure to ask this query here, I am planning for certification exam, shall we get mock test papers/dumps for practice. Please let me know, if anyone have. Please don't mind if it is not relevant one to ask. Thanks

Hi, In the Set Variable module in my Action Flow, the 'If' expression below evaluates to 'A' whereas it should evaluate to 'B'. Where am I going wrong? if(1=2; A; B)  Thanks !Bhasker

What is the difference between Skills and Action flow? Can we perform any action in action flow based on the signals we receive from Analysis?

Hi Team, Could you please let me know how we can get the list of Whitelisted Violations that have been done in Conformance? Just like we have a function READABLE ( conformance_query ) where we can get the text of Violation, similarly we are looking for some function so that we can identify which one of them are whitelisted and which one is not.

The current way of developing transformations in Celonis for event logs is to do this per case key. The event log for PO headers has transformations with the po_header_id as case key. The event log for requisitions has it’s own transformations with the requisition header id as case_key and the event log for AP invoices has it’s own transformations with the invoice id as case key. All these three event logs share multiple activities. We would like to make this more flexible and easier to maintain. The main purpose is to have the complex joins only at a single place and to have the definition of the activities also at a single place to avoid having to maintain the different SQL statements in the transformations. The way we are thinking to set it up is to create 1 single activities table and this contains the usual columns like activity name, eventtime and user name, but not the case key any longer. Instead it has multiple columns for the different object id’s that will be populated depen

Right now I did it like this:  PU_LAST(DOMAIN_TABLE("ADR6"."SMTP_ADDR"), "ADR6"."SMTP_ADDR") The problem is for example when I've an old E-mail adress like "oldemail@hotmail.com" than after this E-mail changes to "newemail@hotmail.com" it still only shows the old E-mail in the Celonis.  Are there any ideas why? Thank you very much!

We would like to have a separate user group/role in EMS to just grant access to dashboards in EMS. Currently, admin access has full access but we would like to restrict service desk team to only grant access to dashboards and not do any development.

Configured the action flow to send an email where it would summarise at the top the total amounts and below it will be the details in a table format. The table format displays everything correctly, however the sum at the top omits when the table has duplicate values and so is incorrect.

Hi All, I'd like to add a button to my sheet that allows the user to automatically filter for the last 7 days, and a separate button that allows the user to filter for the last full week. Bookmark selection doesn't seem to work, since the bookmarks are static. Thanks!

Hi all, I want to add a button where the user clicks and it filters the cases based on the following conditions. What's the best way of doing it?  FILTER PROCESS EQUALS 'IC SB Purchase Order Created';FILTER PROCESS EQUALS 'IC SB Billing Created';FILTER PROCESS EQUALS 'IC SB Invoice Receipt';FILTER DAYS_BETWEEN(    PU_LAST(      "EKPO",       Round_Day("ACTIVITIES"."DATE1"),       "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Billing Created'    ),     PU_FIRST(      "EKPO",       Round_Day("ACTIVITIES"."EVENTTIME"),       "ACTIVITIES"."ACTIVITY_EN" = 'IC SB Invoice Receipt'    )  ) > 30; Thank you.Guilherme Luz

Can anyone please give me the explanation about their difference with respect to a business point of view. Like if a client asks why you are showing me case frequency and activity frequency for change price. That what should we say?

Hello,We have lack of knowladge . We would like to load a process flow like this.Lets assume we have process Flow like that A-> B-> B->C-B->B-> D->B->B->EWhen we do conformance I would like to use A->ANY To ANY -> C Any to Any ->D Any to Any->EI mean Any activity between A->C could be exits. We tried this solution but unfortunately, it didn't work as expected. All of our cases detact as violation. We implement BPMN as below. What we did worng ? Best Regards,Vahide.

Pls see the line 2 & 3 of the screenshot.

When to build an extractor from scratch and when to use uplink connections differentiate?

How to check any dimension (like Vendor etc) wise Violation Rate?

Hi, I am Manohar and I would like to change email address associated with the account as my earlier email was blocked when I resigned from the organization. Can someone guide me how to change email address and how to login with fresh email address? Thanks,Manohar

Hi, we want to showa histogram which shows days a particular case takes to get resovled(Days Spent), instead of the actual start and end timestamps. So in this sample data set assume we have sveral cases of each type between the start and end timestamps, which would show up as counts in the histogram. How to achieve this. Histogram Query938656 96.3 KB

Hi All,I have basic question on PQL. How can I explore PQL for process mining? Do we have any start up guide? Should I need to have full license version to explore PQL ? ThanksDurai

I have the six intermediate certifications that were obtained in the previous training program: Celonis App CreatorCelonis Business Value ArchitectCelonis FoundationsCelonis Implementation ProfessionalCelonis Sales ProfessionalCelonis Solution Professional But these certifications have not been migrated to the new program, is this correct and do I need to do anything?

Hi all, I have a basic question regarding activity table column configuration. We have the luxury of having start AND end datetimes for each activity. I remember this was possible at some point to specify the date columns as such with the effect that for each activity the duration was calculated and shown in the process explorer (performance view).  Is this still possible, and if so, how? Thank you!

Hi celopeers, I am trying to build out a trend chart that plots the open invoice aging over time. In terms of dimensions I have the following: x axis - ROUND_MONTH(INVOICE CREATION DATE)y axis - AVG(TODAY - CREATION DATE) for open invoices only The issue I'm running into is that since KPI is tied to creation date and today's date produces a strictly negatively sloped trend as shown below, which makes sense in practice (beacuse both axes are tied to creation date), but not exactly what I'm looking for.  What I need to show is the change in trend by month, but that will require detaching the KPI calculation from the creation date, sort of like a snapshot of the KPI at the end of each month, kind of like transformation center did it before. Has anyone successfully accomplished that before? If so - how did you do that? Thanks!Eugene

I am a beginner and want to get certified as Ceolins , can any one please guide me where to start from scratch and where would i find study material

AWS connection from s3 to celonis. Where exactly is the window to enter the key and secret to achieve the connection (the documentation is a bit lacking)