Product Q&A

Hello, I have the following problem when PQL query tables from my analysis (PyCelonis version: 2.5.0): After identifying the required space, package , analysis and sheet, I specify the required table:olap_table_HistoricPOs = published_sheet_OpenPR.components.find("#{Historic_POs}", search_attribute="title") ... and query the table:olap_query_HistoricPOs = olap_table_HistoricPOs.get_query()olap_query_HistoricPOs Some columns are read correctly:(name='_CASE_KEY', query='"freitextbestellung"."_CASE_KEY"')and others are not. These get a hash and a brace like this:(name='#{order_items.SUPPLIER_NR}', query='"order_items". "SUPPLIER_NR"') This incorrect naming is kept in the subsequently created dataframe:df_historic_POs = pql.DataFrame.from_pql(olap_query_HistoricPOs, data_model=data_model) and leads to an empty df in the further notebook:df_references = {}df_references['historic_POs']= df_his

Recently we decided to activate the SCIM functionality in Celonis so that user and groupsare provisioned automatically by the identity provider. Unfortunately it is not working and no connection to the Active Directory can be established and the functionality is not working. Are there any specific settings that need to be set in the Active Directory so that SCIM API can work as intendet?

 The Celonis documentation does not specify passing the proxy configuration to docker. I don't know if the way to pass it to docker is to add one more line-e PROXY_ENABLED=true \\ -e PROXY_HOST=<host>, etc. Or how it would be since it depends on how the Docker image has been mounted. 

How to schedule an action flow to trigger on a particular day? we are not using knowledge model.

Dear all, I would like to use Action flows to push an excel file (xslx) to Celonis using Action Flows.  Use Case: Excel file is received via email and up until now manualy uploaded to a data pool. I am successful in accessing this email, downloading the excel file.  I am following this tutorial to learn how to push a CSV file to a data pool. Create and Push CSV to Data Integration (celonis.com) However, it does not work for XSLX files for me. I changed the file type already to "XLSX" and "EXCEL". Error is: "something went wrong while handling the request. Please contact Celonis customer support. Celonis Support ID" I also tried to find a module that would help me translate an excel to CSV but could not found anything. Thank you,Gregor

Documentation of conditional filters Hi @mentor.vucit​ , I just came across your answer (link) and I am wondering where I can find the documentation of conditional filters? They seem very powerful but I can't find any of this in the celonis documentation. BR,Florian 

This is how is set in the documentation:  and this is how I set the module: 

Team, I am using Content CLI to Pull and Push assets between different EMS. Is there a way to overwrite only one asset when pushing to a different EMS? I can see there is an option to overwrite packages with "--overwrite", but we want to push only one asset multiple times. Best regards!

Hi, i want to create in Open Order View (Open Order Processing) a Dropdown List where i can select a ORDER_ITEM Record which sets the X-Axis on a Graph. My problem is that it doesnt accept the variable as an axis, but if i use the record itself it works

Hi Team,We are working on reviewing our landscape with respect to Celonis best practices.Currently we have multiple data pools and extracting data from multiple connections.In many cases we can have a situation where:1)Getting data from same connection but using extracted data for different data models.2)Getting data from different connections and combining extracted for single data models.3)Often times buiness requirement for same process may vary for different units and they would want to see different views / analysis / actions for them in those case how the data pool should be structured. Are already there best practices along these lines with pros and cons?

Dear Celopeers, We have an SAP On-Prem extractor which make RFC calls with multiple SAP systems within our organization. We want to now add a new connection/SAP System but the connection has to be SNC. We already have the instructions for setting up SNC, but the question is Is it possible to use the same extractor and configure so that only one system needs an SNC and others work without those server certificates? Or If we want to add a new connection/system with SNC setupeither we must have the server certificates imported for all the existing systems or we we should have a separate extractor with SNC?  How does this work? To clarify, only system 3 in the picture needs an SNC. 

In one system I have two processes with two number logics. First one is called S_ID and shows Process A ("From Receiving Technical data to releasing technical data for invoicing". 2nd one is called "L_ID" and shows process B "Creating data set to invoice sent"  If data has status 4 in the system, the data has been transformed from process a to process b and every s_id is combined with a L_id.  I checked with a table if ir possible to see status4, s_id and L-id in one table and cheked in the source system if the data is correct- it is.  In the Data model I created two activity tables and zwo cases tables, one with S_ID logic, the other one with L_id logic.  The last step should be to combine the data so the customer is able to see the whole process from receiveing the technical data to invoice sent.  I tried it with this script, and I know it is not correct yet:  case when"TableS_id"."STATUS"= 4then Bind("TableS_id", PU_first(&

Hi all, I'd like to calculate through put time of workday, I have a table that contains holiday. I found something workday setting but I'm not quite sure how that is work. If anybody know something like this, please give me advice. Thanks

I am trying to extract the date from a string. the date comes after '-'. The challenge is that there can be more than one instance of '- '.So, tried to find the '-'followed by a space and '/'after 3characterString sample: $$$$$ $$$$$$$: $$~$$$$ - $$$$ $$$$$$$$ $$$ $$$ ~$$$$ $$$$$$$$ $$/$$/$$$$ - 07/01/2022 $$$:$ $$$:$ $$$:$.$ ( i want to extract the date after the second '- ') Code I used:(code gives me error)CASE WHENMATCH_PROCESS_REGEX ( column, '.*- .{3,}/' )=1THEN TO_DATE(RTRIM(RIGHT(STRING_SPLIT (column, '- ' , 0),11)),FORMAT ( '%d/%m/%Y'))ELSE NULLEND Thanks In Advance

Hi all,is it possible to extract large object data types from oracle to celonis ems with jdbc extractor? Thanks,Markus

Hello, I tried to start the Get Data into EMS partner exam today and it stated I only had one attempt remaining. As far as I am aware we are supposed to have 2 attempts. Is this message showing because the attempts are counted as "1" and then "0" remaining?  Or is it because I passed the "Build Analyses" exam earlier today and I was supposed to wait a little bit more?

I'm looking for an easy way to import previously used KPIs, Variables, etc. from analyses and importing them into Knowledge Models. I remember there was a way to do it in PyCelonis 1.7.6 but I seem to have lost the post where I previously asked the question and I cannot find the script I used as well.  The idea would be to make it much easier to create knowledge models without having to manually input all the data points. If there's a catalog/repository of all the formulas/variables/etc, should be able to mass insert them into a knowledge model.

Notwithstanding the Custom Built Templates, which a user can create themselves in Views, is Celonis intending to release a 'Dashboard Catalogue', which new joiners or even existing can utilise (i.e., prefabricated dashboards)?

How can we only display cases that are currently in a particular activity? We have tried using PROCESS EQUALS TO & SOURCE / TARGET ACTIVITY functions to filter and only display these cases, but they fail due to the following... The 'current' activity is irrelevant for PROCESS EQUALS as it technically hasn't been reached yet (e.g 'Verify Invoice' is in progress but not actually complete, so it wont appear as a triggered activity in the log) There are multiple routes in our process that lead to this 'current activity' that also have many routes out to other activities. This means that both PROCESS EQUALS TO & SOURCE / TARGET ACTIVITIES cant be used to filter out just cases relating to the current activity, as they require singles routes with a clear starting point (Activity 1) and end point (Activity 2) to work effectively, not multiple possible paths.  We also want to calculate how long this case is been in the 'current activity' but run in to

I am using router to put condition but it is sending empty file as an attachment which should not suppose to happen.

Hi all, I have setup an Action Flow that extracts data from a data model containing several fields and filters. The result is used to generate a CSV file.At the end I get a table containing a lot of duplicates.I haven't found any setting in Query data nor in CSV Advanced to filter out complete duplicates. I also haven't found any other module I might can use after CSV creation to remove duplicate rows. Do you have any idea how to get rid of duplicates? Thanks,Dennis

Currently, we have extracted files by SAP table as follows and uploaded them.    It then asked me to select a table to use, which I did as follows  However, I'm stuck on the part where I specify the activity table. When I uploaded using quickstarts, celonisEMS automatically created a table called "_CEL_P2P_ACTIVITIES", but I don't know how to solve it when I proceed with a normal upload.  If you know of a workaround for this, please let us know!Thank you!

I'm trying to plot a simple vertical bar chart with it's labels displayed above each bar, but I can only plot it horizontally the way I want, otherwise the wrong information goes into display... Any idea how I may overcome this? This is what I have at the moment:And this is what happens when I swap its axis:How should I write the YAML marks and encodings to sort this out? 

Hi, I have an eventlog, with two IDs: JR ID and App ID. JR ID is always present, whereas App ID is only present in certain activities. The relationship between JR ID and App ID is 1:N. I have created a new ID as a combination of both, to use as my case ID for the eventlog. Then i created 2 eventlogs within Celonis using simple formula:  EL_APP:CASE WHEN "Eventlog"."APP ID" is NOT NULL then"Eventlog"."ACTIVITY"end EL_JR:CASE WHEN "Eventlog"."APP ID" is NULL then"Eventlog"."ACTIVITY"end The idea behind is to show a transition between both newly created eventlogs. Sadly, Celonis doesn't find any common ground for transition and both the eventlogs are shown without any transition. So my questions is: On what basis does two eventlogs create a successful transition? What am i missing here? Sadly this link doesn't help me with my investigation. https://docs.celonis.com/en/process-explorer.html#UUID-fa936c2