Skip to main content

Ask the Community

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

1245 Topics
S
Level 3
sachin.agarwLevel 3
asked in General Q&A
what is the difference between package variables and runtime variables and what would be best use case to use them?

what is the difference between package variables and runtime variables and what would be best use case to use them?

00
R
Level 1
S
Level 3
samuel.delmo12Level 3
asked in General Q&A
I want to put a Variant Explorer in a view.

I saw there is not a option for that, so I am trying make one. I want a chart with the most common variant but i don't know how transform the list of variants in a list with the most common variant.  I was trying to filter the variants making this KPI that permit "filter" with a second KPI .CASE WHEN COUNT(VARIANT ("BD_ACTIVITIES"."QUEUE"))> 186 THEN 1 ELSE 0 ENDThe secon KPI:Case WHEN KPI("variant_most_common") = 1 THEN KPI("PROCESS_VARIANTS__BD_ACTIVITIES__QUEUE") ELSE 'OTHER' ENDBut it gives me this error : The aggregation function COUNT cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs.Right now i don't have more ideas to can continue. I dont know if someone could help me.  

40
S
Level 3
B
Level 3
bhupendra.singh.thakuLevel 3
asked in General Q&A
Team,I used ABAP script to extract data from SAP s4/HANA system and extracted data.While execution of the transformation script: Add Activity: Record Goods IssueERROR: Column VBFA_GI.ERDAT does not exit.

Please clarify why column ERDAT is not included in standard ABAP script but it is selected in standard transport script.  1)     Add Activity: Record Goods Issue-- ERROR: Column VBFA_GI.ERDAT does not exist.  CAST("VBFA_GI"."ERDAT" AS DATE) + CAST("VBFA_GI"."ERZET" AS TIME) AS "EVENTTIME"                                  INSERT INTO "_CEL_AR_VBFA_ACTIVITIES FROM VBAK, VBFA, LIPS, LIKP, VBFA, VBFA, VBRP, VBRK, AR_BKPF_BSEG, USR02, MATDOC Table Name(VBFA): Sales Document FlowERDAT: Date on Which Record Was Created              ERZET: Entry time

140
B
Level 3
junwei.chai
Level 3
junwei.chaiLevel 3
asked in General Q&A
in Case Explorer the details for column "Created By" is displaying username, but I want to display it as this case is an automated but not by user. How should I change the way it display? Appreciate any guidance.

in Case Explorer the details for column "Created By" is displaying username, but I want to display it as this case is an automated but not by user. How should I change the way it display? Appreciate any guidance.

00
V
Level 1
ミ
Level 1
ミントアン.ファムLevel 1
asked in General Q&A
Full loads performed successfully but Delta loads failed?

Hi expert, I have a question regarding Delta loads. I've been using a data connection from AWS RedShift to Celonis. Before performing both the full loads and delta loads, I copy the target table, rename, and re-tied to perform Full loads and Delta loads. The full load consistently succeeds, but the delta load encounters issues. Here's the error message for the a_size_result table:Datatype of the column size_l changed from FLOAT to STRING.Table won't be delta loaded. Please perform a full load instead.When I reviewed the delta load log, I noticed that there was a change in the metadata for the 'ds_if_scm$_CELONIS_a_size_result' table.After full loads the data, I checked the data type in RedShift (String) and the Celonis Data Pool (Varchar). Could an expert please explain why this error occurs during delta loads? Thanks,

80
V
Level 1
A
Level 4
akshay.haridLevel 4
asked in General Q&A
Can anyone suggest the best way to use the full capabilities of the Machine Learning workbench

Can anyone suggest the best way to use the full capabilities of the Machine Learning workbench

10
A
Level 4
C
Level 1
chetan.sakhaLevel 1
asked in General Q&A
Hi, I want build a POC of any process in Celonis EMS..But for that I will require dummy data. Anybody knows how should proceed ? or Can you please help me to get the dummy data.Thank you

Hi, I want build a POC of any process in Celonis EMS..But for that I will require dummy data. Anybody knows how should proceed ? or Can you please help me to get the dummy data.Thank you

10
mateusz.dudek14
Level 7
.
Level 1
.14626201Level 1
asked in General Q&A
Where can I find all the reading material (ppts, pdfs) and templates provided by Celonis ?

Where can I find all the reading material (ppts, pdfs) and templates provided by Celonis ?

40
M
Level 1
R
Level 2
rosen.spartLevel 2
asked in General Q&A
SCIM connection to AD not working properly.

Recently we decided to activate the SCIM functionality in Celonis so that user and groupsare provisioned automatically by the identity provider. Unfortunately it is not working and no connection to the Active Directory can be established and the functionality is not working. Are there any specific settings that need to be set in the Active Directory so that SCIM API can work as intendet?

20
L
Level 1
E
Level 2
elen.groch13Level 2
asked in General Q&A
Overwrite assets using Content CLI

Team, I am using Content CLI to Pull and Push assets between different EMS. Is there a way to overwrite only one asset when pushing to a different EMS? I can see there is an option to overwrite packages with "--overwrite", but we want to push only one asset multiple times. Best regards!

40
E
Level 2
D
Level 1
douglas.oliveLevel 1
asked in General Q&A
Get Data into EMS Exam tells me I have "One remaining attempt" however, I haven't failed any exams yet.

Hello, I tried to start the Get Data into EMS partner exam today and it stated I only had one attempt remaining. As far as I am aware we are supposed to have 2 attempts. Is this message showing because the attempts are counted as "1" and then "0" remaining?  Or is it because I passed the "Build Analyses" exam earlier today and I was supposed to wait a little bit more?

10
H
Level 1
J
Level 3
jurgen.gakovLevel 3
asked in General 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!

10
V
Level 1
herique.sarme
Level 3
herique.sarmeLevel 3
asked in General 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? 

30
V
Level 1
karol.trzci12
Level 3
karol.trzci12Level 3
asked in General 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

50
D
Level 1
D
Level 4
douglas.henriLevel 4
asked in General 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?

20
B
Level 1
J
Level 2
jose.tamoLevel 2
asked in General 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

10
abhishek.chatu14
Level 7
A
Level 1
alina.leahu11Level 1
asked in General 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.

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

How to uninstall Celonis agent without leaving data

00
M
Level 1
A
Level 2
alex.giorgLevel 2
asked in General 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

50
M
Level 1
S
Level 3
sachin.agarwLevel 3
asked in General Q&A
Hi,In TryCelonis, I could see lot of Demos. But I would like to see the YAML code behind those dashboards. Please let me know how can i see them?

Hi, In TryCelonis, I could see lot of Demos. But I would like to see the YAML code behind those dashboards. Please let me know how can i see them?

10
S
Level 3
P
Level 3
pedro.pinedLevel 3
asked in General Q&A
Hello,I want to do Proccess Benchmarking, I have the dropdown button created with manual values (with three dimensions), I have created the appropriate variables, but I can't filter the categories to compare.

120
P
Level 3
N
Level 2
nuran.khala11Level 2
asked in General Q&A
Hello guys, i would like to put a drop down in my reports with the opportunity for the users to switch between light and dark mode. How do I do that? Has someone practice in this topic? Maybe a pql code or something...

Hello guys, i would like to put a drop down in my reports with the opportunity for the users to switch between light and dark mode. How do I do that? Has someone practice in this topic? Maybe a pql code or something...

10
N
Level 2
W
Level 1
weiwei.dongLevel 1
asked in General Q&A
What functions can Celonis achieve

What functions can Celonis achieve

00
H
Level 1
anusuya.ponnu
Level 3
anusuya.ponnuLevel 3
asked in General Q&A
How do we populate the benchmarking components with the default value if none is selected in the dropdown button.

I have one Main button dropdown to select dimensions(dimension 1 and dimension 2). There are two other different button dropdowns (First and Secondary Category) to retrieve values from the main Dimension for benchmarking purpose. When I select dimension 1 as main dimension and even before selecting the First Category, the process explorer and the other Single KPIs displays empty. Is there any way to populate default values even before selecting the dimensions. Please see attached for more information.

50
P
Level 3
G
Level 1
gulshan.mishr13Level 1
asked in General Q&A
how can we write a Pql Statement to count the total cases which passing through the Activity

how can we write a Pql Statement to count the total cases which passing through the Activity

40
Z
Level 3

Badge winners

  • Qualified to Build Action Flows
    guy.hunt11has earned the badge Qualified to Build Action Flows
  • Qualified to Manage Implementation Projects
    guy.hunt11has earned the badge Qualified to Manage Implementation Projects
  • Qualified to Identify and Drive Opportunities
    guy.hunt11has earned the badge Qualified to Identify and Drive Opportunities
  • Qualified to Prove Celonis Value
    guy.hunt11has earned the badge Qualified to Prove Celonis Value
  • Qualified to Write PQL Queries
    guy.hunt11has earned the badge Qualified to Write PQL Queries
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Center arrow_outward
Partner Portal arrow_outward
Marketplace arrow_outward

CHECK US IN

LinkedIn
YouTube
Instagram
Facebook
Imprint
Disclaimer
Privacy Notice
Cookie Notice
Terms and Conditions
Celonis © 2025