- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

8 days ago

Home
Community
Ask the Community

Ask the Community

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

1145 Topics

Recently active

Most replies Most views Newest first

niklas.meder

asked in General Q&A

Create pdf report by using an action flow with a runtime variable

Hi, I wanted to create a pdf report of an analysis sent to my mail account. Therefore, I created an action flow with the Celonis module "create PDF report".To filter the analysis to get the correct data, I'm using a runtime variable which needs to be implemented in the action flow.I implemented it as you can see on the first picture. The result of the pdf report is, that it doesn't show me any data in my charts as you can see on the second pic. Thanks for helping me. Niklas

2 months ago

gajjela.venka

asked in Celonis Academy

"How can I get certificate of my course complition (process mining)".

2 months ago

rita.kiss12Level 1

asked in General Q&A

Compare details of consecutive actions in the activity log

I would like to create a KPI to determine the % of the confirmation date changes which were caused by a requested date change in the Order to Cash activity flow.If the 2 events: Requested Date Change and Confirmed Date Change happened at the same time and with the same change number (which is stored in a separate column in the activity table), we assume the confirmed date change was caused by the requested date change.What would be the best way to check for this? SOURCE? TARGET? ACTIVITY_LAG/LEAD?Any ideas are appreciated.

2 months ago

apurva.patha12Level 1

asked in General Q&A

Image uploading in new view

I am trying to upload FK company logo using YAML script in new view. Below is the coding of image uploading. I am not getting any error however image is also not appearing in front end.Please Help. id: image type: image settings: src: data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAALIAAAA1CAYAAADlP7EIAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAAFiUAABYlAUlSJPAAABDqSURBVHhe7Z0JdFXFGcfdal0qLtVqF5daW6217rba2oW61H2ptdtpra0giqAiIqIoiwJVEYEiiGJFUVlUNkEBKUmABEJIQkgIEEJCCEsWEkjIBgGm87u5kzd37ryXPAL0CPM/5zvAvd9d3tz/zHzbDIedc/ZZwomTL7scJhwcDgI4IjscFHBEdjgo4IjscFAgQOSahl2ifPtOq+xo3O1rRbB7zx5RWdto1a+o2Sn2+Ho66nfutuojtfL5Dg57gwCRczfViCv7p4nLDblCymtz1ovGXUFqSh6LgTPXhfSRaweli/mrt/qaERSW14sbXs20XtPpvVUe0R0c4kXItHjw3VXisAfmheT8ZxaLjVt3+FoRbKlpFF9/bIH1mr+NyRUNlpG81yf5Vv2Tus4XM7K2+FoODq1HiMgZRdvFVx5MCJHsiA4JYuKSUl8riF6frA3pIxC8uKLe14qgtKpBHPtQovUaOtJum03i4BADISJv3NogvtszxUqye0dm+1pBLMjbJg7vENZHpmaW+1pBXN4vzap/Sd9UsdMwYRwcWkKIyFuk0/XTF5daSXZxn1RfK4jsDTXia52TrNcM+6LY1wrirhHLrfqnyVHc5lg6OMSC

2 months ago

.1683757

asked in General Q&A

Conformance Checking for P2P is not accepting multiple files

Hi All, I am trying to create a conformance analysis for the P2P process. The problem is that we don't have one process model for it since it is a really complex process with multiple sub-levels. I already have the high level process model and its sub-levels, but they are on separate files and I can't upload them all on Celonis for Conformance Analysis. Are there any suggestions on how to address this and perform a conformance analysis for a complex process such as the P2P process? Thank you!

3 months ago

amit.mando

asked in General Q&A

Vendor registration for deploying remote technical resources

3 months ago

.1683757

asked in General Q&A

How to Filter POs from a specific date UNTIL TODAY?

Hallo, I am trying to create a predefined view filter to filter POs starting from 01.01.2023 until today, so that users when opening the view get all the data regarding POs from 01.01.2023 until the date they open the view. This is how i did it but it is not working i guess because it sees the date format as String. Any Idea of how can i solve this, will be appreciated! FILTER "EKKO"."AEDAT" BETWEEN '2023-01-01' AND TODAY(); Thank you!

3 months ago

arturo.orteg11

asked in General Q&A

I am using an olap table where a record from my dimension dissapears when i use a kpi which is based on a table that does not have this record. Why does this happen? can I make it appear using this kpi?

3 months ago

dany.moual11Level 1

asked in General Q&A

Dear Community, Did you ever handle the following delta extraction error message on JDBC: Columns: (SYS_NC00065$, SYS_NC00066$, SYS_NC00067$, SYS_NC00064$) have changed. Table won't be delta loaded. Please perform a full load instead. ? The columnname all include a $-symbol, but I cannot understand whether that is a reason. I would welcome any helpfull suggestion. Thanks a lot

3 months ago

ramasrikari.donta12

asked in General Q&A

Initially I had four attempts to complete the Rising star technical assessment. I failed in the first two attempts of the first section. Now it shows 0 attempts remaining.I have competed all other sections.Please guide me how to restore those at

3 months ago

cristina.oyama

asked in General Q&A

Is there any use case using Service Now connector ? I want to see how Celonis was able to bring value.

3 months ago

neda.petro11

asked in General Q&A

Banner Notifications shortcoming

Hello All, I have been looking at the banner notifications feature, but it seems that : no hyperlinks are possible, only URLs as text no formatting of the text is possible via HTML (e.g. bold text, line breaks etc.) Is there any workaround to that so we can publish interactive and visually appealing messages to the users? Thank you!

3 months ago

shivani.lonis11

asked in General Q&A

i cannot found fundamental process mining in business analysis what can i do

3 months ago

julio.bolan12

asked in General Q&A

What does the impact mean on the starter kit inefficiencies?

The starter kits usually have a Surface Inefficiencies section where there is a column called ‘impact.’ I would like to better understand the meaning of this column. The example bellow is from the order management starter kit and the tab touchless orders. Thanks,Julio

3 months ago

akash.suhag12

asked in General Q&A

while using replace function in celonis pql getting an error because string contains a comma in the value and replace function is considering it as a parameter in the function. is there a work around for it?

3 months ago

vinay.sutar

asked in General Q&A

i failed rising star technical assessment attempt 2 time but fail both time then after 2 days i came back see there is not refill again then what i should do?

Hi I am trying to calculate the time elapsed since the occurrence of a particular activity and all subsequent activities in the case.For example, if there are 5 activities in a case, of which the activity 'Lodgement' is the second activity. I would like to calculate the time take between 'Lodgement' and the 3rd activity, 'Lodgement' and the 4th activity and 'Lodgement' and the 5th activity.Note:1.The number of activities per case is not a fixed number.2.The occurrence of 'Lodgement' activity is not fixed in the activity order. Any pointers on how this can be done in PQL is much appreciated.Many ThanksAshwin Hosbett

Hi All,I am trying to find out how long a case officer spent time on a case on a daily basis.For Example - If there are two officers - Alex and Rick, I would like to find out how much time Alex and Rick spent per case every day.Any pointers on how this can be done would be helpful.Many Thanks!RegardsAshwin H

3 months ago

douglas.souza

asked in General Q&A

ORACLE EBS - COLUMNS ERROR FLOAT

HELLO, CAN YOU HELP WITH THIS ERROR: The load failed: Load failed. Error message: Error joining table ["OE_ORDER_LINES_ALL"] with table ["HR_ALL_ORGANIZATION_UNITS"]. The data type [FLOAT] of column ["OE_ORDER_LINES_ALL"."ORG_ID"] does not match the data type [INT] of column ["HR_ALL_ORGANIZATION_UNITS"."ORGANIZATION_ID"]. I HAVE ALREADY PARAMETRIZED THE COLUMNS AS FLOAT IN ALL EXTRACTIONS BUT THEY STILL HAVE AN ERROR

3 months ago

peder.stenb

asked in General Q&A

Hello; I get the error message "Extraneous ''' "when I try to write the following PQL-Query in Views.KPI("REPEATED_CASE_COUNT_SELECTED", VARIABLE('Scan Invoice', 'Send PO Auto (Jaggaer)'))Does anyone recognize what the problem is here?

Hello; I get the error message "Extraneous ''' "when I try to write the following PQL-Query in Views. KPI("REPEATED_CASE_COUNT_SELECTED", VARIABLE('Scan Invoice', 'Send PO Auto (Jaggaer)')) Does anyone recognize what the problem is here?

3 months ago

ugandhar.konap

asked in General Q&A

Hi Celopeers, How to apply saved filter(i.e., saved in KM) for a component in Views..?(getting error while applying the saved filters)

In analysis we can use component filter to filter by using saved formulas whereas in Views able to filter only by selecting attributes but not saved formulas. Even I have created filter in KM and published & tried using that filter for a component in Views getting error like PQL ErrorA PQL error is preventing this query from executing.KPI with name "Case_type_new" could not be found.

3 months ago

ana.alves14

asked in General Q&A

If I change all filters in the Replication Cockpit Configuration to: "directly delete data from the data Pool table", would all dashboards be affected? or would it only be possible for certain dashboards?

if so, do I need to make this change in all Filters? Thank you BRAna

3 months ago

pruthvin.v11

asked in General Q&A

I'm getting "undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found." Error in the Procurement Starter KitI have added INEFFECIENCIES as well kin

3 months ago

andrej.barto

asked in General Q&A

Is it possible to update package dependencies automatically (via pycelonis, action flows...)? My base knowledge model is extended in multiple different packages and I would like to automatically update all extension KMs.

3 months ago

angelika.klemeLevel 1

asked in General Q&A

Hi, I am working with Views and trying to create two process explorers within one page and, to make benchmark possible, I need independent filter dropdowns.

Is there any way to somehow connect one filter with one specific process explorer instead of filtering both simultaneously?Was trying with the YAML editor, but with no success.

3 months ago

Page 4 / 46

Badge winners

ben.lakho11has earned the badge Certified to Build Analyses
ben.lakho11has earned the badge Certified to Get Data Into Celonis
ben.lakho11has earned the badge Certified to Build Action Flows
ben.lakho11has earned the badge Certified to Build Views
ben.lakho11has earned the badge Certified to Write PQL Queries

Show all badges

Terms & Conditions Cookie settings

Sign up

Already have an account? Login

Login with SSO

Login to the community

Login with SSO

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.