Skip to main content

Product Q&A

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

3154 Topics
.
Level 1
.14600107755Level 1
asked in Data Ingestion & Infrastructure
why can't install the process connector

​

00
T
Level 1
C
Level 2
christopher.k11Level 2
asked in Process Analysis
Hi guys, i was wondering if anyone was able to actually reference 2 different Knowledge Models from 1 single view as explained in the Celonis Cloud Help (xxx.celonis.cloud/help/pages/viewpage.action?pageId=41196721)?

60
C
Level 2
V
Level 4
vasco.caron11Level 4
asked in Data Ingestion & Infrastructure
How to Cluster the % of Distinctly Named Suppliers that have at least 1 Purchasing Document Item with certain characteristics, per month?

Good morning,‎I know the title is a bit convoluted, but I will provide additional information here.‎‎Essentially, we are trying to build a Bar Chart, with 1 Dimension and 1 KPI:Dimension: Purchasing Document Item Creation MonthKPI: % of Distinctly Named Suppliers that have at least 1 Purchasing Document Item with certain characteristics:‎This is what it currently looks like, without any filters.However, it does not effectively evaluate each supplier, each month.It evaluates each supplier across the entire data pool.Example:Supplier #1 Selected: ‎Great performance right? 100% Across the board! Now, if I look at the actual data, through some non-clustering formulas (no use of PU_SUM, PU_COUNT, etc.): ‎‎As you can see, this supplier actually had no Purchasing Document Items within the defined characteristics (Acknowledgement) for the months of November and December 2021, however, looking back at the graph:‎    ‎100% for both months.. ‎ To summarize, the formula is:Looking at each distinct

10
V
Level 4
.
Level 2
.14600780Level 2
asked in Data Ingestion & Infrastructure
Count number of “open” SOURCE-TARGET-connections per day

Hi everyone, My goal is to count on a daily basis how many cases were between two specific activities on that day. See the following example: So the result table needs to include every day in the timeframe (GENERATE_RANGE?). For each day I count all connections where day lies in between Start and End of the connection. Is this possible in Celonis? Thanks for any ideas, Patrick

20
.
Level 2
.
Level 2
.146001240Level 2
asked in General Product Q&A
pyCelonis

Hello,I get an error when trying to install pyCelonis locally. Can you please give me advice (additionally to what is already available in the documentation). Thank you, Martin

60
.
Level 2
C
Level 1
chiara.greseLevel 1
asked in Data Ingestion & Infrastructure
Thanks for participating in our Action Flows Webinar Series.

Thanks to Celonis, it’s time to free up execution capacity and finally perform at your full potential. Therefore, we want to make sure you didn’t miss any of our Webinars. Here you can find the recordings of each of them: Create your first Action FlowAutomate your communication with Action FlowsKickstart your Action Flows with Use Case TemplatesUse Celonis data in Action Flows The next webinar, Automate in SAP with Action Flows, will take place on Thursday, December 16th,  2021 (4-5 pm CET).  Make sure you won’t miss it and register now! Best,The Celonis Team 

00
C
Level 1
M
Level 2
mary.hope.suson11Level 2
asked in Data Ingestion & Infrastructure
Loading time in Add Table from Data Model

Hi, Lately, the loading time for editing the process data model took a lot of time. Especially today, I wanted to add an additional table in the data model but the page keeps on loading for about 30 minutes now. Is there a way around it? Need to complete asap the data model load.

00
A
Level 1
A
Level 3
alexander.grafLevel 3
asked in General Product Q&A
Prolong Invitation Link activation

Where can I extend the time an invitation link is valid?

10
kay.kaspe
Level 3
T
Level 3
tomoki.tsuneLevel 3
asked in Data Ingestion & Infrastructure
Calculate Throughput Time differs in Single KPI and OLAP Table

Hi peers,I try to set up new components using CALC_THROUPUT. The two following components show different results. This is presumably caused because the OLAP tables have multiple lines with single CASE_KEY though the process pattern only occurs once (and it should since we use FIRST_OCCURENCE).  It won't change when we use Attribute selection overhead to limit to single KUNNR or give KUNNR in Dimension. Why OLAP returns several line items? Single KPI (Number)<KPI>CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['Create Delivery'], REMAP_TIMESTAMPS("_CEL_SD_ACTIVITIES"."EVENTTIME", DAYS)) OLAP (identical with single KPI)<KPI>CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['Create Delivery'], REMAP_TIMESTAMPS("_CEL_SD_ACTIVITIES"."EVENTTIME", DAYS)) 

30
T
Level 3
D
Level 3
david.riedeLevel 3
asked in General Product Q&A
Execute Data Job through ML Workbench script

Hi all, I‘m desperately looking for a way to start a data job directly via a Python statement within the ML Workbench (IBC). I succeeded in starting a data model load via the api_request() function providing the reapective pool and model ID‘s but couldn‘t implement a similar logic for a data job execution on the ML Workbench. Could you help me out with the correct function and schema on how to do the call? Thank you very much for your help! BR David

70
D
Level 3
M
Level 3
miriam.luttrLevel 3
asked in General Product Q&A
Why do our Delta Loads take more time than our Full Loads?

Good afternoon everyone, We've been looking at our Delta Loads and Full Loads runtimes to try and optimize our Data Consumption and we've noticed that the Delta Loads always take more time than the Full Loads. Is there a reason for this? Is there something we can do to have them be faster? In the below Image you can see some examples of /COCKPIT/THDRV and CDPOS tables which are quite large  Please advise Thank you in advance for your support

60
M
Level 3
A
Level 2
alex.giorgLevel 2
asked in General Product Q&A
How works multiple COUNT_TABLE in number component formula editor with table joined?

I have two tables "Ta" and "Tb" in join directly, Tb is the master case table and the relation is "Tb" 1 -> N "Ta" . In formula Editor inside the number component COUNT_TABLE("Ta") = 1305 and COUNT_TABLE("Tb") = 7144 and all is correct. When I create a new number component with COUNT_TABLE("Ta") / COUNT_TABLE("Tb") I retrieve the number 1.2219..... I don't Know Why! I expect 1305/7144 = 0.1826. Components are without filters. How can I use multiple COUNT_TABLE in the same formula?Thanks,Alex Giorgini

10
A
Level 2
P
Level 2
petr.herzi11Level 2
asked in General Product Q&A
Is it possible to set delta loads from SAP in such a way, that when new column is added, the extraction won't fail, but will just add the new column to the list of the columns and treats it as unselected?

Is it possible to set delta loads from SAP in such a way, that when new column is added, the extraction won't fail, but will just add the new column to the list of the columns and treats it as unselected?

40
janpeter.van.d
Level 8
.
Level 2
.146004053Level 2
asked in Data Ingestion & Infrastructure
Good Morning : Preparing to install on perm Extractor , and the we would like to use Windows Server. The documentation refers to 2012 R2. This appears to be out of support , will 2016 R2 work as a data base?.

Good Morning : Preparing to install on perm Extractor , and the we would like to use Windows Server. The documentation refers to 2012 R2. This appears to be out of support , will 2016 R2 work as a data base?.

00
.
Level 2
D
Level 3
dominik.kensyLevel 3
asked in General Product Q&A
Comparing two different aggregations of the same table based on one condition

Hi, I am looking into setting up a dashboard to monitor contract leakage in the form of paying a higher price for a specific item than agreed in a contract. 1.) I would like to obtain a count of purchase order items that were purchased outside of an existing valid contract.2.) I would like to obtain an indication on the cash value (difference between PO price and contract price) In our data model EKPO consists of both, purchase orders (EKPO.BSTYP = F) and contracts (EKPO.BSTYP = K). Now, I would like to compare the material number (EKPO.MATNR) for all EKPO.EBELN where EKPO.BSTYP = F with the material number for all EKPO.EBELN where EKPO.BSTYP = K. Whenever there is a match:1) Check if the contract number (EKPO.KONNR) in the PO (EKPO.BSTYP = F) equals the contract number (EKPO.EBELN) of the respective contract (EKPO.BSTYP = K) If not, the item was purchased outside of the frame agreement. If EKPO.KONNR empty, the item was also purchased outside of the frame agreement

00
J
Level 4
D
Level 1
diogo.silva11Level 1
asked in General Product Q&A
SSO Certificate Expiry

Hello team, Our certificate is going to expiry today at 18h15 GMT and we need a new certificate. Can you help us with this? Best regards,Diogo

00
V
Level 1
O
Level 3
obaid.ullah11Level 3
asked in General Product Q&A
Error: App/API needs access to pool and datamode when accessing datamodel through pyclenois

We are trying to access data model for an analysis and are using python script to connect and access data from backend. We are using Celonis cloud environment ‘TryCelenois’. We have created an apikey in user profile and using same ‘apikey’ during the login process. We have installed few sample applications from ‘EMSStore’. These applications has preconfigured analyses that we are using for our analysis. We are not using any custom data connector and instead using Celonis provided demo data model to provide data to these analyses. We can view data and perform all kind of analysis from the UI on these analyses. However, when we are not able to access datamodel object when trying to access it from external application through ‘pyCelnois’  We are using ‘pycelonis’ package to establish connection and extract data from Celonis. We are able to successfully connect with the Celonis system and able to extract the required analysis from the analyses collection. Though we are able to extract most

10
O
Level 3
I
Level 2
ingo.ganseLevel 2
posted in Data Ingestion & Infrastructure
Can task templates be shared with multiple data pools?

Can task templates be shared with multiple data pools?

13
I
Level 2
K
Level 2
kefang.dingLevel 2
asked in General Product Q&A
Root Cause Analysis with pycelonis :: UnboundLocalError: local variable 'za' referenced before assignment

I want to try root cause analysis in ML on my data. I have followed the same way as here https://celonis.github.io/pycelonis/notebooks/01_Root_Cause_Analysis_Tutorial.html. All steps work fine until it reachs  the row rca_result = RCA.apply()​The reported bug says this ： UnboundLocalError: local variable 'za' referenced before assignment​Details listed below:0it [00:00, ?it/s]---------------------------------------------------------------------------UnboundLocalError Traceback (most recent call last)/tmp/ipykernel_740/325769791.py in <module>----> 1 rca_result = RCA.apply()​~/.local/lib/python3.8/site-packages/pycelonis/root_cause_analysis/root_cause_analysis.py in apply(self) 60 selected_tables, search_list = self.filter_case_key() 61 chunks = self.create_chunk_list(selected_tables, search_list)---> 62 za = self.calculate_kpis(chunks) 63 zb = self.postprocess_kpi_frame(za) 64 return

00
K
Level 2
A
Level 3
archit.agrawLevel 3
asked in General Product Q&A
Want to connect locally installed SQL express to Data Model

Can we connect our locally installed SQL express under data model ? If yes, please help with detailed steps 

10
A
Level 3
L
Level 1
luis.pedroLevel 1
asked in Data Ingestion & Infrastructure
Change My email and Name in the Training platform

Is there a way to change the email or name in the training platform?

20
gabriel.okaba11
Celonaut
R
Level 2
ron.christian.tanggLevel 2
asked in Data Ingestion & Infrastructure
Action Engine removal of duplicates on 1 column

Hello,I created a action engine skill and its going very well. Since I am using approver name as a connection for the process automation to send email. I dont want that the approver will be bombarded with multiple email if he/she has many invoices that needs action. Is there a way to remove or filter approver with the same name only regardless of the other columns he/she has?Thank you.Example:

00
gabriel.okaba11
Celonaut
.
Level 3
.146003843Level 3
asked in Process Improvement
Hello Everyone,Can any one help me on how we can create our own customized domain automated emails(not @celonis.com) in studio.Thanks,Venkat N

40
gabriel.okaba11
Celonaut
A
Anonymous
asked in General Product Q&A
Execution error: ERROR: Execution time exceeded run time cap of 00:20

Hi there, I am getting a run time error creating a table and I am wondering if this concerns only the editor or also a scheduled transformation job?  Kind regards,Sasa  

20
gabriel.okaba11
Celonaut
P
Level 3
pritam.roy20Level 3
asked in Process Analysis
How To Backtrack The Connection Details From The Extraction Jobs

How to get the connection details used by the extraction. We have the below scenario. There are numerous connections being established with different sources, and some are duplicated connections were created depending on the need of different credentials with different of permissions of a particular source. Now the permissions have been sorted by the DBA, need to clear out Data Connections which are no longer in use. Stating the IBC is being treated a PROD and any fail schedule will be treated as a downtime needed to identify the connections which are in used by the current extraction process.

00
gabriel.okaba11
Celonaut

Badge winners

  • Qualified to Manage Implementation Projects
    katarzyna.olechhas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Create and Deliver Demos
    schahram.hamrahas earned the badge Qualified to Create and Deliver Demos
  • First Post
    jan.mölichas earned the badge First Post
  • Qualified to Prove Celonis Value
    lasse.muellhas earned the badge Qualified to Prove Celonis Value
  • First Post
    SHASHANKhas earned the badge First Post
VIEW ALL
Community Code of Conduct