Skip to main content

Product Q&A

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

4382 Topics
D
Level 2
daniel.nLevel 2
asked in Data Ingestion & Infrastructure
How do I efficiently reduce the size of my data model?

Hi there,I am looking for an efficient way to reduce the size of my data model: I already reduced the time period of the ingested data. As a second step I want to get rid of some unused table columns. To identify unused table columns I thought about doing the following:Export a .txt documentation of each analysis, then search for a specific table (ctrl+f) (i.e. LIPS) and document which columns are really in use in this analysis. I do this with all analyses and then I know which columns I can exclude in the extractions because they are not used anywhere.  It's not as much manual work as it sounds but still a lot. Do you know a better way to do this? How do you avoid such work in the future? Is there a standard procedure how to handle this problem or not run into it in the first place?  Thanks for your helpDaniel  

30
janpeter.van.d
Level 8
T
Level 1
torben.arndtLevel 1
asked in General Product Q&A
Is it possible, that I have a C4C+ project, which is only available over an VPN? And if yes, how can I set up this connection? Are there any technical specifications?

Is it possible, that I have a C4C+ project, which is only available over an VPN? And if yes, how can I set up this connection? Are there any technical specifications?

20
janpeter.van.d
Level 8
R
Level 3
roan.schuu13Level 3
asked in Process Analysis
Does anyone know how I can create a histogram in a view?

Does anyone know how I can create a histogram in a view? In the standard analysis sheet it is out-fo the box available but not in views. Or a way how I can create 'ranges' of a dimension?  

200
G
Level 8
A
Level 3
arunangshu.paul11Level 3
asked in General Product Q&A
Access to Celonis Sanbox

How can I get access to Celonis Sandbox? I did not get any mail from no-reply ID after registering to the client portal

450
S
Level 2
A
Level 3
amina.mrad12Level 3
asked in Data Ingestion & Infrastructure
Event Processing Rules

Hello community, we are trying to create a task mining use case but we struggle with the event processing rule  Could you please support with the following: Process start should be only be triggered when the URL = a specific URL Process end should be always when an email is sent When another URL than a specific URL is used then task mining should not capture that informationSee screenshots attached of how the event processing rules are being configured.  

10
L
Level 1
.
Level 3
.146012012Level 3
asked in General Product Q&A
Cannot Connect to Data Model on ML workbench

Cannot Connect to Data Model on ML workbench

130
.
Level 3
irfan.suria12
Level 4
irfan.suria12Level 4
asked in AI
Which permissions does an application key need in order to access the objects in Studio (Views, analyses, etc.)?

I have given my App Key the following permissions:Space permissions: Use all packagesPackage permissions: Use packageAnalysis permissions: UseData Pool permissions (of the analysis): Use all data models celonis.spaces.find("Space123") works nicely, but then space.pockages will return an empty list. Consequently, space.packages.find("Analysis123") would not work. Which permissions do I miss? Cheers

50
D
Level 1
A
Level 1
anshul.khandLevel 1
posted in General Product Q&A
Hello!

Hello! For a project we want to embed a Celonis dashboard in our own website. I am looking for the best way of doing this. For example with Power BI we were able to embed a dashboard using a iFrame and were happy with the results. Is it possible to embed Celonis using iFrames as well? Or is there an other solution with similar results? Any leads are more than appreciated! Regards,Anshul

01
G
Level 8
.
Level 3
.146003919Level 3
asked in General Product Q&A
Hi,I am facing a problem in "Simulation Configuration Wizard" in Celonis.

While filling up the Simulation Parameter "Even Time start", I am getting an error as "The Event time start column is the same as the Event time-end column (as defined in the data model). Please select a different column or leave empty if the start times are not available." 

00
.
Level 2
A
Level 2
anuraag.pandeLevel 2
asked in General Product Q&A
Is there a use case highlighting the process of analysis Servicenow ticket dump?Kindly help :)

Is there a use case highlighting the process of analysis Servicenow ticket dump? Kindly help :)

00
A
Level 2
C
Level 3
claire.chen12Level 3
asked in General Product Q&A
Monthly data job - how to schedule it using CRON?

In order to run a MLWB program on the last Sunday of each month, I want to use custom cron to setup it but I don't know how to write the wildcard. Could you help me? Yours,CLaire

130
C
Level 3
T
Level 2
tanmyi.mLevel 2
asked in General Product Q&A
Can a person change the account registered as STudent to 'as a Partner'?

Can a person change the account registered as STudent to 'as a Partner'?

20
D
Level 1
A
Level 2
alexandra.koschLevel 2
asked in General Product Q&A
Hello,I am trying to define a new indicator for Process Explorer: This is supposed to be a rate that simply represents the number of cases that have taken one process route or another. My problem is denominater.

For example, there are two outcomming nodes (B with 25 cases und C with75 cases) from a node A (100). So I am trying to get 25% and 75% :).  Do you have any ideas , how to calculate the denominator?

55
G
Level 8
H
Level 2
harun.yeniaLevel 2
asked in General Product Q&A
i want to use conditional filter Null values in "load script" section by "Case When "

Hi @ALL i try to do smth like this. one dynamic filter should execute the NULL values in the table. FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN NULL END; all other filters work but i cannot return null values from the same table. I have tried this formula  FILTER "table". "column" = CASE WHEN <%=option1%> = 'abc' THEN Filter_TO_NULL("table". "column") END; but when i have tested, i realized that i did bring up all values but not Null values from table. Does anyone have an idea?

80
T
Level 1
satoshi.omach12
Level 3
satoshi.omach12Level 3
asked in Data Ingestion & Infrastructure
Could you teach me will a two-way connection occur between the On-premise Extractor and the EMS Data Integration?

Could you teach me will a two-way connection occur between the On-premise Extractor and the EMS Data Integration?

00
L
Level 1
T
Level 3
takayoshi.ichikLevel 3
asked in Data Ingestion & Infrastructure
Activity count and Connection count in one OLAP table

Dear Community, I'd like to make a OLAP table that have Activity count and Connection count.  Is there any way to make this OLAP table? Thank you. Best regards,Takayoshi Ichikawa 

30
T
Level 3
A
Level 3
antoine.leducLevel 3
asked in General Product Q&A
Hello,I am trying to modify an Action Flow by adding a column to the final result which is a Gsheet file in shared drive but although the query seems modified in the Action Flow, the final resultat in the Gsheet is not. I have save and published.

Hello, I am trying to modify an Action Flow by adding a column to the final result which is a Gsheet file in shared drive but although the query seems modified in the Action Flow, the final resultat in the Gsheet is not. I have save and published.

00
R
Celonaut
P
Level 4
preethi.p12Level 4
asked in General Product Q&A
How can I group the count of activities in a particular hour to count as 1?

Need help woth pql code. For example, in a particular 1 hour the count of activity is 89 or 56 or 05, then that count has to be considered as 1 How can I achieve this? ​

33
G
Level 8
R
Level 3
roan.schuu13Level 3
asked in Process Analysis
What does the following: #{development} and where can I configure it?

I have installed the O2C app on S4. This app has no KM/views but analysis. In the analysis there sort text variables like #{development}. I thought I read something about this but don't know anymore how this works. cannot find it in the help as well.

00
R
Level 3
.
Level 1
.1460066766Level 1
asked in Process Analysis
How can I export Duration column in Case Explorer in days, instead of seconds?

Hello all, When exporting Case Explorer sheet to an xlsx file, the Duration column comes as seconds, despite showing in days when viewing on browser. So the viewers keep asking what this value is, is it possible that Duration column shows in days after export? Regards, and thanks in advance. 

20
R
Celonaut
G
Level 2
gareth.johnLevel 2
asked in General Product Q&A
I have been provided data in a parquet file, and the activity names are quite long and verbose. What's the best approach to editing the activity names to make them more intuitive/user friendly?

I have been provided data in a parquet file, and the activity names are quite long and verbose. What's the best approach to editing the activity names to make them more intuitive/user friendly?

10
G
Level 8
.
Level 4
.146004319Level 4
asked in General Product Q&A
Possibility to show a KPI from an OLAP Table 1 in another OLAP Table 2

I am revisiting this issue because my new approach did not work properly. The Case I'm trying to program is:  I have two OLAP tables where one table filters (component filter) data with:(DATE < TODAY()) and the other has the component filter:(DATE > TODAY() AND DATE < TODAY() + DAYS()).  My aim is: Column 1: Material NameColumn 2: Material NumberColumn 3: The KPI of the Material as a whole from the OLAP Table 1 which is a Detail Table of all Materials The filter is only a simplified representation of the code. In summary, I have one table that looks at dates from the past and one that looks at dates from the future (future orders/deliveries). However, I now want to connect KPIs from the table that maps from the data from the past on the table that looks into the future.  For example, if I have the sales of a material from day 1 to today (past until today), I would like to be able to display that as additional info for the future orders of that material (considered the pas

72
.
Level 4
.
Level 4
.146004319Level 4
asked in General Product Q&A
Filterin multiple input into a variable

I have a button dropdown, where I've different inputs like: EINDTSLFDTMENGENETPR  Separator : ,I'm wrapping with:start = 'end = ' My variable I'm writing into is changeFields So I did a KPI where I'm using this case when: CASE WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT)' THEN 'EINDT'WHEN <%=ChangedFields%> = 'Stat. Datum (SLFDT)' THEN 'SLFDT'WHEN <%=ChangedFields%> = 'Preisaenderung (NETPR)' THEN 'NETPR'WHEN <%=ChangedFields%> = 'Mengenaenderung (MENGE)' THEN 'MENGE'END THe problem is, when I'm using more than 1 input my CASE WHEN state the project doesn't work.  I tried it like:  WHEN <%=ChangedFields%> = 'Lieferdatum (EINDT),Stat. Datum (SLFDT)' THEN 'EINDT,SLFDT' But this idea doesn't work. I also tried to do it with logic gates. Does anyone have an idea how I can filter multiple inputs and check it in a case when function?

81
.
Level 7
.
Level 3
.146102116Level 3
asked in General Product Q&A
PQL statement returns different value for number chart and column chart

Dear community, I am using a formula to compute some KPI (based on the shown table), which is (SUM(PU_COUNT_DISTINCT( DOMAIN_TABLE("S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."CASEKEY","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."EVENTTIME"), "S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET","S2A_AKTIVITAETEN_DETAILS_xlsx_Sheet1"."AKTIVITAET" = 'Eskalation durchgeführt')))However, using this formula for a type chart and a column chart, I receive two different results.The type chart correctly counts the unique combinations of the columns casekey and eventtime for column aktivitaet with value "Eskalation durchgeführt", which is 8.Meanwhile, the column chart does not only count the distinct values, but all, and therefore returns a 10 (dimension is round month, which should not be important, as all table entrances result from the same month). Does anyone know why the column chart does not solely count

613
.
Level 3
P
Level 4
preethi.p12Level 4
asked in General Product Q&A
Do we have an option to make a KPI static in a column chart?

For eg., I want to represent the avg kpi as one of t​he kpi in a column chart and makes it static so I can basically see a straight horizontal line to the dimension to compare which dimension value has achieved the avg.

42
S
Level 3

Badge Winners

  • Qualified to Manage Implementation Projects
    jauhar.khalihas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Manage Implementation Projects
    julia.portehas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Deliver Business Value with Celonis
    manali.malpahas earned the badge Qualified to Deliver Business Value with Celonis
  • Celonis Certified Data Analyst
    ihtishaam.khanhas earned the badge Celonis Certified Data Analyst
  • Qualified to Build Action Flows
    ihtishaam.khanhas earned the badge Qualified to Build Action Flows
VIEW ALL
Community Code of Conduct