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

ramanathan.iyerLevel 3

posted in Data Ingestion & Infrastructure

Has anyone tried replacing the On Premise Extractor to Celonis On Premise Client .

Has anyone tried replacing the On Premise Extractor to Celonis On Premise Client .have quite few questions

8 months ago

douglas.henriLevel 4

asked in General Product Q&A

PQL/SQL Convert Date

Hello everyone, can you help me please? I need to convert the field "T056P"."DATAB". Solutions can be in either PQL or SQL. But it's not returning anything. I've tried various methods such as: TIMESTAMPADD, ADD_MILLIS, ADD_SECONDS, CAST, TO_DATE, all without success. The return for the first three I mentioned was: Operator requirements are not met. Operator 'ADD_MILLIS' is not compatible with inputs of type DATE and STRING - expected DATE and INT."

8 months ago

vinod.kumar.ummadLevel 2

asked in General Product Q&A

How to repeat and execute the query on conditional based

UPDATE Test_Current_Year DSET Test_util=C.Test_util+C.full_Variance FROM(SELECT A.Test_util,B.full_Variance,A.Name FROM (SELECT * FROM Test_Current_Year WHERE Month_Number=7) A JOIN(SELECT * FROM Test_Temp WHERE Month_Number=8) B ON A.Name=B.Name) I am working on the forecasting requirement.Assume that the current month is 4 where data will not be available by applying the forecasting logic I should take last year's data into consideration like finding the variance of Apr,Mar of last year and add the variance value to the current year's Mar to fore cast as Apr data for current year..The month number should be adjusted dynamically based on the current month Example:current month=4(current year)(lastyear)Apr-Mar=variancecurrent year Mar+varince(above step)=Apr value(forecast) current month=5(current year)(lastyear)May-Apr=variancecurrent year Apr(got in previous step)+varince(above step)=May value(forecast) similarly I have to forecast till dec

8 months ago

salma.zepedLevel 4

asked in General Product Q&A

Is there some way to hide the KPI name from a KPI List?

I would like a KPI with a custom title (yellow) instead of the KPI name (green). This KPI is reused multiple times and it does not make sense to have the same KPI created many times just to have the customized title (coming from the KPI name). Instead, is there a way to hide the KPI name on a KPI List component? Thank you!!

8 months ago

julia.bauerLevel 5

asked in General Product Q&A

Coloring of KPIS / Columns in tables via YAML

Hello everyone, I'm currently working on a dashboard within a view. There are two points where I'm probably lacking the YAML syntax or perhaps the "functionality" is not available yet: 1) Example without data - KPI - I want to color the number (in %) in e.g. red - is this possible?2) I want to color the background of a column within an OLAP table - how is this possible in YAML? Thank you for your support! Best regardsJulia Bauer

8 months ago

koert.kritz11Level 3

asked in Process Analysis

Hi all, I want to create a dropdown in views of the hours in a day, but my dropdown shows multiple values for each dropdown.

Here is the code: ROUND_HOUR( "ITT_PRODUCTIVITY_F_SEP_UAT"."EVENTTIME" )

8 months ago

raman.silot14Level 4

asked in Data Ingestion & Infrastructure

Dynamic Color Mapping

Was just curious that can we dynamically mention threshold value in color mapping? instead of mentioning static number. Just like in this image

8 months ago

.14600843Level 3

asked in Process Analysis

Time difference between multiple occurrences of activities

In my activities table, I have cases like create incident A B C B A B Now I want to calculate the time difference between create incident and every occurrence of B. Example: (create incident and B (first occurrence), create incident and B(second occurrence), create incident and B(third occurrence)). After that, I want to calculate the overall average of these time intervals.

8 months ago

stefan.regenLevel 1

asked in Process Management

Dear all,trying to establish intelligent automation by and therefore looking for Integration options between Celonis and...Blue PrismAxon IvyPower PlatformSymbioGB-TecSMAP OneLUISCognigy AIAny ideas, connectors or Workarounds?

Dear all, trying to establish intelligent automation by and therefore looking for Integration options between Celonis and... Blue Prism Axon Ivy Power Platform Symbio GB-Tec SMAP One LUIS Cognigy AI Any ideas, connectors or Workarounds?

8 months ago

michael.kaempLevel 3

asked in General Product Q&A

(How) is it possible to use package translation in knowledge model KPIs?

I understand, that I can't use the t("xyz") notation in PQL - neither directly nor as parameter - because it's YAML. But I must assume that there is a way, because of the first sentence after the note in the documentation: Analysts can enable App Translations and provide a translation Map for user-generated content like Knowledge Models, Views, etc. This feature is a Package setting, and changes are available when published.https://docs.celonis.com/en/translating-studio-apps.html

8 months ago

el.mostafa.janahLevel 2

posted in Data Ingestion & Infrastructure

Dear Community,

Dear Community, does anyone have any idea on how to create a chart in a view with running sum logic, that means for: January 24: i would like to display the sum of purchase order value of the last 12 months from Jan 23 till end December 23 February 24: the sum of purchase order value (for example) from February 23 till end january 24 March 24: the sum of purchase order value ((for example) from March 23 till end February 24 and so on for the coming months. I can imagine that i have to build the logic in the KPI itself. Furthermore, i would like also to create a chart in a view with YTD Logic: January 24: Data, like purchase order value, just from January 24February 24: Sum of purchase order value of January & February 24March 24: Sum of purchase order value of January & February & March 24...... Thank you so much!

8 months ago

sarina.sommeLevel 3

asked in General Product Q&A

How can I use this button to show and hide a filter bar?

Hi all, I just found this cool functionality in a try celonis case and would like to know how I can show and hide this filter bar. Do you know how to do this? Unfortunately this try celonis case does not show the studio area. Thanks and best regards,Sarina

8 months ago

daniel.riesLevel 3

asked in Process Analysis

How should the interaction between the new Studio and the Knowledge Model look like?

When I save PQL formulas in the new Studio, they are not assigned to a record as an attribute in the Knowledge Model, but each time as a KPI. Again, custom records and attributes are not displayed for selection in the new Studio.

8 months ago

divya.tiyyaLevel 1

asked in Data Ingestion & Infrastructure

Access the Order Management demo to answer this question.What are the top three late delivery root causes by case occurrence for customer Wallenquist Organization 11746?

Access the Order Management demo to answer this question. What are the top three late delivery root causes by case occurrence for customer Wallenquist Organization 11746?

8 months ago

manuel.wetzeLevel 4

asked in General Product Q&A

Trigger Machine Learning App on new data

Hi all,I need your ideas for architecture/approach on how to trigger a Machine Learning App every time a Datamodel is loaded.More specifically if there are new rows in a specific table. The Machine Learning App itself is also adding new data (to another table) and then reloads the model again. My initial ideas where: creating a Trigger + Action Flow.Trigger based on the table which is the input for my ML App. The Action FLow itself is similar to an offical Celonis Example which triggers the App via API.But this has following limitations: limit of 10000 which makes it tricky. Furthermore this triggers for every new row. I only want to run it once. Not thousands of times for each new row. Scheduling by time:I could also run the Action Flow or even the ML App directly via timeschedule and time it so that it is after sufficient time after my new data is fully processed.This however is more unreliable as the normal process of extracting source/Transformations/datamodel load might take long

8 months ago

koert.kritz11Level 3

asked in General Product Q&A

Hi all, I want to use a quick filter in views to set the range/scale of the x axis of my line chart. How do I do this?

8 months ago

denise.kruge12Level 4

asked in General Product Q&A

Good day, can someone please share with me the formula that is used in the PI Social to calculate the KPI "Users per case"

8 months ago

bunyod.sapLevel 4

asked in General Product Q&A

Is is possible to pass the changes of the Knowledge Model to another copy of it in the different Package or Space? Via the option dependencies I didn't manage to do it. Thanks for the hints!

8 months ago

michael.kaempLevel 3

asked in General Product Q&A

Can I use a runtime variable to change the dataModelId of a knowledge model?

I'd like to create a component (dropdown or checkbox), to switch between two data models (let's call them "test", and "prod"), that have the same structure but contain different data.I tried two ways:A runtime variable called "dm" holding the data model variable name. I used this in the knowledge model like this: dataModelId: §{{dm}}A runtime variable holding a boolean value (1 or 0) called "useProd". I used this like follows: dataModelId: §{{useProd==1?prod:test}}Both ways didn't work. Did I just do it wrong or is it impossible?

8 months ago

matt.slocu12Level 3

asked in Data Ingestion & Infrastructure

Share Data pools with other companies

I have a customer who also uses celonis. We would like to push them tables from our instance into theirs. Of course we could also make the raw tables available and they could extract them directly. But was assuming there was also a capability to share a data pool externally from my instance. Is that a possibility? I could not find any documentation on this...

8 months ago

bryan.carpeLevel 2

asked in General Product Q&A

How do I look at cycle time of mulitple events in my process. I want to know the cycle time of First Occurence of "Change" events 7 different events compared to the initial "Create" event. I can do this easily for each event but I want to look

8 months ago

michal.titlLevel 1

asked in General Product Q&A

Hi,is there is a way in Transformation center how to add a personal email as a recipient for email alerting? We don't need it for a long-term but we are having issues with showing the KPI charts in the emails and need to rule out potential causes.

Hi, is there is a way in Transformation center how to add a personal email as a recipient for email alerting? We don't need it for a long-term but we are having issues with showing the KPI charts in the emails and need to rule out potential causes.

8 months ago

conny.brintLevel 3

asked in Process Improvement

Import Github Backup via Content-Cli

Hello, We have developed a Github backup automation in the workbench based on this repo by @simon.klotz :https://github.com/celonis/pycelonis-examples/blob/main/pycelonis2/01_example_use_cases/01_use_case_version_control.ipynb The script was adapted to our needs so that analyses, knowledge models, variables, and transformations are assigned to the Celonis project and loaded directly into the corresponding Github repo as a backup zip. The next step is to test import the secured backups using content-cli.Is there a best practice for this?Which content-cli commands are there to upload the assets (analyses, knowledge models, variables, and transformations)? We only know of commands for pushing data pools and packages.Is there a way to import the zipped backup directly? I look forward to your contributions!Best regards,Conny

8 months ago

danelle.visse12Level 2

asked in General Product Q&A

Hi, can a horizontal scroll option be added to bar/area charts in Views?

8 months ago

koert.kritz11Level 3

asked in Process Analysis

Hi all, is it possible to make a dimension in a OLAP table static. So when I click on another dimension it does not affect the value?

8 months ago

Page 17 / 122

Badge winners

yuu.motokhas earned the badge Qualified to Create and Deliver Demos
emil.gospohas earned the badge Qualified to Build Analyses
kevin.wellshas earned the badge Qualified to Manage Implementation Projects
dan.morrihas earned the badge Qualified to Manage Change and Scale Adoption
susana.moren11has earned the badge Celonis Certified Data Analyst

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