- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Ask the Community
General Q&A

General Q&A

Can't find what you're looking for? Ask it here!

1,159 Topics
2,511 Replies

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

1159 Topics

Most replies

Most views

Newest first

muskan.singh15Level 3

asked in General Q&A

why does Celonis use Snowflake schema instead of Star schema?

1 year ago

preethi.p12Level 4

asked in General Q&A

Is there any Vsql function to derive numeric value of text?

For eg; I have a values in column like 9, 30, sixty days, five monthsI want to convert these sixty days to 60and five months to 5I have done this using case when for possible scenarios looking if there is any direct function I can make use of..Thanks in Advance!!

1 year ago

andre.maerk11Level 1

asked in General Q&A

Action Flow: Is it possible to save a CSV file on the local PC drive with an Action Flow?

1 year ago

chiara.vozzeLevel 3

asked in General Q&A

Live demo // Celonis for Finance: Optimizing DPO

Hey community, I had the opportunity to join the Celonis for Consulting and I would like to ask you what VMD Mismatch stands for:

1 year ago

milan.ericLevel 3

asked in General Q&A

Calculate Throughput Times between Activities and ignoring all cases if it touched a certain Activitiy

Hello, for some reason I can´t find any solution online for this problem. It is probably out there but I cant find it. I simply want to showcase the following: The Average throughput time between Activity A and C, but ignore all cases where it touched Activity B inbetween. This feels like a very easy task but I can´t seem to find how to filter out Activity B. Basically I thought it would like this: AVG ( CALC_THROUGHPUT ( FIRST_OCCURRENCE [ 'A' ] TO LAST_OCCURRENCE [ 'C' ] , REMAP_TIMESTAMPS ( "_CEL_O2C_ACTIVITIES"."EVENTTIME" , DAYS ) )) And then in the component filter: FILTER "_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" NOT IN ('B') This obviously doesn´t work so I am here. Maybe someone can answer me this rather simple question I suppose. Thanks!

1 year ago

akshay.patil14Level 2

asked in General Q&A

Hi all, How can I retrieve the second values from a source column. I want the second LINK from the PU_FIRST("MARC","PICTURES"."LINK")

1 year ago

sandip.hapas13Level 2

asked in General Q&A

For SRM tables understanding which site is better? e.g SAP - leanx

1 year ago

suvam.nayak12Level 3

asked in General Q&A

Hi Everyone, We got a requirement from client where they are asking whether we have the option to use Power BI dashboard as a source system and get the data into Celonis EMS. Kindly help if anyone is aware of the options available.

1 year ago

mpho.matheLevel 3

asked in General Q&A

What are the top 3 industries that Celonis is deployed in?What are the top 3 use cases that Celonis is deployed for?

What are the top 3 industries that Celonis is deployed in? What are the top 3 use cases that Celonis is deployed for?

1 year ago

nura.linggLevel 1

posted in General Q&A

Improve your Supply Chain Sustainability with Celonis ♻️

Improve your Supply Chain Sustainability with Celonis ♻️ How? Download the Realistic Guide to Sustainable Supply Chains. This guide doesn’t just cover the “why” but also how you can turn vision into action and drive change. Read the guide to:Discover the reasons why organizations are struggling to bridge the gap between sustainability & visionLearn the practical steps to identify the areas that have the greatest impact on the scope you’re targetingUnderstand how to make tangible change within your organization’s Supply Chain processes 📗 Download the guide now to make your supply chain even more sustainable! 👉🏼 Link here Kind Regards,The Celonis Sustainability Team 🌍

1 year ago

elen.groch13Level 2

asked in General Q&A

Blueprint for Push CSV to Event Collection it is not working.

Dear Celopeers community, I am learning a bit more about Action Flows and would like to work with the action flow for Push CSV to Event Collection from Marketplace, but it seems to be an invalid blueprint. All the other Action Flows blueprints are working fine to me. Can I get this blueprint in some other way? Best regards!

1 year ago

radek.jLevel 1

asked in General Q&A

How to setup 2 dropdowns to two separate Variant Explorer which are based on one table?

Hi Community, Recently I wanted to add two separate variant explorers with designated dropdowns for each of them whit same table as source.However after adding dropdowns, selection in one is duplicated in another slider.Can you kindly support me how to configure them so they will be connection only between 1 dropdown and Variant explorer? Thank you in advance for your support.

1 year ago

akash.suhag12Level 2

asked in General Q&A

i have activity table which have same timestamp(T) for multiple activities in a single case.for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C.but flow is A->B->C

i have activity table which have same timestamp(T) for multiple activities in a single case. for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C. but flow is A->B->C

1 year ago

verlon.salayLevel 2

asked in General Q&A

Why are my errors not being automatically reprocessed even when the module is attached to a Break Module?

I've been wanting to find a way to automatically retry/reprocess errors(mostly RunTime Error) whenever my Microsoft 365 Excel encounters one. I've connected a break module to it with this configuration - but somehow it's not automatically retrying. So I resort to resolving it manually.

1 year ago

sainadhareddy.munagLevel 2

asked in General Q&A

How to send multiple Excels in one email attachement by using Action Flow

I have Created one Action Flow Get the all data by using celonis Query Data Module after that Data differentiate by using Router Module and create 4 Excel files ,These Excels Files send throught one email Attachement,How possible please guide me.Please find my Action Flow Diagram.

200

1 year ago

travon.petitLevel 2

asked in General Q&A

Data model ErrorI got the following message for data model load error. What causes this issue?The load failed: Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship.

The load failed: Load failed. Error Message: Could not execute foreign key join: there are duplicates on both sides of the specified key relationship. Table "BSEG": key columns ("GJAHR", "BELNR", "BUKRS", "MANDT"), key ('2021', '0100408024', '7000', '100'), rows 1028848 and 1028849. Table "BKPF": key columns ("GJAHR", "BELNR", "BUKRS", "MANDT"), key ('2021', '5102905179', '4001', '100'), rows 1404891 and 1404892.

150

1 year ago

preethi.p13Level 4

asked in General Q&A

How to clear or reset the selected value from a dropdown?

I’m trying to understand if we can clear the selected value from the dropdown. For example, I’ve configured a dropdown component and assigned a variable and using it in chart/tableThe chart/table will display according to the selection. After the analysis I want to clear or reset the filters like how we do it globally…

1 year ago

tsholo.lesofLevel 2

asked in General Q&A

Can I apply a filter in individual components in views?

1 year ago

uma.penmeLevel 3

asked in General Q&A

In which module i can get data back to Celonis in a Table in Actiojn Flows?

1 year ago

parvathi.choudLevel 4

asked in General Q&A

By which module I can get table in Action Flow .?

And Can I send data back to Celonis after creating table in Action Flows? Thank you in advance.

1 year ago

ariane.reisLevel 3

asked in General Q&A

Hi Guys, Just wondering if celonis provide any connection to the software Tasy from Philips? Thanks

1 year ago

jurgen.gakovLevel 3

asked in General Q&A

Is it possible to set up a dropdown to specify to specify if some events occured on specific daystimes. I would like to filter for each other in this dropdown

In generell the dropdown filter would start at 0:00 and end at 23:00 depending on a table with timestamps. In this case the occurances of events for different hours (e.g. 05:35, 05:12 ..) from timestamp table have to be agglomerated and each hours should be distinct (e.g. 05:35, 05:12 --> 05:00). Thank you for your help!

1 year ago

herique.sarmeLevel 3

asked in General Q&A

How may I update the machine learning license?

I'm trying to configure my machine learning workbench, but it seems I still don't have the proper permission to do it. Any clues on how I'd be able to get the updated ML license?

1 year ago

tanja.kasseLevel 1

asked in General Q&A

AP Starter Kit / DPO: Problem with the PQL Formula

Who knows it?Sometimes I get DPO like this: 466,243,595,672,831,872 daysFor example: one vendor, two invoices, sum of these two invoice is 0 €. I think it is a problem with the sum of 0 €. But how can I resolve it in the PQL formula?

1 year ago

andrew.mason11Level 2

asked in General Q&A

Are there any plans to allow "Generate PDF Report" of a View instead of an analysis?

I have started creating more of my use cases as "Views" and realized I am unable to use the "Generate PDF Report" action flow with them... Seems like Views are what will be the preferred destination for use cases premade and custom. I would like to be able to use them the same in action flows

1 year ago

Page 17 / 47

Badge winners

bruno.carva11has earned the badge Qualified to Write PQL Queries
tim.sandehas earned the badge Qualified to Build Action Flows
bruno.carva11has earned the badge Qualified to Build Action Flows
bruno.carva11has earned the badge Qualified to Build Views
bruno.carva11has 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