Skip to main content

Ask the Community

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

1253 Topics
J
Level 3
jurgen.gakovLevel 3
asked in General Q&A
Chart with agglomerated dimensions from 4 different columns with the same options as values

Hello everyone,  Is there a function or possibility to combine four different columns with the same possible contents into a single dimension? These columns are dependent on other columns and only if the value in column A = X I want to read the value from column A2, otherwise not. I have inserted an example.Thank you very much! For example: Here i would like to build a column chart where the dimension is X (coming from A-D) and the KPI is a sum from column A2-D4 where a X was in A-B (everhting marked red) 

10
S
Level 1
M
Level 3
mpho.matheLevel 3
asked in General Q&A
Are there any use cases whereby Celonis was used before an orginisation implemented an ERP like SAP? In other words, how can an organisation use Celonis to prepare for SAP implementation?

Are there any use cases whereby Celonis was used before an orginisation implemented an ERP like SAP? In other words, how can an organisation use Celonis to prepare for SAP implementation?

00
K
Level 1
moritz.albre
Level 1
moritz.albreLevel 1
posted in General Q&A
Working Student (f/m/d) for Process Mining

Working Student (f/m/d) for Process MiningSiemens Healthineers We are #hiring 2 students interested in Process Mining and supporting in the development of the huge backlog of Process Mining use cases for Siemens Healthineers: Please apply here: Working Student (f/m/d) for Process Mining | Erlangen, Bayern, Germany | Siemens (siemens-healthineers.com) The Location is officially in Erlangen, but open to Home Office inside Germany. Feel free to contact me for any questions. Do you know anyone who might be interested? Thank you for forwarding and applying!

10
moritz.albre
Level 1
junwei.chai
Level 3
junwei.chaiLevel 3
asked in General Q&A
data change or display in Case Explorer views.

as I know that Case Explorer is extracting raw data from a data table and display. If I want to change the data that is display or view originally to other data for example the order is showing username but I want to change the way it display in the Case Explorer , what are the good practices that I can try?   Any advice or suggestion would be much appreciated.

60
junwei.chai
Level 3
R
Level 1
roza.kuszaLevel 1
asked in General Q&A
I cannot complete the Guided Learning Tours in the Celonis Academy in the second part of the Fundamentals course. Please find attached a screen shot that appears after I try to follow the "Create the Analysis Asset". Does Celonis work without ja

20
Lovise Hellner
Level 4
K
Level 3
kayla.ledbeLevel 3
asked in General Q&A
We are looking for a way to capture orders that are not shipping FIFO. Any ideas on the best way to tackle this use case?

We are looking for a way to capture orders that are not shipping FIFO. Any ideas on the best way to tackle this use case?

30
Moritz Klimmek
Celonaut
R
Level 1
rohit.kushw11Level 1
asked in General Q&A
Issue with csv file uploader

HI ,I am facing the issue with file uploading , when I have upload the csv file after that in map the data section there is no content visible for me . attaching the snap for the same. 

00
K
Level 1
enrico.pugli12
Level 3
enrico.pugli12Level 3
asked in General Q&A
Math problem (division)

Hello, I am trying to calculate a kpi that represents the number of average daily recallers (i.e., people who call more than once in the same day).The information is all in the same table, and I calculated the users (ID_Telefono) who for each day (ROUND_DAY(starttime)) made more than one call (UniqueID). The calculation was done with a CASE WHEN.To get the daily average, I divided the result by separate counts of the days available to me (ROUND_DAY(starttime)). (SUM (CASE WHENPU_COUNT(DOMAIN_TABLE("xcally_clean"."ID_Telefono", ROUND_DAY("xcally_clean"."starttime")), "xcally_clean"."uniqueid" )>1THEN 1END))/(COUNT(DISTINCT(ROUND_DAY("xcally_clean"."starttime")))) The problem is that the result is wrong. If I calculate denominator and numerator separately and divide them, I get 61, while if I leave the formulas on celonis, I get 142.There is no common table problem because all the information is on one tab

20
enrico.pugli12
Level 3
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
Celonaut
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

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

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

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

50
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

40
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

Badge winners

  • Qualified to Manage Change and Scale Adoption
    Tobias Fehrerhas earned the badge Qualified to Manage Change and Scale Adoption
  • First Post
    mccoolehas earned the badge First Post
  • Celonis Certified Data Engineer
    aparna.ajith11has earned the badge Celonis Certified Data Engineer
  • Qualified to Build Analyses
    suganya.balakhas earned the badge Qualified to Build Analyses
  • Qualified to Build Action Flows
    suganya.balakhas earned the badge Qualified to Build Action Flows
Show all badges
Terms & Conditions

ANY QUESTION?

Talk to an expert
FAQs
Contact us

MORE CELONIS

Academy arrow_outward
Documentation arrow_outward
Support Portal 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