Skip to main content

- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A

Product Q&A

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

3023 Topics

Recently active

Most replies Most views Newest first

sanya.mohsiLevel 1

asked in Entry Products (Celonis Free Plan & TryCelonis)

Learn how to install an app with demo data and analyze in Snap

Are you interested in trying Snap but dont want to upload your own data? With the App Store in Snap you will find a lot of demo data that you can install in your team and start analyzing. At the moment the following apps can be found in the App Store: Accounts PayableOrder to CashPurchase to PayService RequestsAccounts ReceivableUiPath Food Order ProcessSix Sigma To install an app follow these steps: In order to see the content of the App Store click on the button App Store top right corner in Snap: 1.jpg18971057 259 KB When you are in the App Store navigate to the apps. Select the app you want to install. In this example, UiPath: 2.jpg19031007 257 KB Click install App: 3.png18971063 162 KB Select New Workspace, enter the name of the workspace e.g. UiPath Demo, click next: 4 (1).jpg19131071 185 KB Choose the data model UiPath - Bot Analytics - Food Order Bot. Please choose the correct data model e.g: Purchase to pay app > Purchase to pay data modelAccounts payable app

jeroen.jeroeLevel 3

asked in Process Analysis

PU_Sum; aggregation over Sales Order

Hi All, As example reflecting only 1 specific SO, we currently have the following situation: All deliveries/billings from SO line items 10, 20 and 30 have a date in Q1 or Q2, whereas the date of the delivery/billing related to SO line item 40 is in Q3. Only Q1 and Q2 data is loaded in Celonis, so the delivery/billing related to item 40 is not yet loaded. Now wed like to calculate the total billed quantity for this specific Sales Order. As expected, PU_SUM(VBAP, _CEL_O2C_CASES.INVOICE_QTY) returns 40000, 40000 and 31600 for so lines 10, 20 and 30 respectively. However, if we want to aggregate over SO instead of SO line item and use PU_SUM(VBAK, _CEL_O2C_CASES.INVOICE_QTY), it returns 120000 whereas we only expect 111600. Any idea whats causing this sum of 120000 and how it can be solved to show the aggregation on SO level of only the loaded delivery/billing documents? Thanks

joos.buijsLevel 6

asked in Data Ingestion & Infrastructure

Pull up over multiple tables

We have a data structure with case, activity, customer and contact tables.A contact is linked to a customer (N:1),A customer is linked to an activity (1:N),An activity is linked to a case (N:1).A case can be executed for multiple customers, hence this relationship structure of customers linked to activities.The challenge/question is to count the number of contacts for a customer of a specific case.Bonus challenge: only select those contacts that fall within the case runtime (which are attributes in the case table).The problem were facing is the famous no common parent between tables could be found error, and we believe the even more famous PULL UP functions could help us, combined with a DOMAIN_TABLE possibly. However, the relationship is such that we cannot just access a parent or grandparent table, but need to go to the parent (case) of a sibling table (activity) of our child table (contact), through customer which is our direct parent.In our example Customer is the parent table of b

mehdi.bougaLevel 2

asked in Process Analysis

Load Script - with Variable

Hi All I would like to limit the scope of an anylsis by filtering some company codes in a load script. I have create a variable as text replacement in which I have put the list of company code: Variable Name= ShopCC TexT/Replacement= CH01,IT13,FR02,FR08 the load script is FILTER EKPO.BUKRS IN (<%=ShopCCode%>); Unfortunaltly I get an error saying that there iwas a syntax error in the load script. Any Idea please ? thank you

john.sekutLevel 2

asked in Process Analysis

Floating 90 day date range for a KPI card

In a KPI card, I would like to display only the activities that occurred for that KPI for the last 90 days. I know the below is incorrect but logically it is as close as I can get without help. FILTER _CEL_P2P_ACTIVITIES.EVENTTIME BETWEEN TODAY() AND (TODAY() - 90) The KPI card works so I am looking for the code to tack onto to get the 90 day window. Please advise! Thanks.

robin.pianeLevel 3

asked in Process Analysis

Stacked bar chart

Hello, Is it possible to create a stacked bar chart with Celonis ? Thank you for your help, Regards Robin

burke.brockLevel 2

asked in Data Ingestion & Infrastructure

Calculating Number of Process Variants

Im having some trouble understanding how the built-in Number of process variants KPI is calculated. I dont understand why these two statements are not equivalent. KPI("Number of process variants") versus COUNT( DISTINCT VARIANT( "_CEL_P2P_ACTIVITIES"."ACTIVITY_EN" ) ) image.png900323 21.4 KB

patrick.flößLevel 2

asked in Process Analysis

Error in Table while PQL Editor Preview shows results

Hello all, In the PQL Editor an output of my formula is shown in the preview. If I then go to Done and want to look at the table, I get the following error message could not find referenced aggregate COUNT(DISTINCT ). Can anyone help me? I use the PQL formula: KMEANS() in its complex form. Best Regards, Patrick 01 Preview.jpg2156449 64 KB 02 result.jpg1383276 20.7 KB

andrew.penchLevel 2

asked in Data Ingestion & Infrastructure

Creating Calculated Terms

Hi,I am trying to calculate payments terms in an Accounts Payable Analysis. Right now, my formula is:SUM((CALC_THROUGHPUT(First_OCCURRENCE[Vendor Creates Invoice] TO Last_OCCURRENCE[Pay Invoice], REMAP_TIMESTAMPS("_CEL_AP_ACTIVITIES".EVENTTIME, DAYS)))*(BSEG.WRBTR))/SUM((BSEG.WRBTR))Is it appropriate to do calculations combining BSEG and CEL_AP_ACTIVITIES Table? I would be curious to know if there is a better way to do this.

naveen.guptaLevel 3

asked in Process Analysis

Not able to edit any out of box Analysis

We are not able to edit any out of box analysis like Conformance checker, Social Analysis etc. We would like to use some of the components / formulas from these analysis into our single analysis for the users. How can we achieve the same?

.14600775Level 4

asked in Data Ingestion & Infrastructure

Creating Table that includes vendors that operate in at least 2 distinct markets

Hi,I am trying to create a table that will show me which vendors operate in two different markets one of them being Spain. Some of vendors will be listed more then once in the market thus making the pull function a bit difficult to use I believe.Not sure where to go from here but Ive been trying different codes with no luck.Case when Cases.VendorName = Cases.VendorName AND WHEN Cases.LocalMarket = Spain AND Cases.LocalMarket = % THEN Cases.VendorName ELSE NULL ENDPlease let me know.Anna

john.sekutLevel 2

asked in Process Analysis

Opening a document with a button within an analysis

I would like to open a reference document contained in the File Upload Center using a button. I cannot figure out what the Document ID is though. Any variation of ID that I enter results in a 404 error. Where must/can the document be stored for accessing? (I assume its in the file upload of the Event Collection)Where do I find the Document ID?Please advise if I am way off and there is a cleaner way to do this. Thanks!

.14600835Level 3

asked in Data Ingestion & Infrastructure

Data Model - Table Loader Pool

Hello, Can someone please help with table loader pool types? What is difference? Impact on data load? When and which type should should be used? Thank you in advance! KR, Kalpesh

.14600836Level 3

asked in Process Analysis

Segregation of Duties

Hi all, We are using a dedicated Segregation of Duties dashboard to analyze cases where two activities are processed by the same person (e.g. Creation of PO and Releasing the PO). In this dashboard, the viewer selects two activities, which shall not be performed by the same user to see in how many cases there is a violation. See here the PQL statement: avg (case when PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=From%> AND _CEL_P2P_ACTIVITIES.USER_TYPE <> B) = PU_first(EKPO,"_CEL_P2P_ACTIVITIES".USER_NAME, _CEL_P2P_ACTIVITIES.ACTIVITY_EN = <%=To%>) then 1.0 else 0.0 end) * 100 By checking the violations in detail, Ive recognized that there are cases where Person A creates a PO, Person B approves the PO and afterwards Person A changes some field in the PO (e.g. Net Order Price). Due to this change, the release indicator is AUTOMATICALLY changed from B (release) to R (not released). This case is shown as a viola

.14600772Level 2

asked in Process Analysis

Celonis mobile view

Hello Celonis Team, is it possible to use celonis on iphone or ipad? Could you give me some information about the mobile view from celonis. Many thanks

mayukha.mayukLevel 2

asked in Data Ingestion & Infrastructure

Machine Learning Workbench - Convert to DataFrame

I am trying to convert the data present in an OLAP table to a dataframe.c = get_celonis(**settings)w = c.workspaces.find(KPI Analysis - CSAT,None)a = w.analyses.find(CSAT Model,None)q=a.published.components.ids[7ae951ac-b933-4e62-b8c0-ee21e6a15845].dataCan anyone please help me what can be the command to convert q into a dataframe.Thanks!!

laura.lauraLevel 3

asked in Process Analysis

Differents currency in “units”

Hi, I would not use VBAP.NETWR_CONVERTED and have the Net Value Order in the Document Currency. When I insert as KPI VBAP. NEWTR, I would like to insert in Units the Document Currency. I tried with: VBAP.WAERS<%=VBAP.WAERS%>a variable : VBAP.WAERSa variable : {VBAP.WAERS } But it is not working. Any idea ? Thank you

gopinadh.kanch12Level 3

asked in Data Ingestion & Infrastructure

Data Model: Reload All Partitions

Dear Community, We are trying to understand the Data model status option Reload all partitions. We have tested this option with one data model and the data model load completed and the remaining data models load not started automatically. Could anyone explain this option Reload all partitions! data model - reload all partitions.png1588506 40.7 KB

laura.lauraLevel 3

asked in Process Analysis

Count Variants by company code

Hello, I would like to create a table with a count of variants by Company Code but when I use the standard KPI Number of process variants, the number not corresponding to the total I have on the Variant Explorer. Is it exist a simple formule to count the variants? Thank you

rakesh.paul12Level 2

asked in Process Analysis

Process Mining for Application monitoring tools

Hi All, Do we have any use cases for Application Monitoring tools such as Dynatrace. Can we get a process-level view with metrics of applications to see which application/interface is down because of which the process has stopped ( in real-time ). Regards, Rakesh Paul

paul.velthLevel 4

asked in Data Ingestion & Infrastructure

Flagging data or adjusting data in the frontend visible for multiple users

Hello Community,We are developing a new algorithm to help users detecting duplicates.As an inspiration we toke the blog: Celonis 5 Steps to Reduce Costs Caused by Duplicate InvoicesCelonis customers have already saved millions by taking action on duplicate invoices. Find out how to how to use fuzzy matching to find duplicates and save money using the Celonis Intelligent Business Cloud and Python. We have noticed that the algorithm detects false positives. In the algorithm, this might happen because we do fuzzy matching and searching. Now the users like to flag these false positives in the sheet. Moreover, they want the flags they made to be visible for other users using the sheet. How would you implement such a flagging system?One idea we had was creating an additional column in the table that can be adjusted by users in the frontend. In this way, the adjustments could be visible for all the users. Does somebody have any idea whether this is possible?Happy to hear your thought

anton.antonLevel 2

asked in Data Ingestion & Infrastructure

Unique cases sum in aggregation

Hello everyone!Ive got some trouble with unique case aggregation. Ive got case table with column Amount, and events table with status of process. I want to build table wich consist of some columns from case table, avg timestamp between two activities, and sum (casetable.amount).So, I build filter on list:FILTER PROCESS EQUALS (X) TO (A) ;And filters on component(Table):FILTER SOURCE(Celonis_events.activity) LIKE (X) ;FILTER Target(Celonis_events.activity) LIKE (A) ;Next, i build table dimensions:CELONIS_CASES.BUNAMECELONIS_CASES.GJAHRSOURCE(CELONIS_EVENTS.ACTIVITY) - not visibleTarget(CELONIS_EVENTS.ACTIVITY) - not visibleAND KPIS of table:AVG(TARGET(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)) - SOURCE(REMAP_TIMESTAMPS(CELONIS_EVENTS.EVENTTIME, MINUTES)))2)SUM(CELONIS_CASES.AMOUNT)All good, but if within one case we got more than one change status from (X) TO (A) activities - we got (CELONIS_CASES".AMOUNT)*(Count of (X) TO (A) ) and its wrong, because case got fixed amoun

thomas.nagel11Level 3

asked in Process Analysis

Calculation of average cases per user in a number component

Hello, I am trying to calculate the average number of posted invoices per user in a number component in the AP data model. The basic code of the KPI looks as follows: COUNT(BKPF.USNAM) / COUNT(DISTINCT(BKPF.USNAM)) The current KPI however does not yet show the real performace of the AP department because many invoices are posted via batch files or batch users and some invoices are posted by users that are doing an internship or an apprencticeship and these users do not post more than for example 100 invoices. In order to get rid of the cases which were posted by batch users, I used a component filter which works fine. But for the second issue (exclusion of cases which were posted by users that have not posted more than 100 invoices in the selected time range) I have not yet found a solution. I have tried several case when statements and also worked with ABC clusters to exclude the cases of these users, but nothing worked. Does anybody of you have an idea how this could be solved? I am

jelmer.bodeLevel 2

asked in Process Analysis

Graph - Changing activity at certain date

Hi all, We have implemented a new system, which has different activities names. I would like to have one graph, where the graph shows the data from one activity, and after a certain date (01-09-2019 (dd-mm-yyyy)) from an other activity. Using now the following formula in two different graphs, but I would like to combine them. AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[Ontvang Factuur] TO LAST_OCCURRENCE[Valideren Factuur], REMAP_TIMESTAMPS(XXCEL_AP_ACTIVITIES.EVENTTIME, HOURS))) AVG(CALC_THROUGHPUT(FIRST_OCCURRENCE[XXAIMG: Ontvangen in APRO Imaging] TO LAST_OCCURRENCE[Valideren Factuur], REMAP_TIMESTAMPS(XXCEL_AP_ACTIVITIES.EVENTTIME, HOURS))) Is this possible? Hope you can help me. Kind regards, Jelmer

maximilian.heilmLevel 2

asked in Process Analysis

Dimension combining calendar week and year

Hello all, I wonder if there is a way of combining the CALENDAR_WEEK() format with the YEAR() format similar to the way the statement ROUND_MONTH does for exmaple. The problem I have with the calendar week as the dimension is that in case of a dataset that includes data from more than one year, the KPIs do always calculate the data of all years for each calendar week while I would like them do distinguish between the weeks of the particular years. Best regards, Maximilian

1
...
115
116
117
118
119
120
121

Page 118 / 121

Badge winners

sayali.randh11has earned the badge Qualified to Build Action Flows
lyzanne.tr24has earned the badge Qualified to Deliver Business Value with Celonis
el.mostafa.janahhas earned the badge Celonis Certified Data Analyst
jumbo.szkhas earned the badge Masterclass in Implementation
makun.sharmhas earned the badge Masterclass in Implementation

Show all badges

Powered by Gainsight

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Login with Saml2 Login with OpenIdConnect

Login to the community

Login with SSO

Login with Saml2 Login with OpenIdConnect

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.

OK

This file cannot be downloaded

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

OK

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

LinkedIn

YouTube

Instagram

Facebook

Terms and Conditions

Celonis © 2024