- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Product Q&A

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3047 Topics

Most replies

Most views

Newest first

taraka.kandr11Level 1

asked in General Product Q&A

Hi Everyone,I'm trying to create a dropdown in legacy views, it should work as filter if I select value from the dropdown and it should update the variables too.

Hi Everyone, I'm trying to create a dropdown in legacy views, it should work as filter if I select value from the dropdown and it should update the variables too.

6 months ago

mateusz.miaraLevel 5

published in Process Intelligence Graph

Schedule transformations for individual perspectives for object-centric process mining (2024-05-07)

Schedule transformations for individual perspectives for object-centric process mining (2024-05-07) This is a Limited Availability functionality. Instead of running the complete OCPM data job to create objects and events for all your enabled processes, you can now set up schedules to run the transformations for one perspective at a time (or more than one if you want). This feature is currently in Limited Availability - if you'd like to try it out now, open a Service Desk ticket to request it. We're planning to have it in General Availability soon. When you run the OCPM data job through a schedule where you've selected perspectives, we'll identify all the objects and events that are part of those perspectives. Then we’ll run only the transformations that are needed to create those objects and events from your source system data. You can create dedicated schedules for the Celonis-supplied perspectives for the Celonis catalog processes, and also for your custom perspective

6 months ago

raman.silot14Level 4

asked in Process Analysis

record identifier causing issue

Hi team, I am working on creating a profile view, for which the identifier in record is required. As DISTINCT and usage of two tables is restricted while creating an identifier, I am using PU_FIRST and using same table and column in target and source. I am able to make records unique, but I am facing problem when I am adding KPIs for this profile view dimension. It looks like it is showing duplicates. Can someone please let me know why this approach is not right and any alternative solution for the same ?

6 months ago

ugurcan.aydem16Level 1

asked in Data Ingestion & Infrastructure

How to use DateTime_constant (TODAY, MINUTE_NOW, etc.) in the CALC_THROUGHPUT time function?

Hi all, I'm trying to calculate throughput time between and "activity" and "today" timestamps by excluding Sunday. First, I tried it with using DATEDIFF function like that: DATEDIFF (HH, PU_LAST ("cases", "activities"."event_time" ), MINUTE_NOW()) But in this version, I cannot exclude Sunday as you can see. Once I tried to do it with CALC_THROUGHPUT function as below: CALC_THROUGHPUT ( FIRST_OCCURRENCE [ 'Order placed' ] TO CASE_END , REMAP_TIMESTAMPS ( "activities"."event_time" , HOURS, WEEKDAY_CALENDAR ( MONDAY TUESDAY WEDNESDAY THURSDAY FRIDAY SATURDAY ) ) ) Now, I can only calculate the time until last event timestamps, not until now since I cannot use any DateTime_constant (TODAY, MINUTE_NOW, etc.) in this formula . Do you have any suggestions/solutions for such cases? Many thanks in advance for the answers :)

6 months ago

sravan.kumar13Level 1

asked in Data Ingestion & Infrastructure

Access the Order Management demo to answer this question. 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 bel

7 months ago

dudekula.shafiLevel 1

asked in Data Ingestion & Infrastructure

Your business user needs to investigate how the cases are flowing into undesired activities, in other words, see the predecessor activities. Which of these options would you choose to meet their needs?

7 months ago

martin.memelLevel 2

posted in Data Ingestion & Infrastructure

Task mining data configuration failures

Task mining data configuration failures I've recently started learning on the Celonis Academy courses and I'm stuck on the Task Mining sandbox.There is an error in the data configuration, it keeps failing:Uploading paquets from my machine seems to go fine:Yet it is impossible to analyse the recorded and uploaded task mining data, I'm guessing because the data configuration failed?It has been over two hours since my test tasks were recorded and uploaded. Does anyone know what is failing here and how to fix this?

7 months ago

carlos.vintiLevel 2

asked in AI

How can I show the results of an ML component notebook to an Analysis UI?

I have read the documentation on the Run ML Notebook Component but I don't know how to publish the results of the notebook back to the Analysis UI. Is there any link to documentation that shows how to publish the results back on the Analysis? Do I need to use pycelonis or other python library?

7 months ago

enrico.pugli12Level 3

asked in General Product Q&A

Celonis Extractor Server for SQL Server?

Good evening,I have consulted the documentation on OnPremise Celonis Extractor Server (https://docs.celonis.com/en/on-premise-extractors.html), but as far as I can see there is guidance only for SAP and servers with JDBC.I would like to implement Celonis Extractor Server directly on a SQL Server without JDBC endpoints, is this possible?Where can I find a guide or documentation?Thanks

7 months ago

louis.forst12Level 3

asked in General Product Q&A

Hi all, i have an olap table with the dimension of all my activities and as my kpi the count of the activities (done with count table of all activities).

Now i want to have this number for Change Price as a single KPI number, my idea was to use the count table for the kpi and a Component filter with 'FILTER PROCESS EQUALS 'Change Price''. But it shows me a much larger number. Can pls anyone help me. Thanks in advance, king regards Louis

7 months ago

julia.bauerLevel 5

asked in General Product Q&A

AF that sends a mail to suppliers - can supplier response be redirected?

Hello everyone, I have set up an Action Flow that informs our suppliers regularly and also requires an information import back to us from our supplier. The information flow to the supplier is possible via an Action Flow (Sending of a CSV attachment via Mail). My question is there a possibility for the supplier to send the answer back to Celonis (via a Webook, Web GUI) etc.? I know this is a predestined case for Emporix, however, as this is a very urgent topic, I'm wondering if there are any possibilities with the "normal" Action Flows? Thank you so much! Kind regardsJulia Bauer

7 months ago

harini.p26Level 2

asked in General Product Q&A

Hello Team,We have made a connection to S3 for one of the project requirement when we tried to extract the file from S3 (the file is in CSV format)

we are facing some issue the error like below:Extraction failed. java.util.concurrent.ExecutionException: java.lang.NullPointerException.Please let what does the error mean and how to resolve it

7 months ago

bennita.dutoi12Level 4

asked in General Product Q&A

Cycle Time between activities when activity happens manually

Hi, I need to determine the Cycle time of each activity that is not fully automated to determine the impact of not being fully automated. The Cycle time must be from the activity before the specific activity to the activity after the specific activity. How can I do that without specifically referencing the activity - hence 1 PQL that can apply to all non-fully automated activities.

7 months ago

oryna.dvort11Level 1

asked in General Product Q&A

Did anyone create a code to automatically delete/update component content in the analysis using pycelonis ML workbench?

We would like to move to KM usage, but we have a lot of legacy analysis to be linked to KM. Ideally we would like to develop a code that could update reference from local KPI to KM kpi? E.g. from KPI("CT AVG") to KPI("CT_AVG"). I can identify approximate cases where update needs to happen, but I cannot really find if it is possible (and how) to do the update of KPI name in the component itself.

7 months ago

alejandra.galla11Level 2

asked in Process Analysis

How can we see the last column headers in tables using the new Views? They currently appear blocked by the display preferences icon (see attached). It is important that end users can see all cols by default.

@Sophia Stephenson @Brian Dees

7 months ago

benjamin.strem12Level 1

asked in General Product Q&A

We'd like to centrally hide the menu entry "Marketplace" for Business Users . Unfortunately I couldn't find a setting in the section Admin & Serttings -> Permissions for that.

Constantly users try to request access to our app portfolio via the Marketplace. (Maybe they didn't notice the "Apps" section and think specific access needs to be requested in "Marketplace" ...) This will help new business users to focus on the important content and reduce the email notification (spam for admins) about new app requests from users.

7 months ago

patryk.luczaLevel 1

asked in General Product Q&A

Hi, can you tell my why my training version of Celonis have "Object and Events" and "Task Mining", but my production version does not have them?

7 months ago

pruthvin.v11Level 3

asked in General Product Q&A

Can anyone please help me with PQL code to get Plant(WERKS) in MARC for the invoices (BELNR) in the table RBKP , but there is no common field between them so directly cant find so need to use RSEG which has common fields for both the table ,

7 months ago

bushra.taskeLevel 2

asked in General Product Q&A

Can anyone help me with the PQL query to find the Plant (WERKS) for each Invoice using BIND function as Plant is present in EKPO which doesnt have 1:n relationship with RBKP and RSEG is the only common table between EKPO and RBKP ?

7 months ago

jumbo.szkLevel 4

asked in General Product Q&A

Where can I find try celonis japanese demo?

Hi all, I would like to show a celonis demo to Japanese member so I'm looking for it but it dissapperared. (I think there is some japanese demo in try celonis but not right now.) Does anybody know about this and let me know if you can find it.Regards, Tatsuya, Suzuki

7 months ago

anshuman.kherLevel 3

asked in General Product Q&A

I want to write a condition here that if items shipped in a case number on two different shipping ID's are same and item condition is new then flag such a case as 1 else 0.

@sverre.klein11 Hoping you can help on this question.

7 months ago

hamood.farid11Level 2

asked in Data Ingestion & Infrastructure

How to handle ORA-01795: maximum number of expressions in a list is 1000 issue?

I have a table that I am doing an extract of last 1 year. Once the extract is complete, there is 1 column in it (let's say invoice number) that had some activity occurred for it few years back. I am trying to do a second extract of the same table where no date constraint is in effect but using invoice number column values in "Additional Filter" condition.Steps Performed:Extract table data for last 1 year.Create a dummy table to save invoice number column values in it.Create a list parameter to save all those invoice number values in it.Try a second extract of same table without "Enable creation date filter" condition.Use the parameter value in Additional Filter condition (Invoice IN <%=hist_param%>. I am getting an error in the second extract "ORA-01795: maximum number of expressions in a list is 1000".Its an on-prem extractor in use. Any help would be appreciated.

7 months ago

sreenidhi.kalyaLevel 1

asked in Data Ingestion & Infrastructure

Hello, how to set up the connection to sharepoint through action flow? While registering the application what should be the redirect uri? The one which is mentioned in the celonis help documentation is not working.

7 months ago

julia.bauerLevel 5

asked in General Product Q&A

Parameter Input just like in Excel - VIEWS

Hello everyone, the following KPI is implemented within a view: Safety Stock / Sum Demand of the next 12 M (= Coverage Range [Years]) This coverage range is visible within a table in the view. I now want to incorporate the KPI as a filter. I created an attribute on the basis of the KPI: My Celonis users now want to filter the coverage range individually e.g. >0.5 and <0.6 or >1 etc. In Excel this is very easy to do. Does this also somehow work in Celonis?As of right now I can only select the possible values from a list and without some intelligent clustering. Thanks! Best regards,Julia Bauer

7 months ago

erwan.bégocLevel 3

asked in General Product Q&A

How can we clear View selection in 1 click?

Hi All,How can we clear View selection in 1 click? This is fairly straightforward in Analysis, where it is possible to create a button component that will 'Delete selections'. I find no such equivalent in Views. To add some context, we are creating views that integrate several KMs, which we'd like to separate by tabs (tab1 for KM ABC, tab2 for KM XYZ). The problem is that selecting on tab 1 will apply the filtering for the entire view and all KMs. if the table.field (item creation date) i'm am filtering for is present in both KMs, then both KMs will be filtered for that selection, even though the filtering is only relevant for KM ABC. This will lead to misunderstandings. Ideally, i would like to create a view that upon clicking on a tab selection will clear the user selection. Is this doable?

7 months ago

Page 13 / 122

Badge winners

florian.doellhas earned the badge Qualified to Prove Celonis Value
seiya.inouehas earned the badge Qualified to Manage Change and Scale Adoption
mohammed.anas12has earned the badge Qualified to Build Action Flows
joaquin.martihas earned the badge Qualified to Deliver Business Value with Celonis
joaquin.martihas earned the badge Qualified to Manage Implementation Projects