Product Q&A

Hi guys,  im looking for a way to obtain data from a different table which is not directly connected to my main table, therefor i need a PU Query.  Example: Table 1: Part TableTable 2 (not connected): Part Specials Table with each x rows for 1 Part. Here I want to check if the part specials table has a specific value in in, for example 'TestA', since the values in part special dont have a strict order I cant use PU_FIRST or PU_LAST.  Do you guys know a way to get the information from that table? Thank you and best regards

Hello, we are currently playing around with OCPM on a non-sap system.We want to add aditional columns from the source table to the OCPM Object. However, we would need to add each as a custom property. Anyone found a solution to add them all similar to "select * from sourcetable"? Thanks for the help! Best regardsPatrick

Hi all, we would like to know if it is possible to select multiple items in a table within a view (see screenshot) and then start an action flow only once gathering all the different items instead of starting the action flow for every line seperately. Thanks and best regards,Sarina

Sustainable Procurement with the Sustainable Spend Management App 💰 With the new regulatory pressure, such as the German Supply Chain Due Diligence Act procurement teams need transparency across their supply chain when making complex buying and sourcing decisions. Which is why the Sustainable Spend Management App was created.  The Sustainable Spend Management App is built for procurement teams to: Allocate spend based on environmental, social and governance criteriaIntegrate various data sources Ensure teams can quickly and intelligently identify and remove spend associated with high-risk suppliers Improve rating coverage among their supplier base The App was developed in collaboration with Ecovadis, a leading sustainability ratings platform, and IntegrityNext, a leading cloud based supply chain monitoring and ESG risk management system.  Want to learn more about how the App works? Visit our website for more information.  Kind Regards,The Celonis Sustainability Team 🌍

I've also tried to create an Action Flow connecting to Celonis, using the Application KeyI get varying errors, from 401 to "Invalid Application Key"(which should be valid, I copied it from Admin and settings->applications after previously creating an asset. Weirdly enough I have made a successful connection to Slack 2 months ago.

My SAP team added new fields to a table that I extract for process mining. My delta loads have been failing. Do I need to initiate a full drop and reload? Will that then pick up these new fields or is there something else that I need to do?

Good morning Everyone, We have recently started to build an Action Flow that consists of emailing users regarding invoices that have Cash Discounts available. We have managed to build it successfully up to the part where we want to have a .csv file in attachment. As you can see here, the file that we get as an attachment has an odd encrypted format: Could you please point us in the right direction? Nothing we've found in the available documentation / Celopeers community has helped us tackle this This is our Action Flow setup:This is the Skill setup:  Thank you so much in advance, we really appreciate it! Best Regards, Vasco Carona

We are trying to compare the number of sales orders versus the number of invoices(AR starter kit) for all the sales orders considered in the Order management start kit. How to create a link between the sales orders and invoices in order to match the number of invoices against all the sales orders created

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,

Hi, I have hopefully a quick question - can I, within Views, define that a component isn't filtered with selection the same way I can do within Analysis? Thanks!

We are trying to generate a table which contains n rows starting from 1 to n where n is dynamic.  we tried the below code, but it creates only 9 rows from 1 to 9. //code insert into supplierNumbers (num)WITH RECURSIVE NumberSeries AS (  SELECT 1 AS value  UNION ALL  SELECT value + 1  FROM NumberSeries  WHERE value < 20 )SELECT value FROM NumberSeries; // is there any way to overcome this?

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 created a new space in studio to analyse master data changes in SAP, The data integration part is successful and the data model along with activity and case table also seems to load successfully. But when i use the same data model in studio, it shows that the tables have no rows.  Can anyone please help me. I have been trying to solve this since last week and still cannot figure out. :( What am i missing?  

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

Hello! I'm having trouble understanding how to use the training / free plan environment with my own data. There is a guided tour that uses demo data set, I went through the beginning of it but don't understand how to create a project with my own data... I have a CSV file with an event log example. This is what I have tried so far. Go to Studio, create a new package, first step is "Choose Data Model". There is no option to upload a file and only the demo models are available on the list.Go to Business Miner. It shows a message about "Setting up Project Workspace", click Let's Get Started. Select Process Type = Other. This takes me to a screen that has "Choose your Data Model" and it has an "oops" message (see screenshot) saying to "contact your admin". There is no "admin", I'm just by myself trying to learn things... Click on Data, then Data Integration. This shows some kind of diagram with an item "Connect