Product Q&A

Hi all, I have been trying to use file upload method to upload the source data, however, i often find that the original event log has a lot of duplicated activities (same timestamp or near same-time timestamp) which created a lot of "noises" in the analysis, for example: Create Purchase Order 2021-01-01 01:00:00Cerate Purchase Order 2021-01-01 01:00:01 This kind of "duplicated" activities are less likely to be performed by human, would you please advise if there is a way to de-duplicate records that happened within a very short timeframe (say 1 s) with all other fields having the same value? Also, as I have been trying using different file and thus this occupy much of my data consumption, may I know is it possible to remove the file uploaded and release some capacity for other analysis? thanks in advance!  

Hi, I am trying to extract ObjectId from MongoDB via python. If I extract without ObjectID, extraction is successful. But when i am adding ObjectID into extraction I have started getting an errors. Can you please give me a solution/syntax?

Where I can get the transformations jobs for APC Data Consumption Monitor? In EMS Store I can only see APP not the connector.

After TM installation and data capture (including screenshots) where can we visualize the screens? And data is hashed?  Another concern is about data security. How to demonstrate to customer that data is protect and privicy is been follow?

Hi everyone, I hope I'm in right here with my question... We have Celonis 4.7.1 installed with production data, need to migrate the Potsgres databases to MS-SQL and are interested in documents on how to do the steps. Has anyone done this migration before? Regards,Daniel

Hi Team, The following problem was not solved, so when I tried using the connector for ECC, I was able to extract the data. https://www.celopeers.com/s/question/0D507000012uUWHCA2/how-to-resolve-errors-when-extract-tables-sap-connector Would you know that there is something issue with the S/4 HANA connector? Best Regards,Omachi Satoshi

Hi all, I was wondering if it is possible to create dynamic sql in transformation. I tried to use loops and define sql variables, however I didnt have any luck. I have never worked with Vertica database and seen some place that vertica has no loops, no arrays, no variables just a plain SQL database. I am not sure if thats true. Is this a limitation of a some kind? Thanks.

I want to know the status of our Partnership & Partnership certificate with Rsystems Inc.

Hi, I am currently using the Machine Learning Platform on Celonis to read a csv file using pd.read_csv which has been working perfectly until I had to update it with a new csv file.  There's a weird problem where, when I read_csv the file in the Jupyter environment all the data is thrown into one column. It's even more odd because if I view the csv file directly on Excel or by opening it on another tab in Celonis Machine Learning, all the data seems to be formatted correctly into a table.  So, I'm not sure why it's suddenly reading everything into one column. Thanks,Terence

Extractions - Performance issues Hello, I am extracting data from a ServiceNow system. Sometimes it's quick and sometimes it takes a long time. To the point"Final Count: Loaded..."everything is always ok, but for the last steps "Starting load incident$sys_audit to target ..."until"Extraction successful"it is very different. 2022-01-11 08:59:15 INFO Extraction successful2022-01-11 08:59:15 INFO Table incident$sys_audit loaded ..2022-01-10 21:36:52 INFO Inserting extracted data into the Data Pool (this may take a while)2022-01-10 21:36:52 INFO Starting load incident$sys_audit to target ...2022-01-10 21:34:18 INFO Final Count: Loaded 5,450,395 record(s) for table incident$sys_audit2022-01-10 21:33:53 INFO Loading 12,276 records for table incident$sys_audit... In the best case, it takes 20 minutes and in the worst case >14 hours for extraction to be successfulWhat can be the reason? How can it be fixed Thank youHeiko

Hello,I would like to create a benchmark exactly as it is done in the Accounts Payable analysis (found in both the training and the Sandbox), but instead of comparing the Companies (or other attributes) I would like to define two different time intervals. Ideally, I would like to insert two Date Pickers, one for the left part of the sheet and one for the right part, and therefore be able to define two different periods. Thanks to anyone who will give me some advice or best practices for my question

I am using the C4C+ for a sales pitch. While working with the conformance checker, came the question that Is it possible to set some business rules for process model. For example, when attribute x > 100 follow an approval path 1, else path 2 ? And See if both paths are conforming to their respective business rules?  

Hi all, I am trying to use the e-mail module in Action Flow and I need to add a connection using my SMTP server. These are the configurations that I should fill but when I fill these configurations, it gives me an error like that :Is there anything that I should do before filling these configurations or in general how can I use my SMTP server in my Action Flows? Thank you,Ugurcan

Currently using 4.5 version, how to upgrade to a newer version?

My organization is currently using 4.5 version, please help me out in upgrading to a newer version. 

i have a column that contains date and time , i want to increase the time by 5 hours 30 minutes for each cell what would be the syntax for that . thankyou

Is there a Coupa license needed to install Coupa Cloud Connector? The option is inactive with mention of license missing. Has anyone encountered this?

I'd like to create a histogram that shows me the distribution of certain activities across a calendar year (Jan to Dec), independent of the year it happened. In other words, if such an activity happened in March 2019 and March 2021, it would count as "2" for March. This simple chart works fine if I have at least one activity for each month of the calendar year, like shown here. However, if I don't have it, like in this case, the chart 'falls apart', like here:I was wondering if one of you had an idea on how I could 'lock in' such a 12 month x axis.(Icing on the cake would be if I could show month names, like Feb, instead of numbers, like 2) Thanks!

In a data model there is no direct connection between two table and also with intermediate table in between we cannot achieve 1:N relationship.Is there a way to view the columns of both the table side by side without disturbing the existing Data Model table mappings.Can we make use of Knowledge Model here?

I'm creating the column chart and I'd like to change the intervals between numbers on the vertical axis. Could you please tell me the way?

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.Best Regards,Vahide.

Every time I access Celonis login screen, my PC starts going crazy; CPU and GPU usage up +50%, draining memory and fan spinning like a jet engine. I am pretty sure it is caused by the fireworks animation that adds no value whatsoever.Once I pass the login screen and land to Celonis main screen, everything goes back to normal. So not a big problem. But it is kind of annoying that it happens every time I try to use Celonis first time in the day. Checked with my colleagues and they have similar experience.I only experience this kind of problem only for Celonis login screen. All other web sites work fine. Can you stop this animation please? It's not adding any value, in fact, it deteriorates our experience.

Where to get the planned roadmap of Celonis?  In particular I will like know more about the EOF of Action Engine, future of Skills, evolution and improvements in Action Flows, ...

How can i license for snap+ as snap does not have full features