Skip to main content

Product Q&A

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

4367 Topics
C
Level 3
chanti.pLevel 3
asked in General Product Q&A
Filter in Case explorer

I have crated a basic analysis for my team with only 1 sheet as case explorer. In the case explorer i want to hide few columns and publish the analysis. I don't want to show few columns to the team. Is there any functionality to hide columns in case explorer and publish? Regards,Ashok

22
C
Level 3
A
Anonymous
asked in General Product Q&A
Change DATETIME Column within the Event-Collection

Hello all, in the event-collection I create a new table, wherein I join two tables based on the following rule:JOINWHERE "Alarm"."Starttime" > "Transport"."Starttime" AND "Alarm"."Starttime" < "Transport"."Endtime" This works. Now I would like to extend this timeframe by 5 Minutes. And neither the function:add_minutes("Transport"."Endtime", 5) is supported nor the function REMAP_TIMESTAMPS("Alarm"."Starttime") < (REMAP_TIMESTAMPS("Transport"."Endtime") + 5) How can I change/remap a timestamp in the event collection?

00
A
A
Level 3
aram.wLevel 3
asked in General Product Q&A
How to show sums above value X and 0 otherwise

Hi, I want to add a column to an OLAP table that shows whether all orders from a given supplier exceed the value of 100 or not. So the final table should show a supplier name, the number of orders, the net worth of orders and either: The net worth value sum if its above 100, else 0An 'x' when the sum of orders exceeds 100 Also, it would be great to see how many single orders exceeded the value of 100. I was trying around for a while with PULL functions and CASE WHEN but I can't seem to make it work with the restriction of '> 100'. For example the query below gives me an error message stating that CASE is not compatible with FLOAT and INT. SUM(CASE WHEN "EKPO"."NETWR_CONVERTED" > 100THEN "EKPO"."NETWR_CONVERTED"ELSE 0END) Thank you very much in advance. Best regardsAram

00
A
Level 3
Isabella Apfel
Celonaut
Isabella ApfelCelonaut
published in Process Improvement
Automate your communication with Action Flows!

Dear Celopeers, on September 30th 2021, we are hosting our next Webinar on how to automate your communication with Action Flows!This is the second part of our new series of Webinars. The session will coverWhat you can communicate automatically with Celonis Action Flows (presentation)How to set up Action Flows for automated communication (live training)Where to find further material & trainings (link to resources)Q&A (live)FAQ (live, gathered from previous session) You can directly register here!

110
Isabella Apfel
Celonaut
J
Level 3
joren.kamer12Level 3
asked in General Product Q&A
Formula does not seem to work properly

Hi, When i show the same formula (standard throughput time calculation) in an OLAP table vs a number they fail to show the same outcome. Whereas they should. In the olap table I have applied the formula in combination with a priority dimension. WIth the number I have applied a specific priority as filter. Hence, both the throughput time should be equal. However, they are not.  Any idea what could go wrong?

30
J
Level 3
A
Anonymous
asked in Process Analysis
I was wondering when to use a skill or action flow? It seem there is an overlap in functionality or is it just me?

I was wondering when to use a skill or action flow? It seem there is an overlap in functionality or is it just me?

20
A
S
Level 2
sunita.pahwa12Level 2
asked in General Product Q&A
How can I change the format of x-axis for a chart dynamically?

I need to change it from %b-%Y to Q%q on the basis of time scale selected by user

00
R
Level 4
E
Level 4
enrique.sanch11Level 4
posted in Process Analysis
 Is there any way to set euro currency format in olap tables ?

 Is there any way to set euro currency format in olap tables ?  i like to see the amount of 3.000.000,15 € in euro format, now in celonis it is posible to see with commas like 3,000,000.15 but this is a Dollar format. ¿ Is it posible to set the currency configuration for euro ? Is there any way to set the locale configuration for currencies decimal in ',' and thousands in ',' ? Thanks in advance. 

119
E
Level 4
N
Level 2
nanthinidevi.pLevel 2
asked in General Product Q&A
How to print info on Data job transformation logs?

Hi All, I have more number of SQLs as part of one transformation in celonis. I would like to include a info to be printed on the transformation log after it completes a particular statement for debugging/tracking purpose(same like SQL's print command).  Could you please help me with option for the same? Thanks in Advance. :)

50
janpeter.van.d
Level 8
O
Level 3
obaid.ullah11Level 3
asked in General Product Q&A
Where i can get demo data event log that i can use to import data

I need to import data and create data model from the demo data that was extracted from the eventlog file as shown in one of Celoinis training video. Where i can get that eventlog file? I'm unable to connect any live system to get data feed so trying to use demo data instead but unable to find any event log data to import to create data model. The one training guide uses 'p2p_Demo_Eventlog.xlsx' file to upload data. I'm unable to locate this file. Can someone have this file or any other event log file that i can use to import data in my environment.  

30
janpeter.van.d
Level 8
V
Level 3
vidushi.gupta13Level 3
asked in Data Ingestion & Infrastructure
Facing issues during Data extraction in Event Collection

I am stuck at the Data Extraction bit in the 'Data Engineer' course. Not able to extract data even though I have tested the connection and it works fine. 

00
R
Level 4
L
Level 3
luis.magalLevel 3
asked in General Product Q&A
Is it possible to compare one row with another in an OLAP Table or other element?

The logic is as follows:if a category repeats (like C1), then:for each category, calculate the date difference (DATEDIFF) between "closed at" date of a row with "closed" status and the "opened at" date of the rows with an "open" status. The objective is to have an extra column to the right, with these values:Difference (in days)18 (DATEDIFF(dd,17.09.2021,30.08.2021)16 (DATEDIFF(dd,15.09.2021,30.08.2021)N/A (because its status is closed)N/A (because the category doesn't repeat)N/A (because the category doesn't repeat) Suggestions?

30
L
Level 3
P
Level 1
piotr.twork11Level 1
asked in General Product Q&A
Automated documentation of data model

Good morning, My client has 4.6.1 on-prem Celonis license. I was asked to overwrite the old data model with a new one. I'd like to make sure it is possible to recreate it in the future. Do you know if it is possible to create automated documentation of the data model? Thank you in advance,Piotr

00
S
Level 4
.
Level 2
.14600871Level 2
posted in General Product Q&A
TPT

Hi, How can I customize the he Throughput-Time-Search element in Celonis 4.5? - In the attached picture (TPT) the intervals for each bar is consistently 14 hrs. Can I change this to e.g. 50 hrs per bar? - Thanks.

04
R
Level 4
C
Level 2
charles.picotLevel 2
posted in Process Analysis
I encounter an issue in the Maverick Buying prebuilt App for Accounts Payable process.

I encounter an issue in the Maverick Buying prebuilt App for Accounts Payable process. One of the chart is not displayed correctly as showed below.Indeed, when I am using the KPIs that have been built by the Celonis team I got an error message. The name of the KPI as well as the error message are displayed in the picture below: How can I solve this problem ?  Thanks

12
R
Level 4
K
Level 3
khurram.shahz11Level 3
asked in Process Analysis
Table fitering with rows who have open tasks

Hi, Can we filter a table with rows only having open tasks, by defualt it shows all record and user has to select filter icon. Is there any way that we can avoid this step for user. Secondly what is the difference between closed and resolved. By default I have onyly option to close. RegardsKhurram

10
K
Level 3
O
Level 3
obaid.ullah11Level 3
asked in General Product Q&A
How to use 'SAP Demo' connection listed under 'New Data Connection' in Data Pools in Event collection module.

I'm trying to use Celonis provided pre-configured demo application in TryCelonis. During the creation of data pool, it asked to create Data connection. From the list of available connections there is one connection named as 'SAP Demo'. Is this build in connector to connect with demo data related to SAP? When i tired to use this connection, it pre populated connection details like Host, client, systemNumber and user id. In order to complete connection, it need password and i'm not able to find it anywhere in any documentation. I'm not sure it is correct approach and i'm making correction assumption about 'SAP Demo' data connection.I'm trying to setup an environment from demo data without creating actual connector with SAP. Is this possible? if I do not specify data connection, then i'm unable to get 'Data model' object from PyCelonis for the analysis that is using that data model. Any help shall be greatly appreciated.

12
O
Level 3
florian.mrkvi
Level 4
florian.mrkviLevel 4
asked in General Product Q&A
Is it possible to upload 2 seperate csv files for the activity table?

As soon as our CSV file for the activity table exceeds the filesize of 4GB Celonis is throwing an error and I suppose this is due to the filesize.I cannot reduce the dataset any more so I hope there might be a way to upload 2 seperate files and join them together within Celonis. Unfortunately I can't find such a function anywhere. Or maybe there is another way to bring big activity tables to Celonis without a database connection? Would that work in IBC? I work On-Prem 4.6.0-RELEASE_2babc1e_20200831_0915

30
florian.mrkvi
Level 4
D
Level 2
diane.vilme11Level 2
asked in Data Ingestion & Infrastructure
TPT with SOURCE and TARGET for a particular sequence

Hi, I am interested in two particular sequences A->B->C and A->C that may have none or multiple occurrences within one case (A ,B and C are activities and the connexion "->" is not necessarily direct).  Important: The activity A is always followed (directly or not) by the activity C. That means that I can't have A->A->C or A->C->C, but I may have A->C->A->C. I would like to calculate two KPIs:KPI1: Average TPT between A and B when I am in a A->B->C sequence,KPI2: Average TPT between A and C when I am in a A->C sequence. For instance: Let's say I want to calculate KPI1, and one of my cases is:  Start >> ... >> A1 >> C1 >>... >> A2 >> ... >> B1 >> C2 >> ...>> B2 >> ... >> A3 >> B3 >> C3 >> ... >> End. For that case, the result should be ( (tB1-tA2) + (tB3-tA3) )/2 (with t- being the timestamp) I tried the following, but it seems to

10
D
Level 2
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Product Q&A
Why is my filter option only applying to half of the table?

I have a table in the 'Filter_Option' attachment that is filtered based on a client and it shows different values with relation to no.of cases and amounts based on different periods in days.  I have a further drilldown option when you click the orange button which directs you to the `Drill_Down` attachment But, even though the client filter is global it only applies to half of the table. I observed this when I added up the red circles which is reflected in the drill_down attachment

10
R
Level 4
M
Level 3
mohamed.ruzli.mohamLevel 3
asked in General Product Q&A
What is the meaning behind the difference in figures in Variant explorer

The screenshot with the red circles is filtered on Avg throughput time and the screenshot with blue circle is filtered on median throughput time. If you some up the values in the explorer (Example: Red circle image:- 4 + 20 + 13 = 37) it is not equal to the median red circled day of 66.5 . Th difference also exists when I filter on median throughput time. Any suggestions?

05
A
C
Level 2
claudio.tatiy11Level 2
asked in General Product Q&A
Hello everyone! Anyone knows about SAP connectors (EMS Store)? Is there connector to SAP CCS or I can use the SAP ECC conector. Is it the same?

We need to connect Celonis to SAP CCS, but we don't know if the SAP ECC Connector can be use.

02
C
Level 2
V
Level 2
vivek.oza12Level 2
asked in Data Ingestion & Infrastructure
Using Python , How to add user to existing groups?

Hello Community, Refering to [1.0.0 / User Management & Permissions] on help.celonis.de I have " 5 new users" (created via python) , now i want to add it to existing group using python. user = User.create_new(Dummy1, fname, lname, email@abc.com, password123) user = User.create_new(Dummy2, fname, lname, email@abc.com, password123) user = User.create_new(Dummy3, fname, lname, email@abc.com, password123) user = User.create_new(Dummy4, fname, lname, email@abc.com, password123) user = User.create_new(Dummy4, fname, lname, email@abc.com, password123) I already have existing 2 user groups , i.e Viewers , Analysts Now I want to Assign user Dummy 1 and Dummy 2 to Group Analysts and I want to Assign user Dummy 3, Dummy 4 and Dummy 5 to Group Viewers :- like below Groups User Analyst Dummy 1 Analyst Dummy 2 Viewers Dummy 3 Viewers Dummy 4 Viewers Dummy 5 Now If I try to assign the user to the Group using group.add_user(user) However , how to I assign my existing Group

10
U
Level 3
K
Level 2
kaveri.b11Level 2
asked in General Product Q&A
I am getting the error while running the transformation i.e inner partition did not fit in memory

Execution error: ERROR: Join [("27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".USR02 x "27473006-d9c3-4d0c-8e36-7c4690ec4574_e04e1e0b-30e2-426d-ab63-bb9f5b0e5f2a".CDHDR) using USR02_v1_b0 and previous join (PATH ID: 7)] inner partition did not fit in memory; value [100,BATCH]

156
K
Level 2
A
Level 1
anusha.s.m11Level 1
asked in General Product Q&A
How to connect HANA database to celonis IBC? What are the requirements or inputs required?

How to connect HANA database to celonis IBC? What are the requirements or inputs required?

00
V
Level 4

Badge Winners

  • Celonis Certified Data Engineer
    vijay.v14has earned the badge Celonis Certified Data Engineer
  • Qualified to Get Data Into Celonis
    vijay.v14has earned the badge Qualified to Get Data Into Celonis
  • Celonis Certified Data Analyst
    colton.linem12has earned the badge Celonis Certified Data Analyst
  • Celonis Certified Data Engineer
    sebastian.lopez11has earned the badge Celonis Certified Data Engineer
  • First Post
    Aide_Yunuenhas earned the badge First Post
VIEW ALL
Community Code of Conduct