Product Q&A

I have one Main button dropdown to select dimensions(dimension 1 and dimension 2). There are two other different button dropdowns (First and Secondary Category) to retrieve values from the main Dimension for benchmarking purpose. When I select dimension 1 as main dimension and even before selecting the First Category, the process explorer and the other Single KPIs displays empty. Is there any way to populate default values even before selecting the dimensions. Please see attached for more information.

Hi, in an action flow I try to make a connection with our UiPath RPA Orchestrator to start a job there. Because we use the on-premise version on UiPath I have to setup the connection like below. I filled in all details and I requested our IT team to whitelist all Celonis IP addresses on this webserver, but still it is not working.   Does anybody has experience with this connection or maybe has an idea what is going wrong?  Many thanks in advance!Albert-Jan

Detail:in our data model, the event time must with format YYYY-MM-DD HH:MI:SS. But my data source is DD-MM-YYYY HH:MI:SS. so this data is not available as event time. I tried to follow : https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Functions/Formatting/TemplatePatternsForDateTimeFormatting.htm use query : TO_TIMESTAMP(Date_column, 'YYYY-MM-DD HH:MI:SS'); (attachment 5) but the date format is not correct as below: 0028-01-20 00:00:00 (Attachment 3) The original date is 28-01-2022 13:51:24 (as attachment 4) 

Hello all,  I keep getting a 403 error when trying to access my knowledge models via the Intelligence API. The App Key is marked as used within Celonis & authorization works.  I have set the required permissions for the App Key. I am trying to access an app that is currently hosted in our sandbox - is that the issue?  Any help would be highly appreaciated.  Best Johannes

Good day, can someone help me with a component filter if I want to filter on a case count for a certain time for yesterday, for example what is the total cases yesterday at 15:30. Thank you

We are trying to build profile views for KPI's. Can we use a KPI as a record so that we can create an attribute and create a profile view?Is it possible to use multiple KPI's in a single component in a profile view?

Is it feasible to create variables in Skills to archive the selections' hierarchy? or Does using augmented attributes make it possible to accomplish the same thing? Please help me with this. Appreciated and thank you

how can we write a Pql Statement to count the total cases which passing through the Activity

Good afternoon, among the best practices suggested by Celonis, there are: Scheduling Full Loads if delta loads are not possible or if source tables' metadata are changed frequently (i.e., a column is added or deleted).Extracting only the relevant columns of the source tables (i..e, those actually used in the transformations). If the relevant columns can't be deleted or changed in the source systems (because, for instance, they are crucial for the business and it would be a disaster to change them for the data recovery!), why should I schedule full extractions to consider metadata changes? Shouldn't I launch them only manually when columns need to be added to the extracted tables? Moreover, if the answer is in the documentation, could you share the link? Thanks and regards,Simone

Hi all,  I would like to execute a skill with two variables. Is it possible to set the value of one variable with a kpi from the knowledge model? Thanks and kind regards,Sarina

We would like to connect to SAP Succes Factor but we don't realy know anything about this system. Is there anyone who has some previous experience about this system? Is this an oracle or some kind of other Database? How to connect to it with Celonis?

I know that you can convert dashboards to PDF using Action Flow.Is there any other way to link the PDFs, such as storing them in a designated folder, without having to link them via email?Our company uses MS365, and since it cannot be linked with external applications, we are considering alternatives.Please give me some advice.Thank you.

A client is interested in process mining for PeopleSoft and Accounts Receivable. Is this feasible in Celonis? Any major barriers that I need to be aware of? Thanks for any guidance.

Hi, maybe someone can help me with my issue. I would like to calculate the standard working time for operation steps based on routing information.This is working so far. PQL is fine: SUM(("AFRU"."GMNGA")*"AFVV"."VGW03"/"PLPO"."BMSCH") Problem now is, that not all plants are using the same standard unit of measurement. ( Days, Hours or Minutes) By checking this unit and changing it to a standard unit (min.) I get following error message. SUM(("AFRU"."GMNGA")*"AFVV"."VGW03"/"PLPO"."BMSCH")/case when "AFVV"."VGE01" = 'MIN'Then 1ELSECase when "AFVV"."VGE01" = 'S'THEN 60ELSECASE WHEN "AFVV"."VGE01" = 'Day'THEN 1*60*60ELSE 0ENDENDEND  How can I solve this issue?

I am currently pursuing a master's degree in software engineering, following my MBA graduation, and I am in the process of selecting a topic for my master's thesis. I am very passionate about the field of software engineering and process management, and I would greatly appreciate your insights and recommendations for a compelling thesis subject in this area.My academic background in business administration and my current focus on software engineering make me particularly interested in topics that bridge these two domains. I am eager to explore subjects that could potentially improve software development processes, enhance project management, or optimize the overall efficiency of software development teams.If you have any suggestions or if you are aware of emerging trends or critical challenges in software engineering and process management, please feel free to share your thoughts. Your guidance and expertise would be invaluable in helping me narrow down my focus and embark on a

Hi Community, Can any one tell me about value realisation? does celonis offers any course on value realisation? If yes, what are the courses I need to undergo to understand value realisation ?

Hi Community, How can we back up all the work done in Celonis (Analysis/view/knowledge model/Data model/transformation)? and how do we view all the analysis once the license gets expired?

i want change the dimension of olap table using dropdown in views, How to display name like display name in dropdown in views

The overview is currently in a simple analysis table but we can migrate it to views. The user should be able to jump directly into the case in the SAP ERP by clicking the case in the view. Has anyone done something like this or could you point me at how to tackle this use case? Thanks! 

Can Pull-up functions also be used in the context of transformations on Data integration side or is the usage only possible in Celonis Studio components etc.?

Hi All, I am trying to take my activity table and break it out into different subactivtiies groupings. Basically trying to create a counter calculation by case whenever the activity is 'Start' and have it copy all the way down until the next 'Start' activity or using a sort of lead object to distinguish the beginning of a sub activity. Example:Case Activitiy Counter1 Start 11 Activity 11 Activity 1 1 Activity 11 Start 21 Activity 22 Start 12 Activity 1 I have tried to do this with a variety of formulas, but have been unable to recreate this. I can do this in the backend transformation, but would prefer to see if it can be done within a calc from the front end. Please advise whenever you get a chance. Thanks for reading! 

Hi Team,I am trying to create a table in a specific data job before which i have done some calculations using pandas and i want to perform SQL using that table in the datajob.But the tutorial gives the datapool create tables and i am not able to access it in Datajob i need.Is there any way to do this?When i force the data_source_id while creating the table in data pool, it gives an error saying it cannot find that table and source id.Please let me know if there is a way.Thank you

I am trying to screen the cases where we set order block and immediately release without any activities in the middle. The idea is to calcuate how much time we wasted on those cases. To do that: In the activities table, I want to partition along column "Change_to" in such a way: When "Change_from" = 'ZA' (which incdicates release of block)Then look at the immediate preceding rows: if the column "Change_to" = 'ZA' (indicate set block)  Then calculate the datediff between those rows. This is my code: SUM( CASE WHEN ("_CEL_O2C_ACTIVITIES"."CHANGED_FROM" = 'ZA' AND ACTIVITY_LAG ("_CEL_O2C_ACTIVITIES"."CHANGED_TO", 1) = 'ZA')  THEN  DATEDIFF ( MI, ACTIVITY_LAG("_CEL_O2C_ACTIVITIES"."EVENTTIME"),"_CEL_O2C_ACTIVITIES"."EVENTTIME")END) It seems that the above code just ignore the bolded part in the casewhen statement. It calculates the datediff even when

I wonder if we can interact with OCPM elements from ML workbench. I couldn't find anything in pucelonis doc. TIA!