Product Q&A

Hi, i'd like to count how often cases circle in "waiting" activities. Specificly: How often do cases go from a node like %WAITING% directly to a node like %WAITING% - excluding the source node as target node. Problem: My solution SUM(MATCH_PROCESS(...)) doesn't count multiple waiting loops occurring within the same process but only processes with a waiting loop.Problem: I have no idea how to exclude the source node from the target nodes as both work with the same wildcard. I'm curious for any suggestions for a solution :)

Check Price & Condition, GR with POInvoice ready for paymentcheck price and condition with outline agreement

I have tried looking in the Celonis documentation for a fix but I cannot see this 'succeeded' status explained anywhere. I do not know how to get to the next steps to perform transformations and include the data into my Data Model.

Dear Task mining experts, what are the best practices for Task Mining projects. Like do's and don't, how to start, how long to run data capturing, ......? ThanksBRTimo Peters

Hi all, I'd like to know how to fetch data from data in data pool via pycelonis. Usually I'm using read_excel or read_csv module in my local python but don't know how to read database column from pycelonis. Does anybody know how to do that or sample code in git-hub? Thanks 

Need help to join 2 SAP S/4HANA tables in a data extraction job with child table key value (16 digits leading zeros) and parent (10, 1 leading zero) are formatted slightly differently Tried using Data type conversion CAST_TO_STRING, syntax seems OK, but get error when executing data job: Error setting up extraction. Illegal join path configuration. Used resource neither child nor parent [CAST_TO_STRING(DFKKZP] - [DFKKZP] / [DFKKPOH]. Celonis Support ID: 2b8cab5b-7442-41cc-9878-77ef645eeed1 Able to help?

signup

My hypothesis is because of how the data is setup but wanted to understand why this is happening and how we can fix it.

Hi,In Celonis Studio, I have two different data models: one for AP (Accounts Payable) and another for P2P (Procure-to-Pay). I would like to create a filter on the view that allows me to display documents that have been paid on time or paid late. When I try to apply the filter for the AP model, I receive a message indicating a lack of connection with the corresponding table in the P2P model. My goal is to create a filter that, upon detecting the "paid on time" or "paid late" status in the AP model, will automatically display the documents corresponding to that status in the P2P model. Is there a way to filter documents based on textual values across both models simultaneously, despite the lack of connection between the tables?

I have noticed that Nestle is one of the references. Can you please share what their use case is?

Limited data from client. Header level information/meta data not available. So in case there are 2 activities performed for a single case, the case keys are getting unique but in practical terms, it is duplication.

Hello Celopeers Community, I want to delete or clear a specific range within a table via the Excel Action Flow Module. There is a module which can delete seperate rows but therefor I have to combine it with a repeater.  Is there a way to give a specific range as an input in order to delete these rows? I want to avoid to delete and recreate a new table becase I need the same table IDs for further processes. Many thanks in advanceJan

Hello everyone, Could someone please guide me on how to migrate from C4C to EMS? Or point me to the appropriate documentation, as I can't seem to find it? Thanks in advance.

We have an extractor set-up, but had to manually input a table. Now, we can't call such table in the extractor's data connection schema because it is in a different scope (manual uploads require a global connection, hence the different scope ).

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,