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,583 Topics
  • 5,920 Replies
2583 Topics
D
Level 2
daniel.burroLevel 2
asked in General Product Q&A
Single KPI - I want to count WIP cases that their latest event matches a specific activity

essentially i want to bucket cases based on where their latest event is.  what would be the best PQL clause to use in this instance?

01
abhishek.chatu14
Level 7
D
Level 2
d.dinesLevel 2
asked in General Product Q&A
For saving APC consumption used data, how we can delete the loaded data for certain data pool which contains several processes in it. I want to delete one process data in the data pool.

Assume the data pool contains of AP, AR and O2C three processes. I want to delete AP process data, for that I have added an activity in transformation where I have droped all the tables related to AP process data and I have executed that activity and data load has been done. But no change in studio part and APC Consumption also, data got not reduced. Is there any way to delete the data ?

287
D
Level 2
V
Level 4
vasco.caron11Level 4
asked in General Product Q&A
Augmented Attributes - Do cases in Augmented Attributes Table disappear when we remove them from our Case Table?

Good afternoon, Essentially we want to remove all 2021 Data, but we would like to keep our "Resolved History" for Use Cases in Action Views, that rely on Augmented Attributes. Would removing 2021 invoices, for example, cause us to lose all "Resolved Invoices"? How can we preserve this data? Thank you in advance! Best Regards, Vasco Carona, Solvay

93
.
Level 5
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Restrict data extraction to the last few years

Hi, we have a requirement to restrict extraction of purchase orders to last 2 years. We are planning to go ahead with ERDAT from EKKO table. But what about other tables like T*, CDHDR and the rest. How can we restrict data extraction in those tables? Also, How can we make EKKO as a parent table to consider the extraction of the rest of the tables based on the data from parent table like EKBE-EBELN = EKKO-EBELN?

94
D
Level 3
S
Level 1
satyajit.saman11Level 1
asked in General Product Q&A
Celonis Task Mining and Automation

Is there a way to automate the tasks captured by Celonis Task mining? I have captured desktop data/user actions for a task using Celonis Task Mining and data are loaded into EMS. After that, does Celonis provide any feature to automate (API or UI etc) those actions/tasks and run on any machine? Or need to use any RPA tool only for this automation?

11
abhishek.chatu14
Level 7
Z
Level 4
zeliha.otgözLevel 4
asked in General Product Q&A
For example, My KPI Query = SUM(Order Number)My KPI Component Filter is = FILTER NOT (ORDER TYPE = 'A') ;But; somehow I want to combine my component filter into the KPI Query?How can I do that?

For example, My KPI Query = SUM(Order Number) My KPI Component Filter is = FILTER NOT (ORDER TYPE = 'A') ; But; somehow I want to combine my component filter into the KPI Query? How can I do that?

11
G
Level 8
D
Level 3
deepti.gandhLevel 3
asked in General Product Q&A
Connection issues with Standard SAP Connector

I could able to successfully establish connection between SAP ECC and Celonis EMS standalone and the test extraction works fine. Now when I try to install standard SAP O2C connector with this connection, I get the below error. I dont get this error if I test the connection defined outside the connector. Request your inputs. 

122
D
Level 3
pavan.bhara13
Level 3
pavan.bhara13Level 3
asked in General Product Q&A
Is there a way to pass a default value for Stackby property in yaml?

we are having a bar chart with a single KPI but stacked by multiple selections. we want to set a default stack when no stacking option is selected when the dashboard is accessed. Is there any way to do so?  Snippets attached for reference.

32
abhishek.chatu14
Level 7
A
Level 3
aldona.potocLevel 3
asked in General Product Q&A
Can I join tables which don't have connection?

I have tables A, B, C, D, E which are connected as on attached scheme. I want to create an OLAP table which shows A, C and E data. I already have one OLAP with A + C and second with C + E but when I try to have A + C + E I get an error message. It is possible to join these tables?

158
janpeter.van.d
Level 8
R
Level 3
raul.rodri12Level 3
asked in General Product Q&A
Hello, could someone tell me where can I find the Celonis Process Repository?

Hello, could someone tell me where can I find the Celonis Process Repository?

23
M
Level 3
A
Level 2
ayan.banyoLevel 2
asked in General Product Q&A
Hi ,Do we need to setup Extractor server to Connect to SAP HANA ?

In celonis documentation in one place it says to setup extractor server for SAP HANA , and in another place it says to access data using API . So , a bit confused on this . Any help is highly appreciated. RegardsAyan 

156
teuku.faruq13
Level 5
florian.mrkvi
Level 4
florian.mrkviLevel 4
posted in General Product Q&A
How to search for a tag in the new data pool GUI?

How to search for a tag in the new data pool GUI?Since the data pools are presented as a list instead of tiles the functionality to search for a data pool with a specific tag attached seems to be missing. Unfortunately the search bar doesn't take tags into account and even the browser search (Ctrl+F) is useless because Celonis splits up the pool list into several pages. We have a lot of data pools and tags in use and without a filter for a certain tag I have to got through every page manually. Is there still a way to filter data pools on base of their tags? br Florian

02
teuku.faruq13
Level 5
.
Level 1
.146001199Level 1
asked in General Product Q&A
Is there a standard in Celonis for stock transport orders with delivery in SAP?

Is there a standard in Celonis for stock transport orders with delivery in SAP?

11
M
Level 1
herique.sarme
Level 3
herique.sarmeLevel 3
asked in General Product Q&A
Is there an easy way to move everything I have from a server to another? I.E., I'm going from eu3 to us1 and I'd like to duplicate all my analysis and workspaces in Studio

Is there an easy way to move everything I have from a server to another? I.E., I'm going from eu3 to us1 and I'd like to duplicate all my analysis and workspaces in Studio

04
E
Level 2
M
Level 3
mustafa.arslaLevel 3
asked in General Product Q&A
Hello, After I query the data, I need to create a CSV file in a certain order in Action Flow. I only need 3 columns with the following order: Group Id, User Id, User Action. However, no matter what I do, it changes the column order.

and always start with User ID. How can I fix it? When I use advanced CSV, it doesnt allow me to name the column. it automatically name as Column1 name, Column2 name etc.Thanks

75
M
Level 3
M
Level 3
mustafa.arslaLevel 3
asked in General Product Q&A
Hello,My question is about keeping the records after running the automation process every week. So, the system would be selecting records and send email to stakeholders once in a week.

But, I will have to keep these records once the system is processed and published using OLAP table in the Studio. So, for example the columns might be Record Number and Record Created Date (System processed date). What is the best way to do so?

22
M
Level 3
W
Level 2
willem.van.d11Level 2
asked in General Product Q&A
Do overlaying components increase the page's data usage? 😕

Some of my pages contain (a few) hidden components behind big grey background text boxes. In one case, it had four variant explorers. I'm wondering.Does this reduce the page's speed?Can I check the consumption of a single analysis sheet? Thanks very much in advance for your time 😀

02
W
Level 2
C
Level 3
claire.chen12Level 3
asked in General Product Q&A
Data Extraction - Error executing function /CELONIS/EX_STATUS

I had this error occurred during data extraction and could not be executed. Does anyone know why?

163
G
Level 8
G
Level 8
guillermo.gost12Level 8
asked in General Product Q&A
A definition of "use case"?

Anybody has a "strong" definition of what will be a use-case in Celonis? I am thinking on a wording that could be use in proposal. Like when we limit the effort to "3 use cases", add that definition. TIA

18
M
Level 3
P
Level 4
preethi.p12Level 4
asked in General Product Q&A
How to add days to a date column in vertica sql?

I want to calculate start and end week of a particular date where week start date is Monday and end is SundayI’ve tried using ADD_DAYS & DATEADD which is in supported vertica sql functions but getting error that it requires permission

324
P
Level 4
michaela.gebha
Level 3
michaela.gebhaLevel 3
asked in General Product Q&A
Hi, is there a way to prevent that an Action Engine Signal is resolved by the system automatically, but can only resolved manually by the responsible user?

Hi, is there a way to prevent that an Action Engine Signal is resolved by the system automatically, but can only resolved manually by the responsible user?

11
M
Level 1
K
Level 2
kalina.todorLevel 2
asked in General Product Q&A
How to delete tasks in an app/view in Studio

Hi All, I have created a task component in a view and we have tested it by creating multiple demo tasks. Now, we would like to delete all test tasks we have assigned before we launch the app. Is there a way to do that without creating a whole new record in the KM? Thank you,Kalina

22
.
Level 5
F
Level 3
federico.sparaLevel 3
asked in General Product Q&A
Compare dates in the same column based on activity name

Hi all, In my activity table I have two specific activities named subprocess start and subprocess end. Before, between and after this two activities there are other activities and I need to count how many happened before, during and after the subprocess.Each activitiy has an eventtime, but I'm not able to compare them. Approaches already tried (for now I'm focusing on activities happened BEFORE, since I thought that it would have been easy to add other case when for during and after scenarios afterwards: (CASE WHEN DATEDIFF(ms, "ACTIVITY_TBL"."EVENTTIME", CASE WHEN "ACTIVITY_TBL"."ACTIVITY_NM" = 'subprocess start' THEN "ACTIVITY_TBL"."EVENTTIME" END) > 0THEN '1' ELSE 0 END) (CASE WHEN "ACTIVITY_TBL"."EVENTTIME" < CASE WHEN "ACTIVITY_TBL"."ACTIVITY_NM" = 'subprocess start' THEN "ACTIVITY_TBL"."EVENTTIME" ENDTHEN 1 ELSE 0 END) Both

64
F
Level 3
T
Level 2
takashi.masud11Level 2
asked in General Product Q&A
I would like to know how to retrieve files on the local server using Celonis functionality.

I would like to know how to retrieve files on the local server using Celonis functionality. For example, I would like to know how it can be realized with the functions provided by Pycelonis and Celoxtractor. Is it possible to get files to Celonis without using Data Transfer API such as HULFT?

174
T
Level 2
P
Level 1
pasca.relliLevel 1
asked in General Product Q&A
Hi I worked for Finedigit one of your partner. I would like to know how we can have a call to set up our plateform access?Thanks for your answer.RegardsMatthieu

Hi I worked for Finedigit one of your partner. I would like to know how we can have a call to set up our plateform access? Thanks for your answer. Regards Matthieu

02
teuku.faruq13
Level 5

Badge Winners

VIEW ALL
Community Code of Conduct