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,581 Topics
  • 5,920 Replies
2581 Topics
.
Level 3
.146105038Level 3
posted in General Product Q&A
hi i am beginner in celonis .

hi i am beginner in celonis .i watch (beginner )all videos .i can understand how to make app but i still confused if i make a new app then how can i start... i need someOne help me to make any project process Mining

22
.
Level 3
.
Level 3
.14601241Level 3
asked in General Product Q&A
Hi Guys, i have the following PQL Code "TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM" );"I want to sort it by the count values, so that the most frequent value is the first one and the least frequent value is the last one. How can i do tha

Hi Guys, i have the following PQL Code "TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM" );" I want to sort it by the count values, so that the most frequent value is the first one and the least frequent value is the last one. How can i do that?

42
.
Level 3
.
Level 4
.14600103626Level 4
asked in General Product Q&A
How to Create EBS connection in Action Flows

I am trying to fetch real time information from Oracle EBS and want to use Action flows to send an email if there is any entries being wrongly created. While using EBS Node to connect the DB , it looks for a connection.I created the connection , but the same do not appear in the list. Anyone - Have you ever connected Oracle EBS from Action Flow Node? please Help

31
S
Level 1
kiarash.diba
Level 2
kiarash.dibaLevel 2
asked in General Product Q&A
Hello all,I want to crop an event log until a specific activity. I can use the crop filter, but I want to adjust the variant explorer and throughput calculations, etc. to be adjusted to this new process scope. Is there a way to this in Celonis?

In other tools, I would crop the process, export the new event log for the cropped process and import the new event log back as a new process. Is there a smarter way of doing that in Celonis? If not, is there a way to export the adjusted event log from Celonis?   

34
kiarash.diba
Level 2
.
Level 3
.1460119Level 3
asked in General Product Q&A
Difference in performance of different Data Models in the same Data Pool

Hi @all, We have a Data Pool with 2 Data Models: Data Model “ECI Data Model HTD - TABLES - TEST” has been duplicated from the Data Model “ECI Data Model HTD - TABLES”. If we do a “Manual - Complete Reload” of both Data Pools, the load times are very differents: “ECI Data Model HTD – TABLES” --> 34 min “ECI Data Model HTD – TABLES – TEST” --> 21 min  Apparently, the load time of each of the tables is very similar:   If we do a "Manual - Partial Reload" on both Data Pools of a table that only contains 87 records, the load times are also very differents: “ECI Data Model HTD – TABLES” --> 19 min “ECI Data Model HTD – TABLES – TEST” --> 3 min What could be due to these differences? As we said before, the Data Model that has the best times has been duplicated from the previous one. Thanks in advance!

37
.
Level 4
A
Level 1
amit.lingeLevel 1
asked in General Product Q&A
Want to know for our esteemed client if we have a use case from Account Receivable - 'Account On Cash' specific area, to prove Celonis capabilities and potential savings that can be achieved.

‘On Account Cash’ process is related to Account Receivable only with following business scenario – ‘On Account Cash’ sub-process comes into picture when there is one or multiple invoices issued to customer and customer made partial payment which is NOT equal to cumulative outstanding amount.In this case, say there are three invoices with amounts $20,000; $30,000 & $40,000 that need to be cleared with a partial payment received of $70,000 from customer. This amount received remains as ‘On Account Cash’ on the books until it is manually coordinated with customer and applied in system using SAP TCODE FEBAN.The related SAP tables in SAP I came to know are -BSID – contains information on total outstanding amount for customerBSIS – contains information on balance un-applied (‘On Account Cash’ available to be applied manually) per customer If there was any savings achieved in this area for any of the Celonis clients, it would be great to present as a success stories as required in this a

01
.
Level 3
S
Level 3
sridhar.turag14Level 3
asked in General Product Q&A
We are trying to connect Celonis with Microsoft Dynamics 365 on the client side. Is there anyone who can help with this? The online documentation is not very useful as it talks about Action Flows only which comes at a much later stage.

We are trying to connect Celonis with Microsoft Dynamics 365 on the client side. Is there anyone who can help with this? The online documentation is not very useful as it talks about Action Flows only which comes at a much later stage.

74
S
Level 3
.
Level 1
.14601929Level 1
asked in General Product Q&A
how to extract data from file which is uploaded from file upload folder and create a data connection in data pool in celonis studio.

how to extract data from file which is uploaded from file upload folder and create a data connection in data pool in celonis studio.

111
.
Level 4
J
Level 1
javier.sánchLevel 1
asked in General Product Q&A
When a sales person is alerted by an action flow, can I know what activities the salesperson is doing as a result of the alert? i.e., Can I have a record in Celonis of the activities following the alert?

When a sales person is alerted by an action flow, can I know what activities the salesperson is doing as a result of the alert? i.e., Can I have a record in Celonis of the activities following the alert?

21
D
Level 1
P
Level 4
preethi.p12Level 4
asked in General Product Q&A
How to calculate FTE

I wanted to calculate all documents processed by any user per day. Can anyone help with formula or explanation how it can be done​

42
P
Level 4
S
Level 3
siddhesh.naik11Level 3
asked in General Product Q&A
Which training track needs to be completed for BVA certification?

Which training track needs to be completed for BVA certification?

02
S
Level 3
C
Level 1
cameron.goodwLevel 1
asked in General Product Q&A
Is it possible to change the verbiage in a Analysis, such that instead of cases, we can refer to this concept as some other term?

Our use case requires analysis on inventory stock levels, and the unit of measurement for inventory is cases so we would like to reduce the amount of confusion that could arise from this.

01
.
Level 4
.
Level 2
.146004325Level 2
asked in General Product Q&A
SAP Tables for P2P-ProcessHello,is there any list where the required SAP Tables for the whole P2P Process are listed?If only the tables of the sample files are included, a lot of information is missing.Best regards!

SAP Tables for P2P-Process Hello, is there any list where the required SAP Tables for the whole P2P Process are listed? If only the tables of the sample files are included, a lot of information is missing. Best regards!

61
.
Level 4
.
Level 3
.146003860Level 3
asked in General Product Q&A
How to add multiple conditions to a component filter?

Hi, Currently I am using the following: filter "tableName.csv"."TASK_TITLE" LIKE 'Condition1' which is filtering on a specific name.  How do I change the syntax so that it takes into account an additional condition? i.e. I want it to filter words that have a full stop in them. (condition 2 = '.') thanks,Terence

331
.
Level 4
.
Level 3
.146105038Level 3
asked in General Product Q&A
Cannot install Process Connector

The selected Process Connector is not available for your database type. Please contact Celonis support. 

910
.
Level 3
ankur.sahan
Level 1
ankur.sahanLevel 1
asked in General Product Q&A
Dashboard

Scenario - We have 2 sheets - Dashboard and DetailedIn detailed sheet we have an OLAP table (for example) wherein we have company codes as dimension and count of documents as KPI.Question - Now, we want to automate dashboard with a TEXT COMPONENT which only shows me top 3 company code names basis count of volume (in descending order) in the OLAP table in detailed sheet.For Example - If we have 10 rows in OLAP table having 2 columns showing me Co. Code 1, Co. Code 2....Co. Code 10 and there is a value against each co. code.In Dashboard under TEXT component (TOP 3 least performers) - it shows me only those 3 co. codes based on OLAP table...it can be Co. Code 5, Co. Code 7 and Co. Code 10. Any guidance here will be really helpful.  thanks in advance.

41
E
Level 4
S
Level 2
shruti.gupta16Level 2
asked in General Product Q&A
Hi All,Is there any way to put data pool parameters for just rolling 12 months so that it can extract data for last 12 months only every time ?Can we define such parameter for extraction and what will be the syntax?

Hi All, Is there any way to put data pool parameters for just rolling 12 months so that it can extract data for last 12 months only every time ? Can we define such parameter for extraction and what will be the syntax?

105
gabriel.okaba11
Celonaut
janpeter.van.d
Level 8
janpeter.van.dLevel 8
asked in General Product Q&A
Incorporate Filters/Selection to PQL Window functions (INDEX_ORDER/LEAD/LAG)

Hi, I'm working on a first time fix calculation. The function flags a case, if there is a new case for the same serial number within 7 days. What I found out, is that the PQL window functions (such as Index_Order / Lead / Lag) are not taken into account any filters (even not on analyis level in the 'Load Script' area) or Selections. This is quite disturbing, since we use some filters to simplify the data set.  A workaround that I applied, is to include the filters also in the First Time Fix formula, but this is not preferably, since we have to state them twice, which could lead to mismatching when applying changes in the future (Load script section doesn't accept variables).  Is there a way to let window functions incorporate already present filters in the analysis?  Next to that, the behavior is quite unclear since the index is based on data that is not shown in the analysis when a 'Load Script' analyis filter is applied. Even if that is the intended behavior,

174
janpeter.van.d
Level 8
.
Level 3
.14601241Level 3
asked in General Product Q&A
I have the following PQL Code and it is working. TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM");How am i able to get the Max value from it? So overall the expression should give me the name of the most frequent value in this table column

I have the following PQL Code and it is working. TABLE (COUNT( "AP_BSEG"."ZTERM" ),"AP_BSEG"."ZTERM"); How am i able to get the Max value from it? So overall the expression should give me the name of the most frequent value in this table column

63
E
Level 4
.
Level 1
.14600122597Level 1
asked in General Product Q&A
Hi @ALL,I would like to take the SUM() of a result which used the GLOBAL() function.Do you have a soultion?

 I would like to sum this resulting column up and get an INT for example.  CASE WHEN(  CALC_THROUGHPUT(FIRST_OCCURRENCE['Sendung elektronisch angekündigt']   TO LAST_OCCURRENCE['In der Region des Empfängers angekommen'],   REMAP_TIMESTAMPS("Amzn_activity_table_xlsx_Tabelle1"."TIMESTAMP", MINUTES))  >   GLOBAL(    AVG(    CALC_THROUGHPUT(FIRST_OCCURRENCE['Sendung elektronisch angekündigt']     TO LAST_OCCURRENCE['In der Region des Empfängers angekommen'],    REMAP_TIMESTAMPS("Amzn_activity_table_xlsx_Tabelle1"."TIMESTAMP", MINUTES))    )    *1.2)) THEN 1 ELSE 0 END 

71
E
Level 4
M
Level 2
mike.prent12Level 2
posted in General Product Q&A
It appears I cannot create a data job that extracts from a DB View.

It appears I cannot create a data job that extracts from a DB View. Is that correct? Is there a way to make that happen? It is easier to create the data within the SQL Tables vs bringing it into Celonis and then doing all the conversion. Mostly because I need to convert Key fields to get them to allow relationships. Is there a way around this or do we really have to ETL the data in Celonis? Worse case we create the views and dump the tables into XLS and import. I was hoping for something easier. Thank you.

44
M
Level 2
.
Level 1
.14600123172Level 1
asked in General Product Q&A
Hello together,is it possible to set a datepicker for one specific component? I would like to compare two OLAP tables (first 6 months vs. last 6 months) in one sheet with individual datepicker each.

Hello together, is it possible to set a datepicker for one specific component? I would like to compare two OLAP tables (first 6 months vs. last 6 months) in one sheet with individual datepicker each.

81
G
Level 8
C
Level 2
casper.van.bLevel 2
asked in General Product Q&A
How can I move process models to different folders in the process repository?

I'm looking for a drag & drop or move function. I could download and upload the .bpmn files, but they I'd lose the versions.

32
C
Level 2
G
Level 8
guillermo.gost12Level 8
asked in General Product Q&A
How can I localise my activity names? So I can have activity names in several languages, and the user can pick the language.

I was thinking on using something like Name Mappings, but you can't. ​The idea was to have something in your _CEL_ACTIVITIES likeACTIVITY = '1.1'ACTIVITY_EN = "Receive Order"ACTIVITY_ES = "Recepción de Pedido" and then use only ACTIVITY for all the PQL codes I could need But the user will see the activities names in their selected language

61
A
Level 1
leonor.doris.rodri
Level 3
leonor.doris.rodriLevel 3
asked in General Product Q&A
How to use data from a table in a Package in another Package via ML?

Hi,How can I pull data from an Olap table in Package A in my Space, and push it to Package B in the same Space, using Machine Learning? I have a script that pulls data from Package A, but I am missing the second part, to push this data into the Package B

57
G
Level 8

Badge Winners

  • First Post
    lisaschneiderhas earned the badge First Post
  • Value Realization Expert
    Pablo MChas earned the badge Value Realization Expert
  • Qualified to Deliver Business Value with Celonis
    Pablo MChas earned the badge Qualified to Deliver Business Value with Celonis
  • First Post
    maxim.vnouthas earned the badge First Post
  • Celonis Certified Data Analyst
    akmal.farhahas earned the badge Celonis Certified Data Analyst
VIEW ALL
Community Code of Conduct