General Product Q&A

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.

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 

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  

This is one of the error message I had: Table BKPF cannot be accessed with the current connection configuration.. Celonis Support ID: 7097d202-4f59-464c-8e18-38c7a037ebb8

Can someone explain the relationship between IBC, EMS and Snap? Many thanks.

Hi Celopeers, is there a way to apply "finegrained" permissions for an application key onto a data model?We want to enable a ML application to access a Data Model in a read-only manner. The application key should be able to query the data model, but nothing else. The only way to grant access to a data model is to set the "Admin" Permission for that application key on the pool level. Thus, the application key has FULL access to EVERYTHING in this pool, and potentially access/edit/delete things it's not supposed to.  The "Use all Data Models" permission does nothing for the API as is only applies to analysts creating content so that they can link their assets to a DM. Thank you for your helpBestMax

Greetings. I am new in process mining and Celonis, and i'm stucked.We got OLAP Table with data into it, in last column we counting KPI, the question in how we can measure process at the specified time?Example: I got an document that flows through the signing process, and for now this doc is signed, but 2 days before it was on some step (like signing paper copy with partner) and i need my OLAP table to count difference between the start of this signing and today(date) when i filter my Analysis with the other graph.Now, i using the "PROCESS EQUALS 'Signing with Partner' END" to determine state of the process, and it's works fine for documents, that really at this step for TODAY(), but if i filter EVENTTIME in the past - i still can see the KPI's of this doc. How can i get the process state of the case at specified date? Thanks!

Hi All, may I know is it possible to get the data set used in the Procurement TryCelonis Demo? That will be really helpful when we let our users to know what exactly they may need to provide in order to perform process mining. Thank you!

Hello everyone, our SAP colleagues want to deploy SAP Support Pack Stack 17 so I am trying to find whether our Celonis v. 4.4 is compatible with this and if we need to do any follow up tasks after the deployment(like maybe new extractor). Thanks a lot for your help

Hi all, May I know can the KPI collection interval be customized? As I can only see the options for "daily", "weekly" and "monthly'. What if my user would like to have the KPIs refreshed every half hour? If possible, please help to guide me where can I configure that! Thanks in advance!

I want to sum only distinct values. And here´s my problem. I created a variable with the order and the position of the order (CONCAT VKBEL & POS). And now I want to SUM the amount of the order quantity of all variables. But the variable occurs more than once. Is there a function that only sum distinct values? Thanks in advance for any ideas.

We're working with make to stock so the direct date difference between receiving (101) and sending (261) movements will not work.

Hi everyone. I'm working on a project that we have the following scenario: Extractor Server is running on a Virtual Machine, that has access to an SAP system, and we have an uplink connection between Celonis Cloud and Extractor Server. This is working fine during working hours, let's say 9-to-5. However, due to resources saving, the Virtual Machine is running just 08 hours a day. And some tables take up to 13 hours to extract (full load). Suppose that we start extracting data at 8 am: RFC Call => Job Running on SAP => Generating files from 0...N => Extracting to Celonis => Repeat. Then at 5 pm the Virtual Machine shuts down. What will happen to the files generated after 5 pm on SAP? When the Virtual Machine is up again, Celonis will recover the work from where it stopped or we need to start it over again? It happened on our project during a big extraction, we had to cleanup the files manually (Report /CELONIS/CLEANUP) and start extraction again, since Celonis didn&#

Hello everyone,  I have a problem with events that I have excluded via analysis settings. In the script I have mapped activities with NULL as follows:  FILTER "CEL_LBU_ACTIVITIES". "ACTIVITY_DE"=REMAP_VALUES("CEL_LBU_ACTIVITIES". "ACTIVITY_DE",['Order Confirmation', NULL],['Order Receipt', NULL],['Message Accepted', NULL], ['Change of Processing Location', NULL]); It has been noticed that this line is not sufficient to completely remove the activities. The Process Explorer, Case Explorer as well as SOURCE()/TARGET() functions still contain these activities. I did not want to change the data in the database and hope that there is a simpler solution to the problem. Maybe someone can tell me how to remove the activities from this analysis. Many thanks Laura

I'm curious as we only have limited consumption in the instance and we're using live data connection. I can think of two approaches:  One is to schedule a job which executes full load at a given time but that would be setting it up with certain parameters before scheduling so there is still manual work every now and then. It also involves the source system so I wanted to know if - two, it can be done just within Celonis, is there a script which can be scheduled for execution and checks whether tables have exceeded the set scope (e.g. one year). I understand this might have to be customized for different process blocks but this kind of optimization would be really helpful and I'd like to know if there's already a process/ template being used.

Webinar: Driving Sustainability With Procurement With environmental concerns taking center stage globally, Procurement departments are in a unique position to help organizations move from initiative to action.  Join our experts to learn about the relationship between Procurement and sustainability — where we’ve been, where we are, and where we’re headed — as well as ways to power your team’s future sustainability practices through data-driven decision making.  Register!

I need to see whether Celonis 4.0 is still a deployment mode option 

Hello, If I have a process that includes macro-activities, which include various activities within them, is it possible to have a view of the macro-process and the sub-process? To better explain , I am attaching an example image, in which you can see that both the Macro-Activities and the Activities are listed in the activity table, and the ideal view that I would like to obtain is on the right. Thanks for your attention and for those who will be able to answer me.

How can I add further collueagues to a certain project in the project hub? Thx for advice in advance, best, Bernhard

This question is being asked because it is one of the requirements in a university medical center RFP for Celonis-like services. Thanks! 

This is more of a question related to Celopeers itself, but I have found that I cannot edit my posts and comments after submission. Could this be enabled???

Hi All, I have a date dimension and a related KPI (Using Running_Total). What we'd like to be able to do is to filter the date dimension shown in the component (e.g Last 20 days), but still have the KPI calculation based on the full dataset (ie. ignore the date filter). thanksDavid

Need for Templates for a "Data Point Definition Workshop":Is there anything you can share with me with a view to a workshop of this kind? The important question thereby is: "On the basis of which data do we do certain things and where do we find them (the information, etc.)"?I am really grateful for any help and would need at best by Friday some information about it! Thanks a lot and many greetings,Hannah