Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 2,564 Topics
  • 5,886 Replies
2563 Topics
A
Anonymous
asked in General Product Q&A
What is the difference between Skills and Action Flow

Hi All, as a beginner in Celonis, I am often confused with the use of Skills and Action Flow, is there any significant difference in functionality, use case or scenario? Thanks in advance!

210
R
Level 4
S
Level 3
stefan.hofma12Level 3
asked in General Product Q&A
Using Pull-Up-function combined with ORDER BY with more then one dimension/columns

Hello, I had the PQL Code for Pull-Up-function in progress for many months now. This Function contains two dimensions/columns in the order by statement: PU_LAST(DOMAIN_TABLE("TAB1"."ID"), "TAB1"."STATUS", order by "TAB1"."SORTING","TAB1"."TIMESTAMP") ='Anlage'THEN 'create' A few weeks ago after adding more records to the dataset I got the following error message: Sorry! Something went wrongWe couldn't find any data for this chartPull-Up-function could not be executed PU_LAST:Only one ORDER BY column allowed, but [2] columns were specified After I removed the second Order by statement ("TAB1"."TIMESTAMP") the code works. However, ordering across both columns is still required.Was there an adjustment (function) or could it have something to do with the new data import? br Stefan 

160
S
Level 3
J
Level 4
javier.donosLevel 4
asked in General Product Q&A
Hey Celonis world. I am trying to follow the Assistant Guided tour, but sometime it jumps and restart. is there some docs where we can do the exercises without following the assistant?Thks in advance

Hey Celonis world. I am trying to follow the Assistant Guided tour, but sometime it jumps and restart. is there some docs where we can do the exercises without following the assistant? Thks in advance

10
J
Level 4
M
Level 3
mateusz.dudek11Level 3
asked in General Product Q&A
Hello, I've tried to create new data model for one of our clients in On-Premise Celonis version 4.6.1. Sadly i've got error when loading data, could you advice how to oaccess logs? Manual (CPM4/Exceptions) is unavailable.

40
M
Level 3
S
Level 2
shrishti.kanch11Level 2
asked in General Product Q&A
Would the new signals appear if the particular signal is resolved manually?

Hi, Would like to know if an action is resolved manually and post that if the new signals come depending upon the logics set? Eg: My Signal ID is A and it is was resolved on the 29th Sep post which there is a new trigger for the same signal ID A so would that come in the Signal Overview list? As I'm unable to see the new triggers for the same signal once resolved manually

10
gabriel.okaba11
Celonaut
.
Level 2
.14600871Level 2
posted in General Product Q&A
Hi,

Hi,Does Celonis 4.5/4.6 have a dedicated data extractor for GEP MyBuy data? - Thanks.

01
gabriel.okaba11
Celonaut
S
Level 3
schauer.schauLevel 3
asked in General Product Q&A
Database has stored a different data type than Celonis

Hello everybody, I have a problem with our data types in Celonis. In our Oracle database, we have columns such as the sorting implemented with an integer value. However, Celonis shows us a float value for all of these columns, which is why the following error message appears for some functions:  Does anyone know what the reason for this might be and how the data type in Celonis can be changed? Thanks a lotLaura

00
S
Level 3
P
Level 2
p.p12Level 2
asked in General Product Q&A
My source DB and table name got changed.So where can I replace that ,as again i dont have to replace all names used in analysis.So is their any way i can change all my tables names not manually one by one in analysis.

So is their any way i can change all my tables names not manually one by one in analysis in visualization.

30
gabriel.okaba11
Celonaut
G
Level 1
guilherme.gaino11Level 1
asked in General Product Q&A
ECC 5.0: Where is /CELONIS/CLMAN Table?

Hi, We are performing some tests with Celonis and our on-premise SAP system (both Sandbox). Since we couldn't install the most recent ECC 6.0 RFC package, due to our enhancement package level (lower than Celonis requests), we decided to install the ECC 5.0 version instead. However, we are not able to activate and execute all RFCs, because some objects are missing in the installation package. For example: table /CELONIS/CLMAN. Are there any complete packages with all objects for ECC 5.0? Or can we just force the import of ECC 6.0 requests into our system? Error:Request:Thank you

30
R
Celonaut
C
Level 1
celonis.pLevel 1
asked in General Product Q&A
Impact on Real time connector post migration to S4HANA where these ECC table become views

Dears, I want to know the impact of S4HANA implementation on the real time connector which is based on the logic of table logging mechanism.  Once we migrate o S4HANA the ECC tables will become views and then how will this table logging mechanism work as I understood there is no change on tables in S4HANA for P2P process for example ?  Thanks for your insights.  Regards,Priyanka

20
R
Celonaut
.
Level 2
.14600778Level 2
asked in General Product Q&A
We are currently in the process of implementing a HR process that extends the standard process Hire to Retire. What are the best practices to integrate the change data that is stored in the cluster table PCL4 without exporting the changed values?

Hello everyone,  we are currently in the process of implementing a HR process that extends the standard process Hire to Retire. Here we face the challenge that we do not have the changes data in the tables CDPOS and CDHDR, but saved in a cluster table PCL4. What would be the best practice working with a cluster table.  Additional requirement is, that we would like to only export the timestamp and the change table/field to Celonis. The changed values should not be included in the export. This was done for the other tables, by creating views, that only contain the relevant columns. But with the cluster table we face the challenge that all data is stored in one column. We would be happy about any experience or best practice with this kind of issue.  Best regards,Philipp

60
.
Level 2
A
Anonymous
asked in General Product Q&A
What does FILTER DOMAIN do ?

My predecessor uses FILTER DOMAIN under load script to filter the whole analysis. I couldn't find any documentation for this function. Does anyone know were I can more information ton this topic? Thank you

170
gabriel.okaba11
Celonaut
C
Level 1
celonis.pLevel 1
asked in General Product Q&A
Dear ,We have P2P implemented in Celonis, and we are migrating to S4 HANA, and I would like to understand the impact on data model , what happens to the existing tables, EBAN, BSEG, MSEG, EKKO...etc . will the extraction be then done from ACDOCA ?

Also, Is it possible to understand the impact on real time extractor , as it works on log tables, after the migration to S4HANA the current tables will become views, is it wise to implement real time extractor before the migration or after migration.

20
B
Level 1
A
Anonymous
asked in General Product Q&A
I installed the AR connector from EMS store and connect it to our own SAP ECC environment. It will how not create the model views.

The SQL returns error that the relation not exist. See attachment. The long number refers to the connection parameter.

00
B
Level 1
P
Level 2
p.p12Level 2
asked in General Product Q&A
How to handle null values in celonis.

Null values are coming as - in visualization and olap tables.so how to hide them.I have used isnull and coalsce () ,but it seems not working.So any way to hide or change - for null values.

380
R
Level 4
.
Level 1
.146003796Level 1
asked in General Product Q&A
Filter by dates to display only part of the events, not the full chain

I need a filter that will show only a part of the events that happened in the selected time interval. When I set a period limit, a complete chain of events is displayed for all cases that took place during this period. for example, in the chain (id -date ) 1 - 01.2021, 2 - 04.2021, 3 - 06.2021, if I set the filter to 04.2021, the entire chain will be displayed 1 - 2 - 3, and it is necessary that only 2 be shown

50
R
Level 4
H
Level 1
haripriya.palak12Level 1
asked in General Product Q&A
Unable to login to ibc training portal

Unable to login to ibc training portal

00
R
Level 4
mohit.mehro12
Level 2
mohit.mehro12Level 2
asked in General Product Q&A
Process Explorer seems to be taking forever...pink dots.

Just installed CPM 4.7.1 ( new install) not upgrade from 4.6.x in our Dev/QA box. We imported a transport of one of the analysis from PROD and brought it into the QA. Everything is working fine- OLAPs, Charts etc..., except Process Explorer and Variant Explorer seems to be taking forever...pink dots.  Do we need to configure some settings.  Mohit

00
mohit.mehro12
Level 2
T
Level 1
theresa.wettiLevel 1
asked in General Product Q&A
Execution output message as part of error handling / Add one module after flow control module "ignore"

Dear celopeers, what is the best practice for showing an execution output message in case an error handler was active? More specifically, we first use salesforce and added a flow control module "ignore" to handle errors that occur within salesforce. However, we would like to show a user notification in this case. The problem seems to be that we cannot add another module after the ignore module (for including, for example, a webhook to a skill which could then produce the execution output).Appreciate any insights.Thank you very much

10
T
Level 1
A
Anonymous
asked in General Product Q&A
CASE WHEN statement adding '-' dimension

I'm using a CASE WHEN statement to filter out dimensions based on dynamic criteria. For example, take the following case when statement: CASE WHEN"Activities"."ACTIVITY_EN" in ('Closed','Open')THEN'Closed'END I would expect that there will only be rows for 'Closed' and 'Open', however, I am also seeing a row with the dimension of '-' . There is no way to filter this out and leads to misleading dimensions.

00
R
Level 4
C
Level 3
chanti.pLevel 3
asked in General Product Q&A
Filter in Case explorer

I have crated a basic analysis for my team with only 1 sheet as case explorer. In the case explorer i want to hide few columns and publish the analysis. I don't want to show few columns to the team. Is there any functionality to hide columns in case explorer and publish? Regards,Ashok

20
C
Level 3
A
Anonymous
asked in General Product Q&A
Change DATETIME Column within the Event-Collection

Hello all, in the event-collection I create a new table, wherein I join two tables based on the following rule:JOINWHERE "Alarm"."Starttime" > "Transport"."Starttime" AND "Alarm"."Starttime" < "Transport"."Endtime" This works. Now I would like to extend this timeframe by 5 Minutes. And neither the function:add_minutes("Transport"."Endtime", 5) is supported nor the function REMAP_TIMESTAMPS("Alarm"."Starttime") < (REMAP_TIMESTAMPS("Transport"."Endtime") + 5) How can I change/remap a timestamp in the event collection?

00
A
A
Level 3
aram.wLevel 3
asked in General Product Q&A
How to show sums above value X and 0 otherwise

Hi, I want to add a column to an OLAP table that shows whether all orders from a given supplier exceed the value of 100 or not. So the final table should show a supplier name, the number of orders, the net worth of orders and either: The net worth value sum if its above 100, else 0An 'x' when the sum of orders exceeds 100 Also, it would be great to see how many single orders exceeded the value of 100. I was trying around for a while with PULL functions and CASE WHEN but I can't seem to make it work with the restriction of '> 100'. For example the query below gives me an error message stating that CASE is not compatible with FLOAT and INT. SUM(CASE WHEN "EKPO"."NETWR_CONVERTED" > 100THEN "EKPO"."NETWR_CONVERTED"ELSE 0END) Thank you very much in advance. Best regardsAram

00
A
Level 3
J
Level 3
joren.kamer12Level 3
asked in General Product Q&A
Formula does not seem to work properly

Hi, When i show the same formula (standard throughput time calculation) in an OLAP table vs a number they fail to show the same outcome. Whereas they should. In the olap table I have applied the formula in combination with a priority dimension. WIth the number I have applied a specific priority as filter. Hence, both the throughput time should be equal. However, they are not.  Any idea what could go wrong?

30
J
Level 3
S
Level 2
sunita.pahwa12Level 2
asked in General Product Q&A
How can I change the format of x-axis for a chart dynamically?

I need to change it from %b-%Y to Q%q on the basis of time scale selected by user

00
R
Level 4

Badge Winners

VIEW ALL
Community Code of Conduct