Skip to main content

General Q&A

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

  • 1,203 Topics
  • 2,569 Replies
1203 Topics
S
Level 2
sachin.topul11Level 2
asked in General Q&A
Need to know how to find a common table . attaching a picture

Can any one help me to solve this issue? 

40
janpeter.van.d
Level 8
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Q&A
How to filter OLAP Table based on date?

I have a global date filter which pretty much is selection between a date period (Eg: - 01/01/2021 - 01/31/2021). This filter applies to my entire analysis when selected. However, I have an OLAP table where the columns are built upon formulas which include the use of DOMAIN_TABLE

60
M
Level 3
N
Level 1
nilay.tewar12Level 1
asked in General Q&A
The training track has a question: Which db objects can be added to Celonis Data model and View is not the correct answer. But in the exercise section it mentions that view can be added to a data model. What is correct

00
S
Level 1
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Q&A
If you have an OLAP table and you are trying to sort from lowest to highest based on a numerical column how do you remove the columns that appear as null values?

I have an OLAP table that is sorted by # of days (in screenshot named first). But I am trying to produced the same table, but in the format represented in the screenshot labelled as second.  Essentially I want the tables sorted from lowest to highest # of days and also removed the NULL (-) values associated with each client. I have rewritten the queries for each column to support PU functions and was planning to use a DOMAIN_TABLE for this purpose, but when I use the DOMAIN_TABLE within the component filter to remove nulls when ISNULL(...)=1 it still remains the same as first

50
M
Level 3
R
Level 1
ramki.ramanLevel 1
asked in General Q&A
Is there a duckcreek platform connector available with Celonis?

Looking for connecting Celonis EMS to DuckCreek Insurance platform... Is there a API library or connector available?

20
D
Level 1
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Q&A
How can I avoid null values from a 2 columns that I am trying to find the difference for?

I have 2 columns in which I am looking to find the difference for. Since some values of each column contain a null they are not reflected accurately for exampleColumn 1 Column2 Diff2 1 14 NULL NULL (should be 4)NULL 5 NULL (should be -5) I have the formulas associated with getting values in Column 1 and Column 2 within saved formulas as "KPI(.......)". My initial idea was to substitute NULL as 0, but when I surround KPI(...) with a CASE WHEN it fails saying that CASE is not supported with INT or STRING Any ideas?

20
M
Level 3
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Q&A
I am looking to get a basic difference between 2 columns?

Column 1 has values where the KPI is as such for a company 1 (after clicking calculate shares in percentage checkbox):SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))  Column 2 has values where the KPI is as such for a certain company 2 (after clicking calculate shares in percentage checkbox):SUM(Days related to certain case numbers)/COUNT(DISTINCT (No. of cases))  Column 3 has the difference Based on what I saw the values for column 1 and 2 are read in correctly, but the difference in column three is wrong Any suggestions on this would really be appreciated

70
M
Level 3
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Q&A
How to get percentage value of happy path (most common variant)?

I am trying to get the percentage value of the no. of cases in a happy path by dividing by the total no. of cases for that process and display in a single KPI. Any suggestions/formulas on how I can do that?

10
joos.buijs
Level 6
T
Level 2
tobias.lalli11Level 2
asked in General Q&A
Simulate different process variations

Hello everyone, the goal for my master thesis is to analyse and simulate different process variations. After identifying weak points, the process should be adapted and a simulation should take place. Is it possible to simulate different process variants in the academic version of celonis?  Thanks in advance!

20
T
Level 2
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Q&A
How do you divide each element of a column that has been counted in an aggregated manner (PU_COUNT) with the sum of the same column?

I tried something along the line of( PU_COUNT(target_table, source_table.column))/SUM(PU_COUNT(target_table, source_table.column)) But I got an error saying:"The aggregation function SUM cannot be used together with a dimension function input. Please check that there are no aggregations and dimensions used together as function inputs"

370
janpeter.van.d
Level 8
Z
Level 1
zeb.khan13Level 1
asked in General Q&A
Error when trying to create Data Pool in event collection

I have been trying to carry out the data engineer course and in when doing the "Access Source System" step in the Process Connection basics, it tells me to go onto the event collection page and create a data pool. However, an error appears in the bottom left corner as shown below  

10
D
Level 1
.
Level 1
.146001019Level 1
asked in General Q&A
Is there any way that I can use data from multiple data models in single analytics?If yes, Could you please guide me through it?

I have currently one data pool where I have 3 Data models. I want to use data in O2C and P2P together. How do I make it possible. please see both data models attached. Is there any additional information that you might need? I want to be able to use data in VTTK/VTTP tables together with P2P.

20
D
Level 1
.
Level 2
.146001036Level 2
asked in General Q&A
Why would Celonis throw errors saying there are multiple empty cells in my columns when there aren't any?

Hello All, I have a csv file (attached a screenshot of the same) which has the Case ID (column A), Activity (Column N) and the Timestamp (column O) in the correct format. There are also other columns in the file that I will be using for my analysis. The error (screenshot attached) says that there are more than 100 empty cells within the Acitivity, Timestamp and CaseID columns but I have double-checked and can confirm that, that is not the case. Has anyone experienced this before? What could be the issue over here?  This is an urgent matter so any quick responses would be much appreciated! Thanks!@1460045682​ ,@joos.buijs​ , @hugo.victo11​ 

20
.
Level 2
.
Level 2
.146001098Level 2
asked in General Q&A
Hello everyone, Can someone please share details of week one courses?

Hello everyone, Can someone please share details of week one courses?

10
.
Level 2
L
Level 1
lars.reinkLevel 1
posted in General Q&A
Screenshot 2021-06-24 at 13.53.33

MasterplanWhile CoEs are the key accelerator to drive success, daily work might drag you too much into process- and technical discussions. In order to drive sustainable Value a CoE should keep an eye on five complementary streams. The following one pager can be used as template for discussing and managing all relevant streams.Hope it helps, keen to get your views

10
L
Level 1
P
Level 2
paresh.gandhLevel 2
posted in General Q&A
Hi Team -

Hi Team -  I am working on developing a business case to develop a business case at my company. I want to show the value and the business benefits exist in developing a CoE. I understand the value and have a vision on what I want to accomplish with a CoE. Does anybody have a business case or presentation I can leverage in developing a business case to our leadership to getting a CoE established? Any other feedback is greatly appreciated.Best,Paresh

04
L
Level 1
G
Level 1
greg.zajacLevel 1
posted in General Q&A
your-team-name.realm.celonis.cloud

Hello, Celopeers! This is my first attempt at what will (hopefully) evolve into a series best-practice forum posts. If you have any questions about anything I share here, please do not hesitate to ask. I also encourage you to follow along with this post, so please log in to the EMS! In my four years here at Celonis, I've asked (and have been asked) many, many questions about our platform and its capabilities. The top 5 questions I've seen (and continue to see) asked are: Can we establish a connection to source system ABC-123? How do we do this? Is there a step-by-step guide?How can we manage access to our team? Is there a step-by-step guide to setting up SSO?Do we have a PQL function that can do XYZ? Are there examples of function input and output?What are our options for editing a specific component in our analysis?What features of the Celonis EMS are currently available? Can you tell us about them? I'm happy to say that the answers to these questions (any many more which

60
G
Level 1
thorsten.schne
Level 3
thorsten.schneLevel 3
asked in General Q&A
KPI - Variable - Limit Characters of Expression

Hi everyone, I created a Chart and face the problem that the expression of the KPI does not fit into the tooltip.   Option 1: Is there a setting to change the size of the tooltip box? Option 2: Alternatively I wanted to limit the characters of the variables. Could you help me to insert a LEFT or RIGHT statement? My syntax does not work. <%= MyVariable %> --> Full text is shown<%= LEFT(MyVariable,10) %> --> Only show the left 10 characters

00
thorsten.schne
Level 3
thorsten.schne
Level 3
thorsten.schneLevel 3
asked in General Q&A
Syntax - Replace "FIRST_OCCURRENCE" with a variable

Hi community,  I created a dashboard and would like to use a variable so that the end-user can easily switch between first-to-first // first-to-last occurrences. Could you help me with getting the syntax right. Thank you!

40
thorsten.schne
Level 3
A
Level 2
alberto.genov11Level 2
posted in General Q&A
Is it possibile to receive commercial deck and presentation in Italian?

Is it possibile to receive commercial deck and presentation in Italian?

00
A
Level 2
L
Level 1
lars.reinkLevel 1
posted in General Q&A
CoE @ Roundtable 110521

Anbei die heute bei unserem virtual cocktail gezeigten Folien zu CoE

00
L
Level 1
S
Level 1
sam.abornLevel 1
asked in General Q&A
Balancing Centralization and Decentralization

Organizations sometimes have a distributed model of process improvement for example there is a central business strategy team and there is also a decentralize line of business operations improvement. who has figured out how to balance this duplication of capability when both want to use process mining and use 2 different tool sets?

00
L
Level 1
salma.zeped
Level 4
salma.zepedLevel 4
asked in General Q&A
How to manage standardization and quality control when you support the self-service approach for users to create their own analyses? Besides, offering established templates for it.

After viewing the "Thought Leader Panel: Managing Real Organizational Change: The New Center of Excellence on CoE" I wonder: How to manage standardization and quality control when you support the self-service approach for users to create their own analyses? Besides, offering established templates for it.

00
L
Level 1
L
Level 2
liz.morto12Level 2
asked in General Q&A
What specific Use Case does Celonis provide for FSI?

What specific Use Case does Celonis provide for FSI?

70
B
Level 2
L
Level 1
lars.reinkLevel 1
posted in General Q&A
Did you know that 71% of our strong customers gave us feedback that they have a CoE in place? CoEs are a crucial driver when it comes to spreading EMS across an organisation.

Did you know that 71% of our strong customers gave us feedback that they have a CoE in place? CoEs are a crucial driver when it comes to spreading EMS across an organisation. What are your experiences?

11
N
Level 3

Badge winners

  • Qualified to Build Views
    tasavhas earned the badge Qualified to Build Views
  • Qualified to Build Views
    thom.dalen12has earned the badge Qualified to Build Views
  • Qualified to Build Views
    sudha.kashyhas earned the badge Qualified to Build Views
  • Qualified to Build Views
    simran.tagrahas earned the badge Qualified to Build Views
  • Qualified to Build Views
    shubham.varshhas earned the badge Qualified to Build Views
VIEW ALL
Community Code of Conduct