Product Q&A

from pycelonis import get_celonisfrom pycelonis.root_cause_analysis import root_cause_analysis celonis = get_celonis() dm = celonis.datamodels.find('c4cb1efc-fa6a-4704-bc51-b3b365c5e796') kpis = {'late_payment': """      CASE WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear Invoice')=0        AND         DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" =       'Create Purchase Order Item'), TODAY()) > 0       AND        DATEDIFF(dd, PU_MAX("P2P_case", ROUND_DAY("Activity"."EVENTTIME"), "Activity"."ACTIVITY_EN" =       'Create Purchase Order Item'), TODAY()) <= 60       THEN NULL       WHEN PU_COUNT(P2P_case, "Activity"."ACTIVITY_EN", "Activity"."ACTIVITY_EN" = 'Clear I

So far, for my company ONTRAAK, I am not able to see who is doing what and with which rights on the Celonis environnements.Thanks in advance ! Olivier Laviale

Error while transforming Data - Quickstart P2P Hello, is there any way to gain further insights while using the quickstart P2P mode? Im having an error while transforming the data and would like to see the reasons for this. Thanks!

I would like to update a runtime variable with the value selected (either AVG or Median)

I am unable to access the trainings required by my organization. I need urgent help

Team, We have to write a code for threshold which can be read as - --Any transaction with an amount (the total of debit line items in a transaction) if less than 1000 then threshold would be <1000, if the amount is less than 5000 then it would be <5000 else >5000. -- We code it with PU_SUM but the concern is that the threshold is getting applied on the total absolute amount (i:e total of debit and credit of a transaction) and then the threshold is getting applied which is not correct.  INSTEAD IT SHOULD SAY IF THE FIELD IN BSEG.SHKZG IS "H" THEN TOTAL OF AMOUNT FIELD CORRESPONDING TO "H" FIELD IN BSEG.SHKZG AND THEN THE THRESHOLD CODE SHOULD BE APPLIED IN CONJUNCTION WITH "H" FIELD .  ANY HELP WOULD BE REALLY GREAT. THANKS.ANKUR 

Is there a way to calculate the throughput time also for negative values (activites in different order) than start -> end in "throughput time search" visualization?Like also having end -> start included in the same visualization, if there are variants that follow different order of activities.The default of "throughput time search" is to only show variants that follow the defined order.My work-around was to create custom datetime columns for the two activities in the case table, and then just use datediff calculation between two columns. But it seems rather clumsy way, and also binning is required to make it look nice..Thank you for comments

---------------------------------------------------------------------------KeyError Traceback (most recent call last)Input In [1], in <cell line: 13>() 29 for sheet in analysis.published.sheets: 30 # if sheet.pql_filter is not None and re.search(find_pattern, str(sheet.pql_filter), re.IGNORECASE): 31 # print ("Sheet filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"]) 33 for component in sheet.components: 34 # if component.pql_filter is not None and re.search(find_pattern, str(component.pql_filter), re.IGNORECASE): 35 # print ("Component filter of analysis: " + analysis.data["name"] + "; Sheet: " + sheet.data["name"] + "; Component: " + component.name)---> 37 if len(component.pql_columns) > 0: 38 pql_columns =

can you please make a video how to integrate the Uplink Integrations also how to create a data connection 

Does anyone know the maximum number of runs an action flow can go through before it error's out? I need one to pull data from slack on a consistent basis without having to manually run it.

Hi @Celopeers .​ , I have created a KPI that filters my Activity Table according to certain criteria. The result shows a list of all CASE_IDs that fulfill the criteria. However, because it's an Activity Table, the same CASE_IDs are listed multiple times. Is there way how I can pull the distinct Id's to list them only once?Thanks for your support

It also cannot add unique ID number as a column the table which i have created before. question1. is there another way to create uniqueID for each row? question 2. how can i fix this error?    

Hi, In an Action Flow I'd like the variable value to be encrypted - ex : value containing a password.  How can this be achieved? Thanks,Bhasker

Which .net version used in Celonis?

business value architect training

 

I'm trying to set a KPI in transformation-center, but it's been loading all the time and isn't reflected.KPIs have a green mark. However, the numbers and graphs are not reflected on the screen.(In the overview, the blue mark is spinning all the time)Can you tell me why?  

I have been able to connect to our SQL server and retrieve the tables I need through a direct connection. However, when I try the same for the Intersystems Cache database I run into an error.The system administrator can see that I pass through the firewall, so that's not the issue. I have the feeling that is has to do with the obligatory Cache namespace, when I setup a ODBC connection myself it only works when this field is properly given.I expected it to work when I configured it like this but it provides the error message showed earlier within a second.Anyone any ideas on how this could work?

Please find below attached error snap 

I am not able to interpret why trigger tables are used. Data that will be extracted on real time, doesn't it automatically be refreshed in all tables?

can you please make a video how to integrate the Uplink Integrations also how to create a data connectioni try to many time but every time i fail  

can you please help me to make a connecting in data pool

Hi all! I'm currently trying to change the formatting of the time-selection in my dashboard. It's currently showing the column from which it's getting the timestamps (see the picture attached). Since this might confuse some users, I want to change this to something like 'Selected timeframe'. The selection can be activated by using the standard timeframe filters in the dashboard. Is possible to change this?

if I run first part then run SELECT ANALYZE_STATISTICS ('BSEG'); it is ok. But if I run complete code it throws exception says 'Execution error: ERROR: Unsupported use of LIMIT/OFFSET clause' what is going on ? it all started when I tried to add field Koart to bseg. I reverted but still gets error for a few days. First part : DROP VIEW IF EXISTS "BSEG_UNION"; --Start of customization section --If you extract new records though Replication Cockpit, leave this CREATE VIEW BSEG_UNION statement and delete/comment out the second one. CREATE VIEW "BSEG_UNION" AS (SELECT * FROM "BSID"UNION ALLSELECT * FROM "BSAD"); --If you extract new records through Data Jobs, leave this CREATE VIEW BSEG_UNION statement and delete/comment out the first one./*CREATE VIEW "BSEG_UNION" AS (SELECT MANDT,BUKRS,KUNNR,UMSKS,UMSKZ,AUGDT, AUGBL,ZUONR,GJAHR,BELNR,BUZEI, BUDAT,CPUDT,BSCHL,SHKZG,DMBTR,WRBTR,SGTXT,ZFBDT,ZTERM,ZBD1T,ZBD2T,ZBD3T,ZBD1P,ZBD2

System requirements of an on-premise Extractor serverThe on-premise server will be running both Celonis SAP Extractor and Celonis on-Prem Agent. For this we recommend the following system requirements:Hardware requirementsVirtual machine or physical serverCPU: Min. Intel Xeon processor with 4 CoresRAM: min. 20 GBi don't have a 20 GB RAM . so its true that i can't connect the data connection please solve my issue i want to try to make data connection but i can't