Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4437 Topics
J
Level 3
jurgen.gakovLevel 3
asked in General Product Q&A
Is it possible to count the comments made in a Proifile View (via the comments component) and show the amount in column of a table in the base view?If yes, where do I get the value from?Thank you!

11
V
Celonaut
herique.sarme
Level 3
herique.sarmeLevel 3
asked in General Product Q&A
How do I show data labels in views for the axis that I so desire?

I'm trying to plot a simple vertical bar chart with it's labels displayed above each bar, but I can only plot it horizontally the way I want, otherwise the wrong information goes into display... Any idea how I may overcome this? This is what I have at the moment:And this is what happens when I swap its axis:How should I write the YAML marks and encodings to sort this out? 

93
V
Celonaut
H
Level 3
himanshu.sharm16Level 3
asked in General Product Q&A
Transitions for Multiple Event Logs

Hi, I have an eventlog, with two IDs: JR ID and App ID. JR ID is always present, whereas App ID is only present in certain activities. The relationship between JR ID and App ID is 1:N. I have created a new ID as a combination of both, to use as my case ID for the eventlog. Then i created 2 eventlogs within Celonis using simple formula:  EL_APP:CASE WHEN "Eventlog"."APP ID" is NOT NULL then"Eventlog"."ACTIVITY"end EL_JR:CASE WHEN "Eventlog"."APP ID" is NULL then"Eventlog"."ACTIVITY"end The idea behind is to show a transition between both newly created eventlogs. Sadly, Celonis doesn't find any common ground for transition and both the eventlogs are shown without any transition. So my questions is: On what basis does two eventlogs create a successful transition? What am i missing here? Sadly this link doesn't help me with my investigation. https://docs.celonis.com/en/process-explorer.html#UUID-fa936c2

121
D
Level 1
karol.trzci12
Level 3
karol.trzci12Level 3
asked in General Product Q&A
Coloring bar chart based on selections from a variable.

Hi, I have a following conundrum that I'm trying to resolve. In studio analysis I have a tab in which I have two Button dropdowns. First one is for selecting a categories like company code, business unit, country etc. Based on selection from the first dropdown users can select specific company codes or BUs etc. in the second one (this drop down is a multiple choice one). That selection is stored in a variable which feeds the bar charts. So for example someone is selecting 4 company codes and my chart shows bars for each company code selected for each month. In a basic form all bars are the same color. I would like to color it the way that each selection from second dropdown (i.e each cmpany code) has its own color. I cannot use series palette as user can select from 1 to n number of company codes (or BUs or countries etc.) so the number of colors needs to be automatically adjustable. The original idea was as following - lets create 5 to 10 variables and each would take one value fr

101
D
Level 1
anusuya.ponnu
Level 3
anusuya.ponnuLevel 3
asked in General Product Q&A
Hello Team, Is it possible to add styles using Custom Objects for view component "Textbox". It seems there is no Custom Objects property allowed in Textbox.

Hello Team, Is it possible to add styles using Custom Objects for view component "Textbox". It seems there is no Custom Objects property allowed in Textbox.

41
D
Level 1
P
Level 1
pranjali.bhattLevel 1
asked in Data Ingestion & Infrastructure
Hi, I'm unable to upload dataset in in the tool, ERROR- Remote application onhttp://integration/integration/api/internal/data-pools/data-models/655b7a20-e1d7-4c50-b4d6-328a000bb992/load-info-sync[GET]responded wi

Hi, I'm unable to upload dataset in in the tool, ERROR- Remote application on http://integration/integration/api/internal/data-pools/data-models/655b7a20-e1d7-4c50-b4d6-328a000bb992/load-info-sync[GET] responded wi

01
B
Level 1
D
Level 4
douglas.henriLevel 4
asked in General Product Q&A
Data Model Best Practices

Hello everyone, I would like to understand what are the best practices when developing a business case.Example the Celonis team built for the company I am in todayA single data model for 4 different fronts. They share the same ERP (SAP), but I find it difficult to maintain and develop new cases and tables because of this.Is it ideal to have a Data Model for each business front? Or is this shared model common among other companies?

51
B
Level 1
J
Level 2
jose.tamoLevel 2
asked in General Product Q&A
Having more than one activity table in the same data model

I see that there can be more than one activity table in a data modelAre there any examples on how to use this feature and the impact when creating variant components or process explorer in the analyses?I have a need for more than one activity table.Just pointing me toward the right document (detailed) or training module is enough for me to understand when and how to use that. Thanks

62
abhishek.chatu14
Level 7
G
Level 1
gayatridevisaikumari.mekal13Level 1
asked in General Product Q&A
Access the Order Management demo to answer this question.How many cases are covered by the five most common variants.A.734,890B.988,000C.404,562

Access the Order Management demo to answer this question. How many cases are covered by the five most common variants. A. 734,890 B. 988,000 C. 404,562

361
M
Level 1
A
Level 1
alina.leahu11Level 1
asked in General Product Q&A
Is there any posibility to create pivot on a column?

I need to split the column by a separator in to multiple columns and then unpivot them to rows.

31
H
Level 1
B
Level 3
bhupendra.singh.thakuLevel 3
asked in General Product Q&A
How to upload files in SFTP bucket created during Storage Manager Set up?

How to upload files in SFTP bucket created during Storage Manager Set up?

112
B
Level 3
Y
Level 1
yeshwanth.yadav.govu11Level 1
asked in General Product Q&A
Did any one use CDP data Connection?

One of my project is having CRM data connection and client migrating the source, they are going to store the data in CDP Cloud.I couldn't found anything related to CDP in Celonis documentation.Is there any Prebuilt apps available in Celonis, if not what to do? please help.

11
K
Level 1
S
Level 1
simmei.choLevel 1
asked in General Product Q&A
How to uninstall Celonis agent without leaving data

How to uninstall Celonis agent without leaving data

11
M
Level 1
J
Level 3
jack.everaLevel 3
asked in General Product Q&A
Is it possible to count only cases that has reached an activity, but exclude all others that has reached the same activity and then moved on to the next activity?

We are trying to only display invoices that are currently in verification and then calculate how long its been in verification for, but we cant find a suitable function for it.  Any help would be greatly appreciated

32
J
Level 3
S
Level 2
sean.langLevel 2
asked in General Product Q&A
Is ROUND_MONTH("PurchLines"."CREATEDON_MST") the norm to use when creating trend analysis (Chart)? I am getting unexpected results when I use that as a dimension when I am just trying to determine the number of Open PO's by month.

Is ROUND_MONTH("PurchLines"."CREATEDON_MST") the norm to use when creating trend analysis (Chart)? I am getting unexpected results when I use that as a dimension when I am just trying to determine the number of Open PO's by month.

01
M
Level 1
A
Level 3
abhinav.singa11Level 3
asked in Data Ingestion & Infrastructure
Formation of temporary Domain table when we specify multiple tables that are with N- 1relation with other tables in the data model.

In the given data tables below -  I used the statement - 'PU_SUM ( DOMAIN_TABLE ( “Chapters”.” Title”, “Book_Author_Mapping”.” Book ID” ), “Chapters”.” Number of Pages” )' Here I have a couple of questions in understanding the functionality:- If the Domain Table is formed based on the specified column/tables - To which Specified Table will the Damon Table be linked to? - as both the tables 'Chapters and Book_Author_Mapping' have an N:1 relationship with other tables?Will the Domain table link to the 'specified tables - Chapters; Book_Author_Mapping' based on the Table we mention in the SourceTable?Column field of PU_X Functions -i.e. “Chapters”.” Number of Pages” in this case ?'  Thanks in Advance. Kind regardsAbhinav

143
M
Level 1
C
Level 3
conny.brintLevel 3
asked in AI
How can I pull an OLAP table into the ML bench?

Hi there,I would like to pull an OLAP table component out one analysis sheet into the ML bench If I try this way by ID it works:components = sheet.componentscomponent = components.find_by_id('Component_ID_Here') But I would like to import the table by name as the component ID might change.So I tried this but it does not work.:components = sheet.componentscomponent = components.find('Table_Title_Here') Hope you can give me a hint. Best,Conny

92
C
Level 3
L
Level 3
lennart.bruns12Level 3
asked in General Product Q&A
How to use dynamic column names (Current Date - YYYY/MM) ?

Hey Celopeers, I want to create a Table within a View wihich contains 4 columns. One Column is the Dimension Column (Gives 15 Rows). In one column the numer of invoices for the current month are counted. In the other column the number of invoices from the previous month and in the last column the number of invoices for the month before last.  The user want to have the coulmn names in the format "YYYY/MM" and the column names should be dynamic, so that in the new month the column names are updated automatically. We are using the Knowledge Model - View Technology and no analysis. I also thought of using a chart diagramm, but the users require a table. I tried some things, but nothing worked. So if somebody knows about how to create dynamic columns I would be very thankful for your help :D  

368
jan.vajse12
Level 3
A
Level 2
alex.giorgLevel 2
asked in General Product Q&A
Why, in Industry Wheels Charts, some processes are in bold and others no? What does it mean?Thanks

Why, in Industry Wheels Charts, some processes are in bold and others no? What does it mean? Thanks

51
M
Level 1
T
Level 2
tamano.inoueLevel 2
asked in General Product Q&A
alert with smartsensor

Hello.I was wondering, is the ability to set alerts from SmartSensor no longer available?The official site has a screenshot of SmartSensor with the CreateAlert option, but the option does not exist on the actual EMS. https://docs.celonis.com/en/create-alerts.html

11
T
Level 2
A
Level 4
akshay.haridLevel 4
posted in AI
Hi All,

Hi All,I wanted to share an issue with you guys regarding the ML app we had in our server in which the app was automatically changing it's python package versions despite of whatever desired versions of python packages we install. Then we figured out that if the ML app had a file named virtual environments and in it's metadata if the versions are already set , no matter what ever desired versions of python packages we install it automatically changes it's version to the one mentioned in the metadata of that virtual environment. The reason for this is that the workbenches where virtual environments were used usually become corrupted and inaccessible. Files will not be recoverable if a workbench is corrupted.  The only way of resolving this issue is creating a new ML app and backing up the files in the current workbench (Excluding the virtual environments) and restoring them to a new workbench. This will ensure your data is protected from possible corruption. For more inf

61
A
Level 4
M
Level 1
mudaga.pooji11Level 1
asked in Data Ingestion & Infrastructure
How many cases are covered by the five most common variants.

How many cases are covered by the five most common variants.

12
K
Level 2
A
Level 2
akash.suhag11Level 2
asked in General Product Q&A
FILTER ANALYSIS VIA ACTION ENGINE ACTIONFILTER "BKPF"."BELNR"=${Document Number}ERROR:Operator requirements are not met. Comparison operator = (equal) does not support comparing column ["BKPF".BELNR"] of type [STRING] with constant of type [CONS

FILTER ANALYSIS VIA ACTION ENGINE ACTION FILTER "BKPF"."BELNR"=${Document Number} ERROR:Operator requirements are not met. Comparison operator = (equal) does not support comparing column ["BKPF".BELNR"] of type [STRING] with constant of type [CONST_INT]

31
dennis.pflug
Level 6
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
Where can i find "data Job execution failed" mail setting

Hi all,  I'd like to find where can i add the subscription setting when I failed my data job.I haven't activate data job alerts setting but some of user getting the mail notification. (It might be user private setting but I cant find it.) Thx

63
dennis.pflug
Level 6
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Process Improvement
Can Action Flow retrieve data from a OLAP table in an Analysis?

We are working on a use case where we need to extract the data from an OLAP table and push it to another data pool. We are aware of the later part but need some inputs for the former one where we need to extract the OLAP table using action flows .

288
A
Level 3

Badge Winners

  • First Post
    manohar.sairahas earned the badge First Post
  • Masterclass in Implementation
    alvaro.illanhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    WR_SNhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    menka.krishhas earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    Namit Singhhas earned the badge Masterclass in Implementation
VIEW ALL
Community Code of Conduct