Product Q&A

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   

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?

hi i am beginner in celonis .i watch (beginner )all videos .i can understand how to make app but i still confused if i make a new app then how can i start... i need someOne help me to make any project process Mining

Hi Guys, i have the following PQL Code "TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM" );" I want to sort it by the count values, so that the most frequent value is the first one and the least frequent value is the last one. How can i do that?

I am trying to fetch real time information from Oracle EBS and want to use Action flows to send an email if there is any entries being wrongly created. While using EBS Node to connect the DB , it looks for a connection.I created the connection , but the same do not appear in the list. Anyone - Have you ever connected Oracle EBS from Action Flow Node? please Help

In other tools, I would crop the process, export the new event log for the cropped process and import the new event log back as a new process. Is there a smarter way of doing that in Celonis? If not, is there a way to export the adjusted event log from Celonis?   

Hi @all, We have a Data Pool with 2 Data Models: Data Model “ECI Data Model HTD - TABLES - TEST” has been duplicated from the Data Model “ECI Data Model HTD - TABLES”. If we do a “Manual - Complete Reload” of both Data Pools, the load times are very differents: “ECI Data Model HTD – TABLES” --> 34 min “ECI Data Model HTD – TABLES – TEST” --> 21 min  Apparently, the load time of each of the tables is very similar:   If we do a "Manual - Partial Reload" on both Data Pools of a table that only contains 87 records, the load times are also very differents: “ECI Data Model HTD – TABLES” --> 19 min “ECI Data Model HTD – TABLES – TEST” --> 3 min What could be due to these differences? As we said before, the Data Model that has the best times has been duplicated from the previous one. Thanks in advance!

‘On Account Cash’ process is related to Account Receivable only with following business scenario – ‘On Account Cash’ sub-process comes into picture when there is one or multiple invoices issued to customer and customer made partial payment which is NOT equal to cumulative outstanding amount.In this case, say there are three invoices with amounts $20,000; $30,000 & $40,000 that need to be cleared with a partial payment received of $70,000 from customer. This amount received remains as ‘On Account Cash’ on the books until it is manually coordinated with customer and applied in system using SAP TCODE FEBAN.The related SAP tables in SAP I came to know are -BSID – contains information on total outstanding amount for customerBSIS – contains information on balance un-applied (‘On Account Cash’ available to be applied manually) per customer If there was any savings achieved in this area for any of the Celonis clients, it would be great to present as a success stories as required in this a

We are trying to connect Celonis with Microsoft Dynamics 365 on the client side. Is there anyone who can help with this? The online documentation is not very useful as it talks about Action Flows only which comes at a much later stage.