Product Q&A

Sysmex America has made breakthrough improvements across the enterprise — from A/R, where they recovered $3.4 million in just one month, before going on to reduce their past-due by over 60% in less than a year — to their IT system landscape, where they're streamlining their SAP S/4HANA migration. Read the full success story and visit ou website for more success stories, blog posts, and other resources on Accounts Payable & Accounts Receivable! 

Learn how A/R departments face a unique opportunity: the perfect moment to evolve from being reactive to proactive, and reassess and re-engineer how they collect in our latest blog post "Why Now is the Perfect Time to Re-Evaluate Your Accounts Receivable Strategy — And How You Execute It" 

7 Reasons Why System Migrations Fail — and How You Can Avoid ThemIn this blog, we’ll guide you through the seven biggest challenges in your migration — and how you can overcome them.

Here are four big ways that procurement is evolving, getting leaner, and not only recovering from disruption, but becoming a stronger, more proactive function than ever before.https://www.celonis.com/blog/four-ways-procurement-is-evolving-from-reactive-to-proactive/?utm_source=community&utm_medium=referral&utm_campaign=community_referral

Check out our "Little Book of EMS Use Cases: Procure-to-Pay - How to maximize the execution capacity of your P2P process with Celonis" and visit our webiste for more related customer stories, blog posts, and other resources!

Watch our latest customer success story and learn how Celonis helped Deutsche Telekom Services Europe save over €66M by maximizing the execution capacity of their Procure-to-Pay process to tackle duplicate payments and cash discount losses.Find out how Deutsche Telekom saved €10M by using Celonis within Procurement. 

Hi Celopeers, We will run three PQL-related sessions at Celosphere 2021: Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)PQL: Become a PQL Power User with a New Assistive Editor Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)Performance: Learn How to Optimize KPI Calculations to Scale Thu Apr 15, 9:25 AM - 9:50 AM GMT +2   (25 Min)Multi-Event Log: Analyze Multiple Integrated Processes in a Single View Sign up here! 

Did you know that the Celonis Process Query Language (PQL) turned 5 in February?

Hi, I did a test about the Conformance analysis in Celonis. How does the conforming cases (%) are calculated ? I created a process like this : image1076124 9.2 KB And that are the process for a specific case (NO ALLOWLISTED) : image280788 19.7 KB The system say that the conformance cases (%) is 100% : But is not the true I dont understand thanks in advance. Audrey

Is there any way to get the value of text components or variables defined inside process analytics sheet from machine learning script.Similar action for OLAP table is possible as mentioned in the below documentation:https://celonis.github.io/pycelonis/notebooks/01_Pulling_data.htmlHow can we perform the same for text components or variables?

Hi and welcome to the Celonis Family! If you are new to Celonis, this Community is the perfect place to learn from experienced peers, build your network, and find mentors. Feel free to check out our new Customer Onboarding Booklet attached!  Also, please note that we are running an onboarding webinar series for all new customers!Feel free to register for upcoming webinars or watch the recordings here:https://www.celonis.com/celonis-community/success-webinars/ Any questions? Just reach out to myself or any other celonis team member!

My activity table is having three columns ACTIVITY_EN, CHNAGED_FROM, and CHANGED_TO. Now I want to filter all cases which are ever passed through the Cancelled value in CHANGED_TO or CHANGED_FROM column. How can I filter these cases?

Hello everybody,I have the following problem. I hope you can help.I would like to use the component filter to hide the documents that have a clearing document.I have no idea for the formula.When I FILTER BSEG. AUGBL = then it only deletes the line for me, but not the entire receipt.Was a formula turned into a formula?Do I have to take GJAHR into account with the formula? Because the document in 2021 does not yet have a clearing document and should not be deleted.image779124 2.89 KBGREETINGS

Hi all, I have a problem uploading the BKPF.CSV file to SAP AP using the Quickstart option of SNAP. The file was generated with the extractor requested to the SNAP tech team. The message is: "The file cannot be matched to any of the required tables. Please make sure that the file name starts with the table name"SNAP_ticket_130414.pdf (288.9 KB) Attached is a file with screen captures Any hint? Thanks for your help. Luis

Hi, I want to select SUM of the top 3 cases based on their count in the single component KPI.I am using the INDEX_ORDER function to get index of each row, but when I apply the filter on analysis the count doesnt get changed. I assume it INDEX_ORDER is performing static in nature. How can I make it to dynamic. RegardsMukesh

I want to create a dashboard where user can input the data and on clicking the submit button the input provoded by user should go to machine learning script where the values are being used in the code.Is this possible with celonis? Please provide any documentation/code related to it.

Hello together, I want to use the standard Process Overview App to analyse troughput times and bottle necks. My process is the accounts payable process (paying bills). I could categorize my activities in: Data Log activites (performed activities by user or batch_user), f.e.: scan document, post document, forward documentCalculated activites, f.e.:reached discount period, reached payment period (based on the document date) These calculated activities are really important for the process analysis. However, they can be disturbing when analyzing the throughput time, because these activities dont affect the troughput time (they are just calculated). Do you know a sheet filter i could apply on the Process Overview App so that these activities are no longer taken into account? However, the cases themselves should still be included. Thank you in advance. Andreas

Hi everyone,for our development data model we would like to dive into our top X (e.g. 100) of open development projects in regards to their expected value. Currently I only know the function for an OLAP-table to show a limit number of rows. If we filter on certain areas/regions/plants this option remains, always showing the top X for the current selection. But we need additionaly KPIs above the table as:Total expected value of the top X projectsCertain Process-KPIs like (Average development loops per project) etc.Now Im searching, if there is any functionality to put a component filter or sheet-filter that we respect only the top X projects of the current selection.This might be interesting for everyone who wants to have a look/comparison within their top X cases.Best regards,David

Hi! I tried to look for any information on this in the Manual, to no avail, so I thought Id ask here: My client asked if its possible to filter the cases that meet the conformance model in the Conformance tab. We can see that its indeed possible to filter out the cases that violate the model - but we dont see an option to filter the correct ones. Is there any way to do this in Celonis? Thank you in advance, Filip

Dear Team, Is it possible to send extract of analysis (in excel) automatically to sftp or to some email on periodic basis? Regards. Roshan

Hello community,I am trying to build a table that will have a ranking of company codes. I use Celonis 4.5 on-prem. The company codes are my dimension. This ranking is based on the below KPI logic:CASE WHENMAX(WORKDAYS_BETWEEN(R2R.Tables::BSEG_KDAS.CAL_ID, R2R.Tables::BSEG_KDAS.LAST_DAY_OF_MONTH,(PU_MAX( DOMAIN_TABLE (R2R.Tables::BSEG_KDAS.ENTRY_DATE,R2R.Tables::BSEG_KDAS."_CASE_KEY"),R2R.Tables::BSEG_KDAS.ENTRY_DATE)))) = 3THEN 1WHENMAX(WORKDAYS_BETWEEN(R2R.Tables::BSEG_KDAS.CAL_ID, R2R.Tables::BSEG_KDAS.LAST_DAY_OF_MONTH,(PU_MAX( DOMAIN_TABLE (R2R.Tables::BSEG_KDAS.ENTRY_DATE,R2R.Tables::BSEG_KDAS."_CASE_KEY"),R2R.Tables::BSEG_KDAS.ENTRY_DATE)))) = 4THEN 2ELSE NULLENDthe above statement works as expected, however i need to include another variable where it also checks for the time stamp.I have tried the below statement, however am receiving an error message saying An aggregation is not a function.Can you please suggest a solution that incorporates both the max day

Hi I need to exclude the holiday dates from my activity table Event time column . Can anyone help me on this .Thanks

Hi , I need to calculate throughput time for some activities which are stored in variable. Can anyone help on this ASAP

Hi, I am using a combination of Import from Database for the Cases & Activities tables with Import from File third file (an Excel file with a primary key connecting to the Cases table). This works perfectly, as expected. However, after a couple of hours, all my Variant & Process Explorers stop working with the following error: Undefined exception occurred. Could not open swap file: 7e2f96 Clicking Reload from Cache in the data model resolves this, and the dashboard works again perfectly. But in another few hours, it breaks again with the same error. Im wondering what could be causing this error, and it its perhaps a known issue when using Import from File from Excel? It doesnt make any sense to me that it would work, then stop working with an undefined error, then start working again when the cache is refreshed (since the data doesnt change). Any advice is appreciated Thank you, Matthew

Dear all, We currently face an issue creating the data model for SAP SRM. We want to analyse the approval workflow for shopping carts in SAP SRM. Using tables like: CRMD_ORDERADM_H /SAPSRM/D_WF_000 /SAPSRM/D_WF_003 /SAPSRM/D_WF_008 /SAPSRM/D_WF_013 We currently cannot determine the right timestamp for each approval step. Therefore my question if somebody already implemented that topic to Celonis and wants to share the experience with the data model for SAP SRM. Thank you Matthias