General Product Q&A

Hi All, I'd like to add a button to my sheet that allows the user to automatically filter for the last 7 days, and a separate button that allows the user to filter for the last full week. Bookmark selection doesn't seem to work, since the bookmarks are static. Thanks!

Hello,We have lack of knowladge . We would like to load a process flow like this.Lets assume we have process Flow like that A-> B-> B->C-B->B-> D->B->B->EWhen we do conformance I would like to use A->ANY To ANY -> C Any to Any ->D Any to Any->EI mean Any activity between A->C could be exits. We tried this solution but unfortunately, it didn't work as expected. All of our cases detact as violation. We implement BPMN as below. What we did worng ? Best Regards,Vahide.

Pls see the line 2 & 3 of the screenshot.

When to build an extractor from scratch and when to use uplink connections differentiate?

Hi, I am Manohar and I would like to change email address associated with the account as my earlier email was blocked when I resigned from the organization. Can someone guide me how to change email address and how to login with fresh email address? Thanks,Manohar

I have the six intermediate certifications that were obtained in the previous training program: Celonis App CreatorCelonis Business Value ArchitectCelonis FoundationsCelonis Implementation ProfessionalCelonis Sales ProfessionalCelonis Solution Professional But these certifications have not been migrated to the new program, is this correct and do I need to do anything?

Hi celopeers, I am trying to build out a trend chart that plots the open invoice aging over time. In terms of dimensions I have the following: x axis - ROUND_MONTH(INVOICE CREATION DATE)y axis - AVG(TODAY - CREATION DATE) for open invoices only The issue I'm running into is that since KPI is tied to creation date and today's date produces a strictly negatively sloped trend as shown below, which makes sense in practice (beacuse both axes are tied to creation date), but not exactly what I'm looking for.  What I need to show is the change in trend by month, but that will require detaching the KPI calculation from the creation date, sort of like a snapshot of the KPI at the end of each month, kind of like transformation center did it before. Has anyone successfully accomplished that before? If so - how did you do that? Thanks!Eugene

I am a beginner and want to get certified as Ceolins , can any one please guide me where to start from scratch and where would i find study material

AWS connection from s3 to celonis. Where exactly is the window to enter the key and secret to achieve the connection (the documentation is a bit lacking)

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 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 

---------------------------------------------------------------------------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 =

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

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?

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

We want to highly tailor the demo for our prospect client, is it possible to get the data set and make some customization on desktop?​Thanks!​

This is a standard Accounts receivable data job. it started to get error.  I need to analyz or alter comment to fix it. but it was working as it is (: Other one is this it suddenly started to ignore AUGCP column. but it is still exist. 

Is it possible to customize the mails sent from Action engine? eg: Along with the number of signals(like 23 new signals) I would also like to view the list of the (23)names which has caused the signals, in the mail itself being sent?