Success Hub
Product Updates
Groups

Home
Community
Ask the Community

Ask the Community

Get answers to general questions and Academy-related topics from fellow users and experts.

1255 Topics

snehaLevel 3

process mining digital badge

hey,i completed the whole module in process mining but didnt recevied my certificateplz help me in solving this problem mail id :- snehachanna1125@gmail.com,thank you,sneha.

231

4 months ago

CelonisAcademyLevel 3

posted in Academy Q&A

New Course: Accelerate Process Analysis with Insight Explorer

Configure Insight Explorer assets in Studio and interpret insights.The course is available here.

140

4 months ago

sivasakthi.dhandLevel 3

asked in General Q&A

Filter using parameter in view not working in object centric data model table.

I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'

181

4 months ago

michael.kaempLevel 3

asked in General Q&A

assign date value from an augmented attribute to a variable and use it

Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute - id: CM_MONTHS identifier: id: id displayName: Id pql: '"CM_MONTHS"."MONTH"' attributes: [] newAttributes: [] augmentedAttributes: - id: late_creation_deadline_date displayName: "Late Creation: deadline date" possibleValues: [] columnType: DATE format: "%Y-%m-%d" housekeeping: false type: AUGMENTED_ATTRIBUTE flags: [] priorities: [] triggers: [] businessRules: [] type: RECORD origin: PACKAGE The component to update the augmented attribute type: table settings: data: columns: - id: 3486adcd-a996-49a5-97e0-af17da07e9af field: CM_MONTHS.MONTH order: 100 - id: 10c08937-649f-48a0-88fe-929d3107e824 field: CM_MONTHS.AUGMENTED_late_creation_dead

220

4 months ago

CelonisAcademyLevel 3

posted in Academy Q&A

New Video: Install an Object-Centric App from the Marketplace

This video shows end-to-end how to load a catalog object-centric data model and connect it an app from the Marketplace.The video is available here.

4 months ago

snehaLevel 3

asked in Academy Q&A

i had completed the modulle but its is not showing any progress

plz help me in sloving this problem i completed Use the Variant Explorer in process mining but it is not showing any progress for this module because of t6his module iam not receving my cerificate

384

4 months ago

sagar.belurLevel 2

posted in General Q&A

Calculate a KPI without affected by change in Dimension

Hi,I am working on a KPI (A), which is calculated based on the result from another KPI (B) but this KPI (B) should not affected by Dimension selections. Do you know if this is possible? Thanks

141

4 months ago

tommaso.senec13Level 2

asked in Academy Q&A

Training Track Completion Status

Hi everyone,I have completed the training track “Internal - Core Processes”, still I am not receiving any confirmation upon its successful completion and the overall training status remains at 75%.I have done the courses of that training track twice but I couldn’t get to 100%… Do you have any idea on how to solve it? Thank you very much!

4 months ago

vignesh.g12Level 2

asked in Academy Q&A

Process mining fundamentals badge is not received.

I have completed my course track “Process Mining Fundamentals” but the course badge is not received yet. Out of 7 badges only 4 badges I received. I have attached the image that I completed proof of that track. What can i do for solving this issue?

How to Exclude NULL Values in a CASE WHEN Statement in PQL?

Hi All,When using a case when statement how would I go about excluding all the values which are not true from the result.Lets say:CASE WHEN PROCESS EQUELS 'A' -> 'B'THEN 'A to B'WHEN PROCESS EQUELS 'C' -> 'D'THEN 'C to D'Now I'm only interested in plotting the values fall in the 'buckets' basically. How do I exclude the rest which are NULL (very large number of cases).

310

4 months ago

omomadia.kagho12Level 2

asked in General Q&A

How can obtain the total number of invoice, PO, and line items in an aggregate expression

Hi all, I am using the COUNT function to get the total number of invoices, PO, and line items that fulfill the conditions in the code statements. The problem is the KPIs I am using were created using COUNT functions, which makes it impossible to get the total numbers by nesting the entire code in another COUNT function. This gives the error message: Aggregate expressions cannot be nested inside aggregate expressions. Does anyone have an idea how I can resolve this issue? The code is added also.

150

4 months ago

milan.ericLevel 3

asked in General Q&A

Knowledge Model added a record to the Base and now I can not remove it

Hello everyone, not sure if this is a bug but I am very new to knowledge models and views. I only worked with analysises beforehand and I am trying views for the very first time. I somehow added a record here. Not sure how, since I never pressed “Create record”. I tried to create an augmented attribute but it somehow failed. Anyways I am trying to clean up my mess now. This is the newly created record: It is autogenerated and now is included everytime I create a Knowledge Model based on that Data Model: I NEVER touched the BackEnd at all. When opening the DataModel in the preview section, it exists as a standalone table: But when I ppress “Go to Data Model” it does not actually exist in the BackEnd (obviously, since it doesnt exist).But how do I get rid of this record? It annoys me that it exists and I can not do anything about it… Thank you!Sincerely, a very confused new Views-User

231

4 months ago

milan.ericLevel 3

asked in General Q&A

Bill of Material structure in Celonis

Hello everyone, we currently want to display the Bill of Materials Hierarchy in Celonis.The issue with that is, that the hierarchy is not present in any SAP-Table. But instead in the related tables MAST and STPO.I have the MAST which has BOM and Material (component) relationship which needs to be traversed to STPO with the BOM-Nr. to identify the compenents and each component may be split into sub materials and new BOMs which needs to be looked up in the MAST for its BOM again and it goes on and on. Up to 4 levels deep.So the 4th level has no relationship to the first level. This recursive issue with inputing the results from MAST into STPO into MAST into STPO… is not possible in the FrontEnd (I assume).I am going crazy with knowledge models and action flows, the documentation is absolutely horrible. So it probably needs to be done in the data model itself. Additionally we want to add the Vendor from open orders from the EKPO. So we can filter for a material and for a vendor to so the

482

4 months ago

priyank.gandh11Level 2

asked in General Q&A

How can I change the implicit Left Outer Join in Celonis

Col 1 and Col 2 are the two columns in the OLAP table I'm attempting to generate.Where Col 1 from Table A can have 0 or many values associated from Col 2 of Table B.The cardinality of Tables A and B is (1:N). Currently in place-Values in Col 1 of Table A that have no value associated with Col 2 of Table B are excluded from the OLAP table. What I hope to accomplish-Values in Col 1 should be shown, and values that have nothing related with Col 2 of Table B should have (Null/-) displayed in front of them. The Join Functionality of Celonis does Left Outer Join, and considers the (N) side table (Table B) on the Left Side implicitly, while I want it to be the other way round. Thank You! Regards,Priyank

260

4 months ago

thomas.keimLevel 4

asked in General Q&A

Calculate total amount of calendar weeks from date picker selection

Hello crowd,I need your swarm knowledge for this issue:I selected July + August in date picker, which is 9 calendar weeks.My objective is to calculate the average sales orders per customer per calendar week.You can see it in my screenshot. One customer per line, count of sales orders and count of calendar week where sales orders are created.The challenge is, that not every customer is ordering in every week.My question is: How do I get the total number of calendar weeks (9) from the date picker in my formula?I would like to divide the “number of orders” by the “total calendar weeks from date picker” and not by the calendar weeks in which the order was placed.Best, Thomas

200

5 months ago

NkosiyamntuLevel 2

posted in Academy Q&A

Storyboard for User-Centered Analysis

Sheet Name Purpose KPIs Dimensions Proposed Design Region Overview Show three main metrics so that manager can… # of, % of Creation month Side-by-side comparison of single KPIs showing…, Combine column and line chart showing… Average TT Highlight average turnaround time across processes to assess efficiency. Average Turnaround Time (TT) Creation month Line chart showing TT trends over time, broken down by region or category. Late Payments Analyze frequency and causes of late payments to reduce occurrences. % Late Payments, # of Late Cases Creation month Bar chart showing late payment ratios, and a trend line for late payment count. Automation Impact Showcase the impact of automation on reducing errors and improving speed. # of Automated Tasks, % Error Reduction Process Category Pie chart for task distribution and bar chart for error reduction over time. Order Rejections Highlight reasons and trends for order rejections to optimize processe

361

5 months ago

mateusz.dudek14Level 7

posted in General Q&A

Hey, I wasn't logging into celopeers for some time, congrats on being first! :)

Hey, I wasn't logging into celopeers for some time, congrats on being first! :)Celonis defenitely should send you a t-shirt or something else! Thanks for engagement, probably I'll also return to helping some people here.

161

5 months ago

CelonisAcademyLevel 3

posted in Academy Q&A

New Course: Object-Centric Modeling Best Practices

Learn about Object-Centric Modeling best practices.The course is available here.

160

5 months ago

CelonisAcademyLevel 3

posted in Academy Q&A

New Video: Set Up Extractions for an OCDM Process

Download and set up extractions for an object-centric Celonis catalog process.The video is available here.

5 months ago

lyzanne.tr24Level 2

asked in General Q&A

Sap URL creation

We are working on linking the ordernumber from Celonis to a link in SAP perferably to 4hana. Does anyone know of a way we could automatically generate such a link?

100

5 months ago

CelonisAcademyLevel 3

posted in Academy Q&A

New Video: Navigate the Celonis Platform

Explore the Celonis UI along with its services' purpose and structure. The video is available here.

5 months ago

CelonisAcademyLevel 3

posted in Academy Q&A

New Course: Configure Process Copilot

Construct and finetune a Process Copilot end-to-end. The course is available here

120

5 months ago

deepak.sharm12Level 2

asked in General Q&A

Send Email option in Table in View

Hi Community, while using Send Email action in Views table, there are 2 options:Launch default email program and Send from serverbut second option is disabled and status is ‘In Progress’ (unable to select it and proceed with this option). what’s the meaning of this? is it a permission issue or what?please check attached image as well.

280

5 months ago

ivana.ljubiLevel 2

asked in General Q&A

Resend invitation to only pending users

Hi,is it possible to resend invitation after 14 days of unaccepted invitation, as using “Sharing invitation” task is not working. It is showing message “only user with pending status can be selected” but I selected exactly those users. Would be good if I can resend invitaiton with one click, rather than using blue button “invite new users” and type all emails again..Thanks.

lukas.deekeLevel 2

Hi All, I need a filter that filters out all activities where activity “A” is not first. So i only want to see all cases where the correct acitivty sequence is A → B → C → D...

141

5 months ago

Page 4 / 51

Badge winners

suganya.rajenhas earned the badge Qualified to Write PQL Queries
zayneb.alsum11has earned the badge Qualified to Create and Deliver Demos
samer.odehhas earned the badge Qualified to Deliver Business Value with Celonis
Vladimir Smoleyhas earned the badge Value Realization Expert
Vladimir Smoleyhas earned the badge Qualified to Deliver Business Value with Celonis