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,559 Topics
  • 5,879 Replies
2558 Topics
miguel.ferna11
Level 3
miguel.ferna11Level 3
asked in General Product Q&A
Write data to table skill writting to global scope

I'm trying to update a column in the activity table, but the Write data to table skill only writes to the global scope, where my Data Model can't see it. Is there a way to change the skill configuration? Or maybe the Data Model?

20
miguel.ferna11
Level 3
s.a14
Level 3
s.a14Level 3
asked in General Product Q&A
How to summarize time spent by each workgroup on re-assignment of an incident?

Hi,  Can you help me with a PQL that can showcase total time spent by each workgroup on an incident? The incidents can be re-assigned between different workgroups in its life cycle. output required  Workgroup Avg time spent on incidents Volume of Incidents handled A XX mins. 10 incidents B XX mins 20 incidents Example data below.

10
C
Level 1
S
Level 3
suvam.nayak12Level 3
asked in General Product Q&A
I am trying to create a Analysis level filter which will filter according to the user input given in the input dropdown. But not able to figure it out.

I am trying to create a Analysis level filter which will filter according to the user input given in the input dropdown. But not able to figure it out.

506
S
Level 3
J
Level 3
jan.van.d12Level 3
asked in General Product Q&A
I want to calculate the number of cases in which each possible activity has reoccurred multiple times. How am I able to do this?

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc. I know with MAX of INDEX_ACTIVITY_TYPE I can get the max occurrences of the activity name, but I do not seem to be able to find out how to use this in an OLAP formulation. Thanks in advance!

170
J
Level 3
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General Product Q&A
Updating Augmented Attribute via Button

Hi all I have a fairly common question I believe:I have a linked View which focuses on one single instance of object. This has two augmented attributes: status and freetextfield of reason. The View has an ID variables (and filters) to narrow down on exactly one object. Now I am only aware of updating augmented attributes via a table and a row. But I would rather use a more userfriendly way of a Button + Input Field to update the Object characterized by the ID.  Does anyone have a similar setup and a solution on updating Augmented Attributes via anything else but an OLAP Table? I could imagine an Action Flow and passing in the ID, but I am unsure if its possible to trigger one via a Button Component.

180
mallik.koruk11
Level 3
michael.kohlm
Level 2
michael.kohlmLevel 2
asked in General Product Q&A
Hi, I am using the academic version and there is no database connector as it is in the "real" version. Nevertheless I want to connect my local PostgreSQL database with Celonis. Is there any way to do that? Thank you in advance!

I tried it already with the Extractor Builder and a "Basic Authentification" but it didn't work.

30
laura.walku11
Level 1
muthappan.alaga
Level 4
muthappan.alagaLevel 4
asked in General Product Q&A
Is there an api to read User adoption asset tracking service information in automated way?

API to extract and push it to data pool, so i can build an analysis for visualization. Right now i am manually exporting to Excel and uploading it into to a data pool and then to Data Model. Have a visualization on top of it, so it is too many manual tasks, trying to automate this. ThanksMuthappan

40
emil.vakhi12
Level 3
karl.guent
Level 4
karl.guentLevel 4
asked in General Product Q&A
I am trying to create a column chart which the count of the number of Claim ID's in a Work Order.

For instance, ... 5 WO's have 3 Distinct Claim ID's, 7 WO's have 2 Distinct Claim ID's, and 125 WO's have 1 Claim ID. Thank you ... I am sure this is simple, but I can't find how to do it.

80
.
Level 3
junwei.chai
Level 3
junwei.chaiLevel 3
asked in General Product Q&A
Hi, is there a way to export/download data from an existing table that is in data job/data integration?

e.g. in schema explorer there are two tables that i want to export the data and put it into another environment.

60
junwei.chai
Level 3
A
Level 4
akshay.haridLevel 4
asked in General Product Q&A
Can anyone suggest the best documentation for learning how API's can be used or how custom API's can be built in order to access data regarding different objects in Celonis.

Can anyone suggest the best documentation for learning how API's can be used or how custom API's can be built in order to access data regarding different objects in Celonis.

33
bruhathi.reddy11
Level 2
douglas.souza
Level 3
douglas.souzaLevel 3
asked in General Product Q&A
Date Field

Can anyone help me with this problem, I'm not able to convert this date field in this format to SQL. Does anyone know if I can get this in PQL? Or even in SQL 08-JUL-24

00
rita.kiss12
Level 4
S
Level 1
sai.kaush11Level 1
asked in General Product Q&A
Facing SAML Authentication error when trying to login into Celonis Academy

41
cristina.gómez11
Celonaut
P
Level 3
pruthvin.v11Level 3
asked in General Product Q&A
Hi, I'm getting this error in Open PR app, "Table could not be found. Table with name "PR_ITEMS_CEL_TASK" cannot be found". can anyone please help me with the solution.Thank you

Hi, I'm getting this error in Open PR app, "Table could not be found. Table with name "PR_ITEMS_CEL_TASK" cannot be found". can anyone please help me with the solution. Thank you

120
P
Level 3
D
Level 3
deepak.kumar30Level 3
asked in General Product Q&A
Action flow module/filter to remove the duplicate operations/output from array aggregator module.

There is 9 similar operations/output from the Array aggregator module inside action flow. How to reduce or remove the duplicate operations from the array aggregator(considering that change is any prior modules not possible but ready to adapt any filters ot add any more modules after the array aggregator module giving 9 similar operations)? Thanks!

70
D
Level 3
magdalena.silak11
Level 3
magdalena.silak11Level 3
asked in General Product Q&A
Filter on the extraction level from a different table.

Hi team, our business would like to see some historical data from BSEG (as now we have the oldest data from 2023). We were able to apply filter on the extraxtion level on BSEG, that the GJAHR is 2023 OR KOART is equal t specific Account type that they had in mind. This ent through correctly however the analysis is basing on BSEG and BKPF, so we would need to do the same corre ction in extraction filter for BKPF, but unfortunately the field account type is not available there. The question is. Are we able to use field from one table (BSEG) as a filter in extraction for different table(BKPF)? I tried to do that as a join configuration:However it did not work - I did not get any data older than 2023, so I believe this filter applies only to joined table (BSEG) instead of BKPF. In the Filter statment for BKPF I am not able to include fields from BSEG. evean after using joined configuration. If you have any suggestions, I would be very greatful!! BR,Magda

175
matt.witty13
Level 5
carlos.vinti
Level 2
carlos.vintiLevel 2
asked in General Product Q&A
Is there a way to obtain all Permissions available in Celonis?

I need to show a client all available permissions in the platform in order for their security department to determine which user gets what permission. Before doing all this manually, I wanted to know if there is a way to obtain all available permissions in the platform?

00
F
Celonaut
philipp.finze
Level 2
philipp.finzeLevel 2
asked in General Product Q&A
Is it possible to create a dynamic title of an OLAP table in views depending on the selected breakdown?

I know that a dynamic title is possible by using an attribute. It would be great, if it is possibly by linking to the breakdown selection, too.Please see the screenshot for reference. After 'Cash discount statistics per' the selected breakdown entry should be added to the title.

261
V
Level 2
B
Level 2
bushra.taskeLevel 2
asked in General Product Q&A
Hi, I am trying to add a dropdown list of multiple dropdown in New View but i am unable to create a variable because its being stored in the form of object.I want to create and add a variable in the dimension of a Donut Chart & a table.

When selected from dropdown entry the result should reflect in both donut chart as well as in table. Can anyone help me to resolve it?

20
V
Level 2
H
Level 3
huseyin.simseLevel 3
asked in General Product Q&A
Hi, is there a way to see/use autogenerated KPI in the View?

Hi, is there a way to see/use autogenerated KPI in the View?

22
H
Level 3
H
Level 3
huseyin.simseLevel 3
asked in General Product Q&A
Hi, I am quite new for Celonis and I am curious about that is it possible to select start time and end time for each activity to see its completion time?

(I know I can make this configuration into OLAP Table; I am looking for seeing this calculation automatically within predefined assets)

22
H
Level 3
.
Level 3
.1683757Level 3
asked in General Product Q&A
How to check if a number starts with 10? this number might consists of any number of digits '1023456789', the most important thing it starts with 10 and i don't care about the rest.

Will  Case When var_number IN (10) get the correct result? Thank you.

00
.
Level 3
manuel.wetze
Level 5
manuel.wetzeLevel 5
asked in General Product Q&A
Choosing EventLogs (or Activities) interactively for Process Explorer

Hi all I am currenlty investigating very basic Visualizations in Process Explorer.Ultimately I want the User to be able to include/exclude Activities in a matter where they are actually excluded form the the Directly Follows relations which are the edges of the graph.  as a minimal example lets say I have only Act A, Act B and Act C and only one case with variant A->B ->C. If B gets deselected I want the process explorer show to show A->C then. The existing Graph Control Panel only hides the activities so it would actually remove B and A->B and A-> and no data remains. I just stumbled across the REMAP VALUE (Activitycol, ('B', NULL)) PQL which would allows me to create a second event log in KM where I can then do the REMAP but only preemtively and hardcoded. I want the user to give some degree of freedom and customization the dashboard to select either a whole Event Log to be used (then I would just prepare 2 or 3) or actually do a select on the activities itself

20
manuel.wetze
Level 5
chi.wing.liu
Level 2
chi.wing.liuLevel 2
asked in General Product Q&A
Table & Profile View for Categories

Hi all, i am trying to build a table and profile view that is similar to the ones that are shown in the celonis demos (table from celonis demo)(profile view from celonis demo) What I am trying to show is some root causes for the bottlenecks in the process and when user clicks on the category, a detailed analysis will be displayed  But im still struggling with the first step which is how do i get to display those bottlenecks in the table, do i need to create a new table just to store those 'inefficiencies'?  Thanks for your help in advance!

110
C
Level 1
jesus.herna
Level 2
jesus.hernaLevel 2
asked in General Product Q&A
Hi,Can anyone help me with the pql code to BIND to connect the Eventime of the creation of a purchase order and the release date of a requisiton?I don´t get the logic of BIND yet

Hi, Can anyone help me with the pql code to BIND to connect the Eventime of the creation of a purchase order and the release date of a requisiton? I don´t get the logic of BIND yet

174
jesus.herna
Level 2
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Product Q&A
Send out a Mail via an AF - add persons to the CC?

Hello everyone, I'm intending to send out data to stakeholders (numerous documents to a stakeholder - n:1 relation). I'm using the query module, csv module and the microsoft outlook module to implement it like this. Therefore, the documents will be aggregated on the basis of a stakeholder - this file will be sent out. However, per document, internally, there could be different employees assigned/responsible for those documents. Is it possible to put them into the CC of the mail (sending out to one stakeholder but numerous internal employees that should be notified - 1:n)?  Thank you so much! Best regardsJulia Bauer

60
julia.bauer
Level 5

Badge Winners

  • Qualified to Create and Deliver Demos
    anna.jakub12has earned the badge Qualified to Create and Deliver Demos
  • Masterclass in Implementation
    marwan.elkad11has earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    lyzanne.tr24has earned the badge Masterclass in Implementation
  • Masterclass in Implementation
    elliott.thas earned the badge Masterclass in Implementation
  • Celonis Certified Data Analyst
    min.bae11has earned the badge Celonis Certified Data Analyst
VIEW ALL
Community Code of Conduct