Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

4438 Topics
P
Level 1
pujari.chara11Level 1
asked in General Product Q&A
signup

signup

14
alessio.vasin
Level 2
P
Level 3
pavan.abburLevel 3
asked in General Product Q&A
I would like to filter (select) certain activities flow, however instead of the activities appearing in the "Activity Selection" or "Process flow selection" sections, they are appearing in the "Attribute selection" tab/section.

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

151
B
Level 1
wojciech.brol
Level 2
wojciech.brolLevel 2
asked in General Product Q&A
Hi,Is there a way to filter documents based on textual values across both models simultaneously, despite the lack of connection between the tables?

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?

31
abhishek.chatu14
Level 7
M
Level 3
mpho.matheLevel 3
asked in General Product Q&A
I have noticed that Nestle is one of the references. Can you please share what their use case is?

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

51
V
Celonaut
C
Level 1
chakshu.raj12Level 1
asked in General Product Q&A
Primary keys has duplicates owing to the set of data received. However, the composite key is still unique. How can we resolve this issue?

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.

111
H
Level 1
jan.tran
Level 4
jan.tranLevel 4
asked in Process Improvement
Celonis Action Flow -- Excel Module -- How to delete or clear a specific range (e.g. A2:G8) within a table via Excel Action Flow Module

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

33
liam.gonza
Level 2
F
Level 2
fabien.bouquLevel 2
asked in General Product Q&A
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.

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.

13
F
Level 2
R
Level 3
ricardo.ribei11Level 3
asked in General Product Q&A
How to get, within the same data pool, tables from one scope to another?

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 ).

254
janpeter.van.d
Level 8
J
Level 3
jurgen.gakovLevel 3
asked in General Product Q&A
Get specific Data from a PU Query not only PU_FIRST or PU_LAST

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

201
janpeter.van.d
Level 8
patrick.groth12
Level 3
patrick.groth12Level 3
asked in Process Intelligence Graph (PI Graph)
OCPM - Adding additional columns without specifying them as custom properties

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

102
P
Level 3
sarina.somme
Level 3
sarina.sommeLevel 3
asked in General Product Q&A
How to consolidate items from table for action flow

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

221
R
Level 2
N
Level 1
nura.linggLevel 1
posted in General Product Q&A
Sustainable Procurement with the Sustainable Spend Management App 💰

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 🌍

51
M
Level 1
T
Level 1
teodor.dinevLevel 1
asked in General Product Q&A
Dear colleagues, I am currently in training and while trying out using Action Flows connections to Google sheets/Docs I get a 401 error, "this app has been blocked". How can I allow the connection to Google sheets?(the C Documentation method did

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.

81
B
Level 1
A
Level 1
amit.bhair11Level 1
asked in General Product Q&A
Iam unable to checkout with payment informations with data engineer certification exam can anyone help me resolve this issue ASAP

11
.
Level 2
L
Level 1
linda.rossLevel 1
asked in Data Ingestion & Infrastructure
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?

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?

31
dennis.pflug
Level 6
V
Level 4
vasco.caron11Level 4
asked in Process Analysis
Action Flow + Skill: E-mailing with a .CSV Attachment (Wrong Format?)

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

146
bunyod.sap
Level 4
anusuya.ponnu
Level 3
anusuya.ponnuLevel 3
asked in General Product Q&A
How to link Sales Order no. to Invoices (AR) side with two different data models in data integration.

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

21
S
Level 1
S
Level 1
srinivasareddy.indur11Level 1
asked in 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 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.

41
muthappan.alaga
Level 4
J
Level 4
jumbo.szkLevel 4
asked in General Product Q&A
How to create test user without mail address.

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,

01
muthappan.alaga
Level 4
lukas.mech
Level 2
lukas.mechLevel 2
posted in Process Analysis
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!

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!

32
lukas.mech
Level 2
vamshi.vigne
Level 3
vamshi.vigneLevel 3
asked in Data Ingestion & Infrastructure
Generating a random number series table

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?

121
G
Level 3
D
Level 4
douglas.henriLevel 4
asked in General Product Q&A
Table Contract SAP

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?

32
D
Level 4
andrej.barto
Level 3
andrej.bartoLevel 3
asked in General Product Q&A
Hello, is it possible to find out who was the last person opening the report and get a history of report openings on OnPremise version of Celonis? I can only find out which user last published the report once I open it, but I would like to know

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

31
H
Level 1
G
Level 1
greeshma.srLevel 1
asked in General Product Q&A
how to get badge after completion

how to get badge after completion

71
K
Level 1
A
Level 3
anand.sreekLevel 3
asked in General Product Q&A
I have a time stamp in the below format in a spreadsheetYYYYMMDDHHMMSSMS.When i try to upload this sheet the MS part is cutting out. How do I upload timestamp with microseconds?

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?

36
A
Level 3

Badge Winners

  • Value Realization Expert
    nataly.hansehas earned the badge Value Realization Expert
  • Qualified to Manage Implementation Projects
    nataly.hansehas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Manage Change and Scale Adoption
    Ha Xuyen Duonghas earned the badge Qualified to Manage Change and Scale Adoption
  • Qualified to Deliver Business Value with Celonis
    Ha Xuyen Duonghas earned the badge Qualified to Deliver Business Value with Celonis
  • Qualified to Create and Deliver Demos
    Ha Xuyen Duonghas earned the badge Qualified to Create and Deliver Demos
VIEW ALL
Community Code of Conduct