Solved

Upgraded data integration release date? I read a while ago about the new changes to the data integration section in the Celonis EMS. I can't find if there's any date set when the update goes live. Is there a date set? Thanks in advance

It is already possible to execute data jobs and data models. But I have not found anything for schedules in PyCelonis Docs. The reason I want to do this is to distinguish between an automatic execution via DI/Python schedule or a true manual one with a "real" user behind. If I execute a data job via Python, it will be shown as "Manual Execution" in the logs. Best regardsIrfan

Hi All, I have a quick question and I tried to find out on Celonis help but could not. I am trying to create an action flow which can access different data models to make a consolidated report (we have multiple instances of SAP)SO instead of creating 5 different action flows, I am planning to implement only one. Could you please guide if that is possible and and if yes, how? Thanks!

Hi,  I had a permission error when installing a Python library on Machine Learning Workbench, and when I tried to run the command with sudo, I was asked for the password for Admin permission (Jovyan), is there any default password for the super user? 

Currently, my client have a list of user IDs that we update weekly and upload manually. I would like to automate this process. We are currently considering these two methods.1. PycelonisCreating a script using the Pycelonis method maybe is a good idea and I found this answer.upload parquet file and refresh data modell automatically (celopeers.com)2. Action FlowI have not looked into this in detail, but I am wondering if it is possible to use a module such as HTTP request to upload a file, for example. I would appreciate any advice you can give me on the above, especially the second one.

Hi,I would like to achieve an Action Flow where an Email would be send to the corresponding users/customers based on Customer or company code column value. ( for example, Based on the Company Code Value (say A), the email should be triggered to customers belonging to A. Similarly for other company codes say B,C, etc.). How can we implement a dynamic filter for the above requirement to send mails accordingly. Currently, we are doing it manually for every company code using router. Please find the screenshot below for reference.Kindly let us know how to proceed further. Thank you in advance :) FYI : @reenu.josep12​ 

When installing the JDBC extraction software, still Windows Server 2012 R2, which will be discontinued next year, is preferred (see Step 2- Setting up the SAP Extractor Service (celonis.com)). For durability reasons and company policies, we want to install in on Windows server 2019/2022. Has somebody experience with these versions and the working of the software, can we guarantee that the extractor software works on windows server 2019/2022?

Hello Experts,Is this possible to implement section access control for EMS data models?e.g. we have a process data model and other assets linked to this dm.We want to restrict business users using case field let's say company code.So users belonging to specific company codes can access only respective codes data.This feature is available on on-prem but couldn't find similar on EMS.

I've currently got a view I'm building out for some data management and want to highlight/change the background color of cells which fit the criteria for "bad values", based on dates. This is currently where my YAML lies. I've tried searching through the Celonis Documentation and haven't found anything in regards to comparing dates. I've also tried searching for YAML documentation, but I haven't found anything which satisfies what I"m looking for.

Hello everyone,I am currently trying to convert a duration of minutes (integer) into the datetime format (hh:mm). Like this: 60 --> 01:00120 --> 02:00150 --> 02:30 Is this somehow possible within PQL? I looked up a few answers online, but they often include functions that seem to be not supported by PQL.

Is there a way to add a vertical line to a chart in an analysis that signifies a "go-live" or a specific point in time? This is needed to help track KPIs before and after a specific go-live or other milestone.

In the body of celonis process automation skill module. it is not considering styling part of html code, is there any possibility of adding styling ?

Hello, I would like to know if its possible to get a count of all the flows that are in total in the whole Process explorer. (Including all reworks and cases flows). To show it in a Card.

Hello everyone,i have a small problem with the representation of activities in my Celonis. For some reason a few activities are not in order when i look at them via the Variant/Process Explorer. However, if i look into my data via SQL Vertica in the Data Jobs, the Activities are in order. I believe this, because each Activity has a sorting number (descending). Usually i would expect the Activity/Process Explorer to show me the Cases in accordance with their sorting number, however this is not the case for every activity/case. Some are Ok, but some don't fit. Is there any (easy) solution for my problem? What causes this deviation?

Hi ,I need a tech support here. Here is the stiation. I have cases like Case 123Activity 1 - Attribute A = XActivity 2 - Attribute A = Y Case 231Activity 1 - Attribute A = WActivity 2 - Attribute A = Z Case 321Activity 1 - Attribute A = QActivity 2 - Attribute A = X Now I need to create an olap table likeCAse 1 -Attrubute A - Case 2123 ------- X ---------321 because their both Attr. A = X right ?but how ? I think domain table is not for it.

Hi all, Now I'm checking Celonis feature and I found delta/full load option when I try to execute data job with data connection. Does anybody know how to use and how it works? I Checked document portal but I don't find any technical suggestion.  Best regards,

Hi expert,​I have a question about Celonis Analytics and View in what case I'm better to use view.I have already understand below post and understand basic difference however I don't think there is dicisive difference between each other... Does anybody explain what business case I need to use view and analytics properly? ​https://www.celopeers.com/s/question/0D50700000GC71TCAT/what-is-the-basic-difference-between-view-and-analysis-in-studio?language=en_US Thanks in advance,

Hi , We have a requirement where we want Celonis to automatically pick a XLSX file from a folder, upload the file , create a table and execute a data Job. IS this possible ? How do we accomplish this ?

Hi expert, I have a question about delta load. I know if I use data connection, for example SAP to Celonis, then we can use delta load option. However, in manual data connection pattern, download data from one to upload to celonis, do we have any option to delta data load? If yes, could you guys let me know where I can find technical document of that? Thanks, 

Hi expert,​This is just simple question, does any body know how to add sequential nuber to OLAP table?​Col1 col2 col3 ...1 aaa bbb2 ccc ddd3 eee ffff4 ggg hhhh↑this one.​This is good for discussion because I can say "line #1 and 3 is something wrong.​..."  best regareds,​​

Hi expert,​now I'm creating internal training contents and stucked how to explain what is case table in simple words.I know what is it and how it works but I cannot explain difference between case table and transaction data. Can I say case table is a part of transaction data and case table is just what you wants to see in your analysis board, or is there something add?

I would like to dynamically change the value of Load Script (Analysis settings) using variables. Switching the filter on/off according to one's choice. But, i am not able to achieve it. According to the documentation, variables are not accessible in Load Script. Can anyone suggest how to achieve this.? https://docs.celonis.com/en/load-scripts.html