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?

Sustainability Base Camp Sustainable business execution is more important than ever. We believe that the EMS has the capability to help create more sustainable processes. To get ideas rolling, we've created the Sustainability Base Camp, a 2-hour training track, which aims to give you a broad overview of what matters in terms of environmental, social and economic sustainability.  Begin your journey today to get the conversations started! Use this discussion forum to exchange your thoughts on the questions posed throughout the track.  Remember that feedback to the track itself is best handled via the feedback form on the Academy :)  

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

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

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

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

Hi,Is there some kind of limit how many columns can be visible in the column chart? I have a table, in which I wanted to visualize activity count 13 types of cases per date. When I create 10 of them, the column bars are barely visible. If I add next kpi, then the bars disappear. Is there some option to show all 13 kpi at the same time in column format? I know I can change some of them to line axis, etc. but would prefer columns for all of them

Hi Team,  I have a conceptual question here. We are importing data through flat files from 3 different souce systems namely : MDG, ECC and PLM. Need to identify a field which can be taken as a common reference which will further help in defining Case key for the process. The process is around Order to Activation of SKU in SAP..Any help would be much appreciated, or someone who would have dealt with similar use case. Eg : in a generic P2P process, #PO Items could be used as 'Cases' across the flow, trying to identify something similar in my current process.

Can task templates be shared with multiple data pools?

Dear Celopeers, On December 8th at 5PM CET, we are hosting a webinar with our product experts to dive into the technology behind automating sales order entry with 100% data accuracy. At the Celonis World Tour event in October, Celonis & Conexiom released a product offering to empower companies to mine, automate, and optimize their order management processes. Join this webinar to meet the technology behind achieving 100% data accuracy in sales order entry.  Register here!

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

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

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

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:

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  

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.

Hi Team, I need to create some dashboard which shows the value added by Celonis in the organization based on Procure to Pay data. Do you have template/analysis which should help the organization to understand the value addition from Celonis. This will help to get the idea about what I can implement and show it to management. Thanks, Aakash

Hello Team, Im downloading the Process Flow from the Process Explorer as a PNG Output. Unfortunately the left most part of my PNG output is getting truncated. Are there any settings whereing I can specify the width, so that the PNG download is not getting truncated. Attached is the leftmost part of my process flow which shows the TP time as 81 Minutes. But in the PNG download, it shows only the Connection line with only minutes without 81. Kindly advice. Warm Regards, Jayanta Borkakoti

How could be a filter realised with the following condition: Activity_1 was performed by Division A and a following change Activity was performed by Division B We started with: FILTER (ACTIVITIES.ACTIVITY = Activity_1 AND ACTIVITIES.DIVISION = Division A) AND (ACTIVITIES.ACTIVITY LIKE %Change% AND ACTIVITIES.DIVISION = Division B); Which resulted in a empty OLAP-Table. Does anyone have an idea how to realise this filter?

Hi all, Im looking for a way to use variables to restrict the standard component " Throughput Time Search". As an example: I want the standard component to show me the average lead time of the process steps C-F. I have tried a filter on the component and used the following code: (CALC_THROUGHPUT(FIRST_OCCURRENCE[<%=dlz_start%>] TO LAST_OCCURRENCE[<%=dlz_end%>], REMAP_TIMESTAMPS(WFMT_EVENTS.TIMESTAMP, DAYS))) Unfortunately the filter does not change anything. But I do not get an error message either. Is my code wrong or does the standard component not provide this possibility? Thanks for your help!

Dear community, I have created my own eventlog from sap (field names are the same as in celonis eventlogs) and imported it to default analysis. I do not have problems with process explorer nor with process variants. However when I open Process Overview I can see some happy path but with 0 cases: Bildschirmfoto 2020-09-27 um 16.55.4725101336 249 KB Througput times and activities are displayed correctly. What could be possible cause for this strange behavior. Greetings, Ula Jessen

Hi there, we are currently in the middle of the extraction of a production planning process from our SAP ECC. Now there is the need to extract only certain lines of the CDHDR and CDPOS. We know that a join is theoretically possible between AUFK.AUFNR and CDHDR/CDPOS.OBJECTID. To make it an exact join, though, one has to extract a substring of the OBJECTID, as the AUFNR is only a part of the OBJECTID. We tried this: SUBSTRING (CDHDR.OBJECTID,6,12) = AUFK.AUFNR. It returned an error, though. Does anybody know, where the problem is or is there a better solution to our problem? Happy for any help and best regards, Carl

Hi Community, Im currently building a Map in Celonis that shows the number of events per Location or Country. The calculated KPI uses a regular COUNT Function and is shown perfectly fine on the component. Now I want to apply coloring threshholds according to the data shown on the Map. The highest thresshold is supposed to be the maximum the KPI on the Map. Lets say the marker Germany has the highest number for the calculated KPI, e.g. 1000. Then the thresshold for red should be 1000, 800 for orange and 600 for yellow. Sounds easy, right? Well, it isnt. Although you can generally use functions to calculate the threshholds, you cant accomplish this behaviour in a consistent way: Wed need to manually aggregrate the KPI towards the Location, then take the MAXThe way do determine the MAX per Location would be to use MAX and a PU-Function inside (with a Domain Table for the Location).This works if youre not applying any selections. As soon as you filter your dataset, that function will no

Hi all, I want to compare/concat a string (e.g. SupplierName) with a date/day. Target: Are there days where I have used more than 5 suppliers. My formula suggestion: FILTER COUNT(DISTINCT SupplierName||Date)>5; Nay ideas? Many thx and br Daniel