- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

1,424 Topics
3,371 Replies

When you subscribe we will email you when there is a new topic in this category

1424 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.

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

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

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

neda.petro11Level 2

asked in General Product Q&A

Writing PQL query

Hello Dear Community, I'm trying to write PQL query that will return Material Numbers which are ordered on both active Scheduling Agreements and open Purchasing Orders in SAP. Do you have any suggestions which PQL functions will be suitable for that? I've attached example with the input/expected output. Thank you!

7 months ago

shane.proctLevel 3

asked in General Product Q&A

Action Flow API Key: When trying to give a new API key permissions, the key does not show up in the Permissions/services area. What am I missing

I've tried to follow the directions from Celo Docs, but the 'User Provisioning' area shown in the directions doesn't exist for me. I've looked in the other services areas, and my API key doesn't show.

7 months ago

bennita.dutoi12Level 4

asked in General Product Q&A

Hi CelopeersIs it possible with PQL to create a KPI that will give you the name of the activity with the lowest / highest automation rate?

Hi Celopeers Is it possible with PQL to create a KPI that will give you the name of the activity with the lowest / highest automation rate?

7 months ago

.1683757Level 3

asked in General Product Q&A

Is it possible to extend the height of view in the new experience?

I'm want to create a dashboard and I'm trying to add the needed components, but the available height is not enough! Is the option of adding components and allowing scrolling not available anymore?

7 months ago

anup.sahniLevel 1

asked in General Product Q&A

What is the difference between the median throughput time of the first and second most common variants in days rounded to the nearest integer?select one:A. 17B. 12C. 5

What is the difference between the median throughput time of the first and second most common variants in days rounded to the nearest integer? select one: A. 17 B. 12 C. 5

7 months ago

julia.bauerLevel 5

asked in General Product Q&A

Button Dropdown - migration from Analysis to a View

Hello everyone,I have the following button dropdown set up in an analysis: In each dropdown selection the following coding is saved:I have already prepared the KM for the view like this - custom attribute:I now added the custom attribute to the dropdown list but the data is not filtered accordingly. To solve this, I think I need to add some variables to the KM which I already did like this:Yet, the variables are not avaible for me to select in this view: Can someone help me with this? Is this the right procedure to migrate the button dropdown from an analysis to a view? Thank you for your support! Best regardsJulia Bauer

7 months ago

supriya.malliLevel 2

asked in General Product Q&A

Hi,I want to create a table to get the raw count of my tables and also want to add the today's record count when the scheduled job is executed daily.

I have tried the below code:CREATE TABLE TABLE_COUNT_TC AS(SELECT t.table_name AS table_name,SUM(ps.row_count) AS row_count, CURRENT_DATE AS Record_Date FROM tables t JOIN projections p ON t.table_id = p.anchor_table_id JOIN projection_storage ps on p.projection_name = ps.projection_name GROUP BY t.table_name,ps.row_count ); This code is giving multiple lines for one table and they are not the raw tables. They are the tables that are created in transformations. Can anyone have idea on the above query? Thanks,Supriya.

7 months ago

barnala.aksha13Level 1

asked in General Product Q&A

What can be used to compare selected cases in celonis with the source system entries

7 months ago

mathina.mouniLevel 1

asked in General Product Q&A

i dont get mail

7 months ago

harini.p26Level 2

asked in General Product Q&A

how can we create benchmarking using new views

I am able to create benchmarking using legacy views but when i try using the same method in updated views i am getting errors.

7 months ago

Page 8 / 57

Badge winners

rohit.shukl12has earned the badge Solution Creation Expert
charlie.rigbyhas earned the badge Qualified to Write PQL Queries
mona.naghahas earned the badge First Post
yuu.motokhas earned the badge Qualified to Manage Implementation Projects
maxime.psbpmhas earned the badge Qualified to Build Analyses

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Celonaut Login Celonis ID Login

Login to the community

Login with SSO

Celonaut Login Celonis ID Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook