Product Q&A

Im trying to create a number KPI that gives the % of cases contained in the top n variants. This would be the number shown in the variant explorer as the % of cases contained in the variants selected (for example, when dragging down to the top five variants in variant explorer, the bubble at the bottom says 72%. I want to use that 72% in a calculation.). I want to be able to use this number in other calculations. Id like for this to be static (not subject to filtering), which I know how to do. Are there internal variables that contain this and other information that is used to create the graphics?I found this reference but its not of much help. I cannot get to the page in any case. Percentage of cases covered by the 5 most common variants - #3 by gvanenisHow would I use the INDEX_ORDER syntax to calculate the KPI Im looking for? Thanks in advance for your help.

Hello and a happy new year,we do have the problem of memory allocation while using several Pull-Up Aggregations. Is there a way to release the memory frequently?Our set up is Hybrid (IBC + Leave your data in place).We have 90mio Activities@8.5mio Cases in one Model and 260mio Activities@24mio Cases in a second Model. The memory consumption is in idle state at 24 GB and moves up to 64 GB when using PU-Functions. This will quite often let the engine crash and models could not be re-loaded even from cache until the memory garbage is cleared.Thanks for any suggestion.RegardsHolger

Dear all, is it somehow possible to access IBC data model Data Permissions from pycelonis? Eg. query the current permissions configuration or set new permissions? image781538 32.4 KB Best, Benedikt

Hi, Im trying to add translations for our PTP data model as requested by the client, however, upon downloading the PTP Name mapping template it says " failed to download PTP Name mapping.

Hi there, I am unable to find how to use a xlsx or csv as a filter criterion during extractions. I want to set an extraction parameter but the list of values is fairly long and I dont want to type every value in there manually, but reference an uploaded xlsx. Is that possible and if so how do I do it? Thanks and best regards, Carl

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 celonis team, I am looking at the APC reduction script documentation posted in the partner portal. However, i am unable to find the App Store Filters.xlsx file that is required for me to complete the python script. The documentation says Download the attached excel file., however, i cannot locate this in the word file or the download loaction " Celonis Partner Portal". Could you help me as we require this for a client project. Thank you.

Hi, I am wondering how I could create a bubble chart with multiple bubbles on a single line, as it is shown in the photo attached.I have been trying to use PU_COUNT, but the parent and child tables do not have the same columns, which made me difficult to distinguish the sums depending on the number shown in the graph.Best,chart846524 21.7 KB

Dear Colleges, I am trying to set a filter at my Pivot Table I would like to have the "1" of each activity to know the users that performed more than one activity in a process. I am trying for two days with success. Best Regards Raphael Correa

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

Hello, We are currently in the midst of migrating all our Analyses and Action Engines to Studio. Celonis provided with a functionality to seamlessly migrate the analyses to Studio. Is there an easy way to migrate Action Engine Skills to Skills within Studio?  Thanks

Hi all, I would like to install the Python library 'pyodbc' in order to extract data from a database using a custom database driver. However, I get errors when I try it to install via PIP. I found out that this could be caused when the ODBC header files are not installed (link). To do this, a sudo command is neccessary which requires admin login credentials for the jovyan environment. Since these are not shared, can somebody help me to solve this? Thanks in advance! Cheers,Jan-peter

Hi all,I would like to combine the MERGE_EVENTLOG() and PULL_UP functions, but am not sure how to do this. See the full problem description below.We are looking at a use case where we want to visualize the customer interactions during an order. We are here combining two case tables and two activity tables, using the Multi Event-Log (MEL) functionality:Celonis Data Models-MEL Simplified (2)841231 6.7 KBThe first Case and Activity table represent Events logged on a customer_id level (red)The second Case and Activity table represent events logged on an order_id level (orange)We succeeded to create an OLAP table where we count the number of inbound interactions during a order, i.e. interaction timestamp falls between order_start and order_end. We therefore used this code:SUM( CASE WHEN DATE_BETWEEN ( <%= MergedTimestamps %>, PU_FIRST("order_case_table", "order_activity_table"."order_timestamp"), PU_LAST("orde

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!

Hello all, I try to find out, how to best measure fully automated vendor invoice management documents (can also be any other document head). I found a way to measure measure documents, that contain at least one manuel user interaction: COUNT(DISTINCT CASE WHEN CASE WHEN "_CEL_VIM_ACTIVITIES"."USER_TYPE" IN ( <%=manual_user_type%> ) AND "_CEL_VIM_ACTIVITIES".ACTIVITY_<%=language%> NOT IN (<%=whitelist%>) THEN 1 ELSE 0 END = 1 AND MATCH_ACTIVITIES("_CEL_VIM_ACTIVITIES"."ACTIVITY_DE", NODE['Gleiche Rechnung aus (VIM)']) = 1 THEN "/OPT/VIM_1HEAD"."DOCID" ELSE '' END ) This works as single kpi and on a line chart. When I try to apply a somewhat similar logic for automated documents, I get the expected results as single KPI, but in the timeline I get like twice the documents. COUNT(DISTINCT CASE WHEN MATCH_ACTIVITIES("_CEL_VIM_ACTIVITIES"."

I would like to add the Celonis diagram shown below. It shows the lead times for a group of labels. The labels are to be grouped here.I would be interested to know if it is possible to show the grouping of such attributes and if so how do I implement this? Many greetingsLaura 

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.

Hello Team, I wanted to monitor few data pools and I have already enabled "Custom Monitoring". I wanted to build some KPIs and analysis on daily APC usage. Can I get to know more details on how I can build the KPIs and analyses? I kindly request some more detailed information on this topic "Custom Data Pipeline Monitoring". I have already went through the help page on Celonis. However still need some more information. Best Regards,Aditya

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