Skip to main content

General Q&A

Can't find what you're looking for? Ask it here!

  • 1,203 Topics
  • 2,569 Replies
1203 Topics
andré.tafur
Level 4
andré.tafurLevel 4
asked in General Q&A
Action Flow Life Cycle Methodology

Hi celopeers!I would like to know if any of you when implementing a solution using an Action Flow have used any framework to ensure its lifecycle. I mean what steps have you followed to build, test, release to production, monitor and manage the changes of an Action Flow? Thanks!

20
andré.tafur
Level 4
.
Level 2
.1463214Level 2
asked in General Q&A
Hi all, Can anyone tell me why is this happening because I am not able to get the list of columns even table is there in data pool ..?



40
janpeter.van.d
Level 8
G
Level 1
gevik.nalbaLevel 1
asked in General Q&A
What is the process to becoming a technology partner?

As a software/saas provider, how do we become a tech partner to Celonis?

50
M
Level 1
M
Level 3
matt.slocu12Level 3
asked in General Q&A
How to dynamically calculate quartiles using data from pull-up aggregation

Given a set of process data that determines a time in process using pull up aggregation, I would like to generate the different time in process averages for an attribute for 1st quartile, 2nd quartile, 3rd quartile, and 4th quartile attributes. Remember the average time in process is calculated via pull-up aggregation, which I believe means I can't run pull up aggregation on it again. I tried to research Domain Tables, but I wasn't sure how to apply them here. see image for example:        

70
N
Celonaut
Z
Level 4
zeliha.otgözLevel 4
asked in General Q&A
It is indicated in the Celonis Academy that "As an improvement action, you might choose to implement Celonis Machine Learning and Action Flows".Do you know any other option for improvement actions when improving the business value?

It is indicated in the Celonis Academy that "As an improvement action, you might choose to implement Celonis Machine Learning and Action Flows". Do you know any other option for improvement actions when improving the business value?

00
F
Celonaut
C
Level 1
chaitanya.telukLevel 1
asked in General Q&A
What is the ratio for the process deviation “Maverick Buying” for the material “Leather bag professional”?

What is the ratio for the process deviation “Maverick Buying” for the material “Leather bag professional”?

220
M
Level 1
F
Level 2
fatima.belabLevel 2
asked in General Q&A
in E2E there are some data missing like i found the data in OMS but i didn't find them in E2E ?

in E2E there are some data missing like i found the data in OMS but i didn't find them in E2E ?

00
S
Level 1
Sverre Klein
Level 6
Sverre KleinLevel 6
asked in General Q&A
Hubspot Sales Pipeline

Hello! I wanted know if anyone was able to successfully have a Hubspot use case, I am currently in the middle of creating the tables for Celonis, but I wonder if anyone else did it before me. 😎

20
Sverre Klein
Level 6
G
Level 2
gabriella.koopmLevel 2
asked in General Q&A
Add a graph with the maximum count of cases with a specific activity on a day per hour.

On the X axis, I have Hours (event. timestamp)On the Y axis, I want to have a graph with the maximum amount of cases that have happened. but on a day. ( So for example 1-01-2022 at 9 hours the count was 10 and on 2-01-2022 at 9 hours the count was 30, I want the output for 9 hours to be 30)  At the moment I use this to calculate the averageCOUNT ( DISTINCT CASE WHEN "eventlog_T1"."ACTIVITY" = 'activity'' THEN "eventlog_T1_CASES"."cases" END )/( COUNT ( DISTINCT Round_Day ( "eventlog_T1"."TIMESTAMP" ) ) ) Does any one has a suggestion how to get the maximum value on a day per hour

20
R
Level 1
B
Level 1
bhavyasri.kodalLevel 1
asked in General Q&A
how to delete my account in this

how to delete my account in this

390
B
Level 1
N
Level 1
nathalie.magalLevel 1
asked in General Q&A
How to link the BSEG table with either /OPT/VIM_1HEAD or /OPT/VIM_1ITEM to retrieve the DOCID field?

We have an OLAP table and most of the columns are from the BSEG, BKPF, and LFA1 tables. However, we would like to also have the DOC ID field from either /OPT/VIM_1HEAD or /OPT/VIM_1ITEM tables. How do we connect these tables?  Thank you!

190
bunyod.sap
Level 4
S
Level 2
stuart.johnsLevel 2
asked in General Q&A
Fairly simple - we are using C4C EMS and would like to know the costs/commercial model once you have used up your free entitlement - cannot seem to find that information easily anywhere

Fairly simple - we are using C4C EMS and would like to know the costs/commercial model once you have used up your free entitlement - cannot seem to find that information easily anywhere

10
S
Level 2
jonas.frisc
Level 3
jonas.friscLevel 3
asked in General Q&A
I would like to remove leading zeros in the Replication Cockpit before they are loaded into the pool.

Hello everyone, I would like to remove the leading zeros from some attributes. This is not a problem with the normal extractions and can be done with an update command. The question arises as to how I can implement this in the Replication Cockpit. The data is stored in a view, which I cannot update. Does anyone already have a solution for this or a suggestion as to how I can implement this?

140
T
Level 1
B
Level 1
bowei.huoLevel 1
asked in General Q&A
I suddenly lost access

00
Sverre Klein
Level 6
M
Level 1
muhammad.kashi14Level 1
posted in General Q&A
Community FAQ: How do I join/subscribe to a Community Topic?

Community FAQ: How do I join/subscribe to a Community Topic? Answer:To join/subscribe to a community topic, please follow these steps: 1. Visit our community topics from the main navigation bar.2. Click on the topic you are interested in.3. Locate the "Follow" button on the right side and click on it. Once you follow a topic, you will see two options for email notifications as shown in the screenshot below.Same applies for other topics that are not listed here. Also, feel free to follow as many topics as you want!

20
M
Level 1
apurva.patha12
Level 3
apurva.patha12Level 3
asked in General Q&A
Can anyone tell me how can I change the background color of view from grey to white?

Can anyone tell me how can I change the background color of view from grey to white?

90
apurva.patha12
Level 3
M
Level 3
marcos.hirak12Level 3
asked in General Q&A
what are the initial practical steps to take to "Create sap connection in celonis ems"?

I'm in my first EMS project and it was to accompany the DATA ENGINEER activities.Unfortunately the Data Engineer was not hired and they asked me to take over and I don't know SAP BASIS. I've done the Get Data into the EMS training, but I don't know what the initial practical steps are to do to "Create sap connection in celonis ems".Does anyone have anything written from "Practical roadmap to "Create sap connection in celonis ems" to send and/or guide me?

100
X
Level 3
U
Level 3
uma.penmeLevel 3
asked in General Q&A
I created action flow and now i am trying to add email module to celonis query Data module. I am unable to add email to email module as it is showing it is restricted by our company laptop, Is there any possibility or alternative to send mails.

I created action flow and now i am trying to add email module to celonis query Data module. I am unable to add email to email module as it is showing it is restricted by our company laptop, Is there any possibility or alternative to send mails.

80
bunyod.sap
Level 4
M
Level 1
muhammad.kashi14Level 1
posted in General Q&A
Community FAQ: How do I update my contact information?

Community FAQ: How do I update my contact information? Answer:To update your contact information in Celopeers, please go through the following steps: 1. Click on your profile picture on the top right corner.2. From the dropdown, go to your Profile Page.3. Once there, click on the "Edit" button on the top. A prompt will appear that will allow you to change your name, title, and background information. Please leave a like if you found this helpful!

10
M
Level 1
J
Level 3
johannes.holst11Level 3
asked in General Q&A
I've an issue renaming a column.When executing the codeALTER TABLE tablename RENAME COLUMN oldname TO newname;I get the error: Execution error: Incorrect syntax near 'RENAME'what is my mistake? The error appears whether i use quotes or not

I've an issue renaming a column. When executing the code ALTER TABLE tablename RENAME COLUMN oldname TO newname; I get the error: Execution error: Incorrect syntax near 'RENAME' what is my mistake? The error appears whether i use quotes or not

40
P
Level 2
U
Level 1
umatanuja.patna13Level 1
asked in General Q&A
Action Flows - Configure an advanced Action FlowChoose your journey1Configure alternative routes2Apply filters and conditions

Action Flows - Configure an advanced Action Flow Choose your journey 1 Configure alternative routes 2 Apply filters and conditions

20
U
Level 2
M
Level 1
muhammad.kashi14Level 1
posted in General Q&A
Community FAQ: How do I update my password?

Community FAQ: How do I update my password? Answer:To update your password, go through the following steps: 1. Click on your profile picture on the top right corner2. Go to My Settings from the dropdown.3. Click on the option "Change Password". A prompt will appear to provide the current password and to enter a new one twice. Please leave a like if this information was helpful!

00
M
Level 1
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Q&A
Adding a timestamp to data rows in a CSV file that is sent out via an Action Flow

Hello everyone!I want to send an Action Flow weekly that displays the material numbers that qualify for an automatic ordering process (this process can be triggered by editing the material master data). Since employees might choose not to edit the master data due to various reasons, the one material number for example will show up every week in the CSV that is sent via the AF. It could be possible that this repetitive sending of material numbers that should not be automatically ordered might negatively affect the acceptance of the AF. Here's my idea: does somebody have an idea how to add a timestamp of the initial sendout of the data rows in the CSV file? So, for example, if one material number was already sent out via the AF on the 1st of January, in the next runs of the Action Flow the 1st of January will be visible in an extra column, so employees could filter it easily to the current date.  Thank you so much! BRJulia Bauer

70
julia.bauer
Level 5
richa.patel
Level 2
richa.patelLevel 2
asked in General Q&A
While loading the data model, I am getting the below error message. Could you help me with increasing the limit or any other alternative?

The load failed: Load failed. Error Message: Table "XYZ" has 7,145,120,256 rows. The current limit is 5,000,000,000 rows. 

110
mukesh.gupta11
Level 4
A
Level 4
akshay.haridLevel 4
posted in General Q&A
Hi All,

Hi All,We are trying to implement the machine learning model Linear Regression in our ML workbench, Can anyone suggest us in what all parts of celonis will it be useful or a business use case were we can implement it successfully.

81
mukesh.gupta11
Level 4

Badge winners

  • Celonis Technical Expert
    aishwarya.choug12has earned the badge Celonis Technical Expert
  • Qualified to Get Data Into Celonis
    aishwarya.choug12has earned the badge Qualified to Get Data Into Celonis
  • Qualified to Manage Implementation Projects
    erick.matoshas earned the badge Qualified to Manage Implementation Projects
  • Qualified to Deliver Business Value with Celonis
    yuri.fujimhas earned the badge Qualified to Deliver Business Value with Celonis
  • Qualified to Manage Implementation Projects
    lasse.muellhas earned the badge Qualified to Manage Implementation Projects
VIEW ALL
Community Code of Conduct