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

3049 Topics

Most replies

Most views

Newest first

tamanna.tamanLevel 2

asked in Process Analysis

Ranking based on aggregated columns

Hi, I have a table of Agent who first performed an activity A calculated using (PU_FIRST(Case,Activity_Table.Agent_Name,Activity_Name"="Activity_A) and KPI of Number of times a particular activity was repeated within 7 days using : SUM(CASE WHEN DATEDIFF(dd,LAG(WorkOrder.CreatedDate,ORDER BY (WorkOrder.CreatedDate), PARTITION BY (Case.CaseNumber)),WorkOrder.CreatedDate) < 7 THEN 1 ELSE 0 END) . I want to rank the agents based on this KPI as another column. Can you please guide me on how to do the same ? Thank you for the help

3 years ago

gopinadh.kanch12Level 3

asked in Process Analysis

Celonis Analyses process explorer showing message “all existing activities are hidden”

We have created multiple Authorization objects on sales org from VBAK table and applied on data model and provided analyses access to users by adding the authorizations objects to the users and data model. when users try to access the analyses process explorer, they can only see the message all existing activities are hidden and no data displayed in any sheet of the analyses. There is no issue if i add only one sales org. auth. object to user. if 2 or more sales org. auth. objects are added to the same user, the analyses is not showing data and showing message as all existing activities are hidden . Could you please suggest the possible root cause an fix of this issue! Thank you for your support. Regards GopiCelonis authorization issue.pdf (75.2 KB)

3 years ago

.14600917Level 1

asked in Process Analysis

KPI returns different values in Number and OLAP components when filtered by same dimension value

Hi everyone, Ive created an Approval ratio of cases by using out-of-the-box KPI Ratio of cases flowing through an activity = KPI(Ratio, MATCH_ACTIVITIES(ENDING[Approved] ) = 1). It works as expected, out of 243343 cases 108698 of them are ending with Approved task which gives rounded up the value of 45% visualised as a Number single KPI component. However, when the KPI is added to the OLAP table and sliced by example Sales Channel dimension the result in OLAP and Number visuals is different. In the OLAP table Approval rate is 52% (wrong result) and in Number single KPI component is 31% (correct result). It turns out that in the OLAP table the KPI is switched to count activities instead of cases, hence the result is 52%. celonis different result1159530 61.2 KB Is there a catch how to get the same correct % in the OLAP table? All data is contained within a single table. Thanks, Ivan

3 years ago

antoine.torriLevel 2

asked in Data Ingestion & Infrastructure

Eventtime changes number of cases

Hello !I am trying to display the number of cases with a change activity on a monthly basis (ROUND_MONTH("_CEL_O2C_ACTIVITIES".EVENTTIME)).Without this column I obtain the right numbers but as soon as I display the column, numbers increase.To made sure I have a analysis filter on 2018-01. Without the month column I have:image1046404 13.6 KBWhen I put the column I have:image1066365 14.5 KBDoes that come from the PU function that does not handle well event time?The forumla for Change Rate Case isCOUNT(CASEWHEN PU_COUNT(VBAP,"_CEL_O2C_ACTIVITIES".ACTIVITY_EN,"_CEL_O2C_ACTIVITIES".ACTIVITY_EN IN (<%=changedFields%>)) > 0THEN 1.0ELSE NULLEND)Thank you in advanceEDITThe problem comes from using _CEL_O2C_ACTIVITIES.EVENTTIME. Using the sales order creation date gives me what I want.

3 years ago

chanti.pLevel 3

asked in Data Ingestion & Infrastructure

How to identify the payment is Over/Short/Exact Payment in AR

Hi Team,I have a scenario in AR, I need to derive a new activity in AR, which should tell us the payment made by the customer is Over/Short/Exact Payment.Im checking in BSEG table, by taking BELNR and the corresponding WRBTR but not sure how to match the Invoice amount to paid amount.Suggest me a possible way to match the Invoice & Paid amount.ThanksChanti

3 years ago

krzysztof.sitar11Level 3

asked in Data Ingestion & Infrastructure

Calculate AVG per dimension and keep data filtering

Dear Colleagues,I am using below formula to calculate AVG processing time per vendor.It works generally OK, but it always calculates an average from the whole available set of data. For example if we have 3 years history of invoice posting and I only want to see an average for year 2020, applying time selection filter does not change the result of this formula, which keeps calculation for 2018-2020. Is there any way to keep this AVG dynamic and alligned with current selections?Thank you.PU_AVG(DOMAIN_TABLE(LFA1.NAME1||LFA1.SOURCESYSTEM),CASEWHEN MATCH_ACTIVITIES(NODE[WF step: Remove Qty block] )=1THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[Invoice posted] TO LAST_OCCURRENCE[WF step: Remove Qty block],REMAP_TIMESTAMPS("_CEL_AP_ACTIVITIES".EVENTTIME, DAYS))ELSE CALC_THROUGHPUT(FIRST_OCCURRENCE[Invoice posted] TO LAST_OCCURRENCE[WF step: Price difference approval],REMAP_TIMESTAMPS("_CEL_AP_ACTIVITIES".EVENTTIME, DAYS))END)

3 years ago

vivek.oza12Level 2

asked in Data Ingestion & Infrastructure

Using Python , how i can Create Authorization just like we create User or Group?

Hello Community, Using Python API , how to create Authorizations ? Example of Create User user = User.create_new(Username, FirstName, LastName, foo@bar.com, Password123) How to Create Authorization with similar approach ? , documentation for that seems missing. Regards Vivek Oza

3 years ago

prakash.k14Level 3

asked in Data Ingestion & Infrastructure

Throughput time between 1 source activity with 2 destination activity

Dear Team,I would like to create the throughput time for two different destination activities.example, from sales order creation to delivery note creation (automated) is one and sales order creation to delivery note creation (manual) is another.i wanted to combine both the manual & automated in one throughput chartin our data model, we have considered above as two activity based on the user type.

3 years ago

.14600926Level 2

asked in Data Ingestion & Infrastructure

How to display the popup after click the button component

I want to display the comments for the particular customer. My requirement is once i click the comments button description should display the pop up screen. Hope i get the solution here.Thanks in Advance.

3 years ago

simon.wendlLevel 1

asked in Data Ingestion & Infrastructure

Sum over a period with newest/latest values per period

Hi all,Im struggling with the following problem.The table structure is as follows:Instance|Task|Instructionimage1165333 21 KBI want to calculate the sum of Nein and Ja over all Pay_Periods. However, I want to exclude the entries where I have double inputs for a month (CREATED_D differs slightly). So, I want to take the latest entry of a pay period (whether Nein or Ja) to be considered.First, I tried to useSUM ( CASE WHEN Instruction.PROCESSOR_INPUT = Ja THEN 1 ELSE 0 END)but I have no clue how to exclude the double entries / just consider the latest ones.Also, I tried something with the following formula, however it didnt work outPU_MAX (Task,Instruction.Manual_INPUT,Instruction.CREATED_D =PU_MAX(Task,Instruction.CREATED_D,Instruction.Manual_INPUT IS NOT NULL))Hope the problem is well explained.Thanks for you support!Simon

3 years ago

.14600951Level 2

asked in Data Ingestion & Infrastructure

Formula: round to any decimal places

Hello all,is there a formula where you can round to any decimal places? I would like to round the formula part in the square box to three decimal places, for example 0.123.image1138107 12 KBBut the total result should be calculated to any number of decimal places.Best regards

3 years ago

joos.buijsLevel 6

asked in Data Ingestion & Infrastructure

Pass parameter values in URL

We would like to embed our Celonis (CPM4.6) analysis/dashboard in the operational tools.Concretely, we would like to be able to build an URL passing certain parameters (for instance time period, team, etc.).Im envisioning something like:https://myCPM4:9000/#/frontend/documents/123/view/sheets?team=45&startDate='1-1-2020'Would this be possible in CPM4.6?And in the cloud?

3 years ago

pooja.tiwar11Level 2

asked in Data Ingestion & Infrastructure

Sum of Amount of two different table having period number in Column chart

Hi all,I want to create a Column Chart which takes sum of amounts of two different tables having period numbers. Attached is the sample data -Expected Output in Column Chart -I tried to create the Column Chart but my values are not coming correct.Is there any solution so that my column chart will take data from two different table and populate the values correctly.Help appreciated!!Thanks,Pooja

3 years ago

poonam.dumbrLevel 1

asked in Data Ingestion & Infrastructure

Celonis API - api_id information

Hello Team, I am trying to connect celonis 4.5 with Python referring the below link: https://celonis.github.io/pycelonis/notebooks/00_Connecting_to_Celonis.html Can you please help me understand what value do we have to pass in api_id in the login method. Regards, Poonam

3 years ago

joe.misliLevel 1

asked in Data Ingestion & Infrastructure

Create number KPI - % of ‘n’ most common variants

Im trying to create a number KPI that gives the % of cases contained in the top n variants. This would be the number shown in the variant explorer as the % of cases contained in the variants selected (for example, when dragging down to the top five variants in variant explorer, the bubble at the bottom says 72%. I want to use that 72% in a calculation.). I want to be able to use this number in other calculations. Id like for this to be static (not subject to filtering), which I know how to do. Are there internal variables that contain this and other information that is used to create the graphics?I found this reference but its not of much help. I cannot get to the page in any case. Percentage of cases covered by the 5 most common variants - #3 by gvanenisHow would I use the INDEX_ORDER syntax to calculate the KPI Im looking for? Thanks in advance for your help.

3 years ago

holger.meissLevel 2

asked in Data Ingestion & Infrastructure

Extensive memory consumption using PullUp-Functions

Hello and a happy new year,we do have the problem of memory allocation while using several Pull-Up Aggregations. Is there a way to release the memory frequently?Our set up is Hybrid (IBC + Leave your data in place).We have 90mio Activities@8.5mio Cases in one Model and 260mio Activities@24mio Cases in a second Model. The memory consumption is in idle state at 24 GB and moves up to 64 GB when using PU-Functions. This will quite often let the engine crash and models could not be re-loaded even from cache until the memory garbage is cleared.Thanks for any suggestion.RegardsHolger

3 years ago

benedikt.burgs11Level 2

asked in Data Ingestion & Infrastructure

Access “Data Permissions” of Data Models from pycelonis

Dear all, is it somehow possible to access IBC data model Data Permissions from pycelonis? Eg. query the current permissions configuration or set new permissions? image781538 32.4 KB Best, Benedikt

3 years ago

.14600925Level 1

asked in Data Ingestion & Infrastructure

Unable to download PTP Name mapping template

Hi, Im trying to add translations for our PTP data model as requested by the client, however, upon downloading the PTP Name mapping template it says " failed to download PTP Name mapping.

3 years ago

carl.schadLevel 3

asked in Data Ingestion & Infrastructure

Use xlsx file as filter during extraction

Hi there, I am unable to find how to use a xlsx or csv as a filter criterion during extractions. I want to set an extraction parameter but the list of values is fairly long and I dont want to type every value in there manually, but reference an uploaded xlsx. Is that possible and if so how do I do it? Thanks and best regards, Carl

3 years ago

kendrick.looi11Level 2

asked in General Product Q&A

I was trying to execute job with SAP AP Connector (with Celonis database connection configuration), however I got error when executing the jobs.

This is one of the error message I had: Table BKPF cannot be accessed with the current connection configuration.. Celonis Support ID: 7097d202-4f59-464c-8e18-38c7a037ebb8

3 years ago

himalini.himalLevel 2

asked in AI

APC reduction script missing excel file

Hi celonis team, I am looking at the APC reduction script documentation posted in the partner portal. However, i am unable to find the App Store Filters.xlsx file that is required for me to complete the python script. The documentation says Download the attached excel file., however, i cannot locate this in the word file or the download loaction " Celonis Partner Portal". Could you help me as we require this for a client project. Thank you.

3 years ago

tomoki.tsuneLevel 3

asked in Data Ingestion & Infrastructure

Bubble chart with multiple Counts

Hi, I am wondering how I could create a bubble chart with multiple bubbles on a single line, as it is shown in the photo attached.I have been trying to use PU_COUNT, but the parent and child tables do not have the same columns, which made me difficult to distinguish the sums depending on the number shown in the graph.Best,chart846524 21.7 KB

3 years ago

raphael.correLevel 2

posted in Entry Products (Celonis Free Plan & TryCelonis)

Dear Colleges,

Dear Colleges, I am trying to set a filter at my Pivot Table I would like to have the "1" of each activity to know the users that performed more than one activity in a process. I am trying for two days with success. Best Regards Raphael Correa

3 years ago

maximilian.hoffm13Level 3

asked in General Product Q&A

Data Model Usage Permissions for Application Key

Hi Celopeers, is there a way to apply "finegrained" permissions for an application key onto a data model?We want to enable a ML application to access a Data Model in a read-only manner. The application key should be able to query the data model, but nothing else. The only way to grant access to a data model is to set the "Admin" Permission for that application key on the pool level. Thus, the application key has FULL access to EVERYTHING in this pool, and potentially access/edit/delete things it's not supposed to. The "Use all Data Models" permission does nothing for the API as is only applies to analysts creating content so that they can link their assets to a DM. Thank you for your helpBestMax

3 years ago

miriam.luttrLevel 3

asked in Process Analysis

Action Engine Migration to Studio Skills

Hello, We are currently in the midst of migrating all our Analyses and Action Engines to Studio. Celonis provided with a functionality to seamlessly migrate the analyses to Studio. Is there an easy way to migrate Action Engine Skills to Skills within Studio? Thanks

3 years ago

Page 87 / 122

Badge winners

dan.morrihas earned the badge Qualified to Deliver Business Value with Celonis
christos.demos11has earned the badge Celonis Certified Data Engineer
jordan.hellehas earned the badge Qualified to Manage Change and Scale Adoption
ardi.zulfahas earned the badge Value Realization Expert
ardi.zulfahas earned the badge Qualified to Deliver Business Value with Celonis

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