General Product Q&A

Hi Team, I have Two Data Pools, Data Pool 1 & Data Pool 2. Now, i want to merge / add Data Pool 2 into Data pool 1. Data Pool 1: Transformations are having extra logic compared to Data pool 2. Tables used in Data Model are same for both pools.

Hi all, ​I would like to create analyst user to chcek appearance of each roll, does anybody know how to create user without mail address? I can only see 'Invite user' option at user setting screen. Thx,

I know that the forum is aimed at the Celonis product, but would anyone know which table.field in SAP has the information on the date of creation of the Contract?

The question is related only to OnPremise version of Celonis, not EMS.

how to get badge after completion

I have a time stamp in the below format in a spreadsheet YYYYMMDDHHMMSSMS. When i try to upload this sheet the MS part is cutting out. How do I upload timestamp with microseconds?

Hi all, According to the documentation, if i extract new and changed records of a table Table with delta extraction, I should be able to access to these data using the placeholder <$Table> in transformation tasks. I'm trying to set up a delta pipeline, but my transformation ends with errors, because the placeholder <$Table> seems not to be recognized, even if I launch the tasks in delta mode. I have already set up delta extractions and I am doing mock trials to understand the error, which I paste here: If I reference the placeholder with <$Table>, I obtain "ERROR: Syntax error at or near "<" at character 101".If i reference the placeholder with "<$Table>", I obtain "ERROR: Relation "<$Table>" does not exist". The structure of my delta transformation is: CREATE TABLE TMP_Table AS (  SELECT     Field_1,    Field_2  FROM <$Table>); What could cause this error? Am i missing some further configurati

I have values in a column like 90, 100, 30, sixty, nienty, sixHere I’m looking for a function/way we can convert sixty, nienty, six to 60, 90, 6For now I’m using regular expression in case when to define the numeric value of text.looking for more suggestionsThanks in advance!

I am experimenting with the use of variables in Celonis Studio. To represent a simple case, I have created a variable named Generic_Title in the settings as Text/Replacement variable, which I want to output in a Text Component. Unfortunately, Studio cannot resolve it.  Is it possible to do so or are there some workarounds I need to implement?

I am trying to filter the orders that have a partial delivery. Currently I have created a record for this to identify them but now I am unable to transform it into a filter, so I can apply it to tables where I have sales orders that need to be filtered to see only the partially delivered ones. So I tried several ways to do this but it seems I am unable to find the right way. FILTER (CASE WHEN MATCH_ACTIVITIES (NODE_ANY ['Delivery at Customer']) = 1 THEN 1 ELSE 0 END)/COUNT("VBAK"."SUBMI") < 1;

From template we have AR transformation 'Received Payment', what types of documents (BKPF_CLEARING.BLART) can be used for this activity, other than those in the default template - DZ, ZP?

I have an activity in my activity table that can be initiated multiple times. In order to be able to define the activity more precisely, there is a combination of 3 codes which is provided in the activity details. Now, during the process, it can happen that some of the initiated activities are cancelled again. For example, a process flow could look like following: Activity name - Activity detail - Eventtime Initiation Activity - A0/B1/C3 - MondayInitiation Activity - A3/B3/C9 - MondayInitiation Activity - A7/B2/C0 - WednesdayInitiation Activity - A5/B6/C6 - ThursdayCancellation Activity - A0/B1/C3 - SundayCancellation Activity - A7/B2/C0 - Sunday I would like to measure the cycle time from initiation to cancellation of each activity.So in the example shown above from the 1st & 3rd "Initiation Activity" to the corresponding "Cancellation Activity" which would equal 6 (monday-sunday) and 4 (wednesday-sunday) days respectively. How can a

Some time ago, I have defined runtime variables with specific values, which are being used in a bar chart. I now updated the runtie variables' values in the package setting. In the studio, the chart displays the updated values (0€-24.44€, etc):In Apps however, it does not udpate, even though having published the package (still displays (0€-4.99€ etc):  I tried and changed the values again, again it did update in studio but not in apps. If I change other things (e.g. adding a text box), this does appear in apps. Is there anything I need to do which I am missing in order for the updated runtime variable values to be displayed in Apps as well? Thanks a lot in advance!

Hi everyone, I want to use an input box in a view so users can filter a specific table using a runtime variable. When using the input box and setting it to type date, the output is something like 1694728800000. This is saved in a runtime variable, which I am using in a filter for that specific table. However, I couldn't find a way to make the formular work. Example formular: FILTER EKPO.AEDAT = ${{runtime_variable}}  where ${{runtime_variable}} is 1694728800000. Maybe someone can help out with the correct conversion to make use of the date from the input box.  Best regardsAram

I think following are the places where Generative ai may play big role - like for developers it can help with PQL query and for business users it can help identifying exceptions without going into dashboards but still i believe i am missing lot . Your inputs are requested.

How do I add additional instructors to our academic partner account?

How to copy objects from Analysis to View?

How to migrate existing Analysis objects to Views?

Hi everyone, I have a problem in creating an "Exploration" in the Process Workspace, as shown in the following image:  Some questions are not available even if I am an Admin with full access to the process-specific content. How would it be possible to solve this problem?Thanks in advance,Emanuele

Can we extract draft sheet as pdf of a sheet in ML workbench. i had tried using Pycelonis but didn't find any attributes related to extraction of pdf after analysis.draft.sheet

We have observed that the custom connector extracts the change log data of each case individually through separate API calls (not affected by pagination). However, when working with the OOTB connector, we observed that the sys_audit records were accessed by compiling multiple cases into a single API call depending on the batch size defined. Has anyone had any experience with this before and does it affect the source system performance? We have concerns that we might hit the default rate limit in ServiceNow as we are planning to extract a large volume of data.

2 questions: In PI social I am periodically prompted to re-select the User column 1.) Why am I prompted to re-select the user column? 2.) Is there a way to permanently exclude null values within the PI Social component?

Plese add an additional dropdown to the connector (in addition to EU and US) which allows specifying a custom API URL

Hi all expert, I would like to identify all case if it has duplicated continuous activity. This is example of my case below. ...A -> A -> B ...(duplicate)...A -> B -> A... (non-duplicate) Does anybody know good PQL or way how to do this?

Hello,  do you know wheter a schedule (https://docs.celonis.com/en/schedules.html) can be triggered by an external action?In our case, we would need to start an extraction once a SAP job is finished. We could use e.g. an email notification for that.But first I want to check if this is even possible at all. The docs says that the schedule can start at the given time only.Do see there maybe some workaround to have trigger based schedule/extraction? Thank you very much for any idea!Jan