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,576 Topics
  • 5,906 Replies
2575 Topics
G
Level 1
gaurav.tripa13Level 1
asked in General Product Q&A
Hi Team,Can anyone tell me about how to connect Celonis platform with Microsoft Dynamcis 365(in backend). What are the pre-requisite I needed before making the connection.

I have gone through the Celonis documentation but it only speak about connection through front end(action -flow) but there is nothing mentioned about connection in bBackend

160
V
Level 2
H
Level 3
huseyin.simseLevel 3
asked in General Product Q&A
How to group three column values into one column value

Hi, I have one chart and in this chart I do have one dimension which is showing countries. Also, I do have one metric which is showing Automation Rate.Dimension/Country names are A-B-C-DMy need is that I need to combine A-B-C into A so in the end I need to see A-D with their Automation Rate.How can I make it? What are the ways that I can follow into Studio?

50
kalpesh.yogi
Level 2
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in General Product Q&A
Export KPI's from view or KM into documents

Good day everyone. With Analysis one could export the KPI's on an analysis into a document - is that possible for Views? I am using the old views?

90
mateusz.dudek14
Level 7
shayan.sarka12
Level 2
shayan.sarka12Level 2
asked in General Product Q&A
Setting up live connection with Informatica

Hi Celopeers,I would like to set-up a live connection with Informatica for fetching data for Celonis. What would be the best way to go about it?

300
mateusz.dudek14
Level 7
nitish.kumar23
Level 2
nitish.kumar23Level 2
asked in General Product Q&A
How can i send the csv through action flow while using the smart sensor?

How can i send the csv through action flow while using the smart sensor?

70
mateusz.dudek14
Level 7
miguel.ferna11
Level 3
miguel.ferna11Level 3
asked in General Product Q&A
How to perform a GET request from the ML Workbench?

The idea is to have a script that automatically downloads a json file with the list of members of the Celonis environment through the Members API (/api/external/members). I have the following code: url = ""api_token = ""key_type = "AppKey" headers = { key_type: api_token, 'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36',  'Body-Type': 'application/json', 'Accept': 'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7'}response = requests.get(url=url, headers=headers) This code always returns <Response [403]> (Access denied). However, the api key I'm using works perfectly in the Swagger UI webpage, being able to download the json file without any problems. I wrote a ticket to Celonis support and they told me it's possible to p

380
miguel.ferna11
Level 3
christopher.bowde
Level 2
christopher.bowdeLevel 2
asked in General Product Q&A
Is there a way to only publish Knowledge Model asset objects, not the whole Knowledge Model asset?

Is there a way to only publish Knowledge Model asset objects, not the whole Knowledge Model asset?

00
K
Level 3
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Product Q&A
Filtering Data - Send out Data Records for the next workweek

Hello everyone, I want to send out every Monday (e.g. 12.08) all data records (e.g. deliveries) for the next workweek (19.08-23.08.24). I think I haven't found the right functions yet, therefore cannot wrap my head around how to implement this. Does anyone have an idea how to filter the data like this? Thank you! BRJulia Bauer

40
julia.bauer
Level 5
A
Level 2
andrea.march14Level 2
asked in General Product Q&A
How to properly model multi-value attributes in Celonis data model?

Hello everybody,I have a data model in which I need to manage one of the case attributes that can have multiple values simultaneously for a single case (i.e. a multi-value attribute) and I am wondering about which is the proper why to model it. In other DBs and DWHs, I usually model this situation with an additional table linked to the main master data with an N:1 relationship (N records for each master data record), but if I do such thing on Celonis and then connect the master data table to the Activity Table with a 1:N relationship (N activity records for each master data record), when I try to display the Throughput Time by the multi-attribute values, I get the infamous "No common table could be found" error message. Which is the recommended way to model multi-value attributes in Celonis data model creation? Thank you, best regards,Andrea

80
A
Level 2
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 an X number of times exactly. How can I 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 that with the following code I can get the number of cases where the activity happened at least 1 time, but I do not know how to calculate the number of cases where the activity happened 1 time and not more often.  SUM(CASE WHEN INDEX_ACTIVITY_TYPE ("ACTIVITY_TABLE"."ACTIVITY") = 1 THEN 1 ELSE 0 END) The other thing I still miss is how I can calculate the number of cases in which that activity occurred >=2 times. When I change the formula to >=2, I get the wrong count as then a case with 4 activity occurrences is counted as 3 instead of 1 (it counts the second occurrence, third occurrence and fourth occurrence all as one 'case'). Is there

100
abhishek.chatu14
Level 7
R
Level 2
ram.praka17Level 2
asked in General Product Q&A
GRIR Analysis Value QuantificationIs there any Business Case Where GRIR Analysis Value Quantification is a Tangible Outcome? - E.g. P&L, WC Type impact apart from Productivity?

GRIR Analysis Value Quantification Is there any Business Case Where GRIR Analysis Value Quantification is a Tangible Outcome? - E.g. P&L, WC Type impact apart from Productivity?

70
abhishek.chatu14
Level 7
R
Level 2
ram.praka17Level 2
asked in General Product Q&A
Debit Balance Analysis.Can anyone provide any UI/UX parameters which was deployed across their AP Analysis? Any wireframes which i can refer?

Debit Balance Analysis. Can anyone provide any UI/UX parameters which was deployed across their AP Analysis? Any wireframes which i can refer?

20
abhishek.chatu14
Level 7
H
Level 3
huseyin.simseLevel 3
asked in General Product Q&A
Questions about Variable usage in KM and View Asset

Hi,   I have two questions;   -I created variable into the KM but I cannot see them in the View Asset to be used -I have Input dropdown in the View asset and I want to assign user selection into KM Variable; is it possible?  

00
abhishek.chatu14
Level 7
parvathi.choud
Level 4
parvathi.choudLevel 4
asked in General Product Q&A
I have created an activity table with 5 activities,i also created the change activities by joining both activity table and change table,but when i use select distinct activities from activity table im getting only 5 activities,i want change acti

I have created an activity table with 5 activities,i also created the change activities by joining both activity table and change table,but when i use select distinct activities from activity table im getting only 5 activities,i want change activitis also

20
abhishek.chatu14
Level 7
M
Level 2
miguel.moraLevel 2
asked in General Product Q&A
How Can I obtain the n-th value in the a list?

If FIRST(column) would return the first element and LAST(column) the last one, I would like to obtain the n-th element of that list. There isn't a straightforward function to do that but is there a way?

90
mateusz.dudek14
Level 7
P
Level 1
priyadharshini.r15Level 1
asked in General Product Q&A
Can i change my name after completing training track and get certificate with the changed name?

WRONG Name: PRIYADASHINI RCORRECT NAME: PRIYADHARSHINI R 

70
R
Celonaut
enrico.pugli12
Level 3
enrico.pugli12Level 3
asked in General Product Q&A
Color mapping based on values of Dimensions in OLAP Table

Hi everyone, I would like to create a color mapping for a KPI in a OLAP TABLE.Each row in the table represents a case, with ID, an attribute from the same table (numeric), and a KPI created on that attribute (also numeric).I would like to color the value of the KPI based on the value of that attribute, for each case. For example, if it is greater in red, if it is less in green.I selected color mapping based on Dimension, and entered the first threshold as in the figure, but it colors everything red, not taking into account the value of the attribute.  Where am I going wrong? Thanks 

640
enrico.pugli12
Level 3
C
Level 2
charinchunyu.liuLevel 2
asked in General Product Q&A
I am new user for celonis, I would like to apply for the new account for COTD (Customer order Deliver Delay). but there are so many choice when I raise a support for new count ticket, I am quite confused, where can I get guide or support?

I am new user for celonis, I would like to apply for the new account for COTD (Customer order Deliver Delay). but there are so many choice when I raise a support for new count ticket, I am quite confused, where can I get guide or support?

40
C
Level 2
S
Level 2
sayan.chakr11Level 2
asked in General Product Q&A
Trigger actionflow from skill

I need to create an action in KM, which will help me to take specific input from a table and pass it to actionflow and the SAP rfc module in actionflow will write the infos in Source. From a skill i am not able to pass the inputs to actionflow. How to do this? the input should be multiple single values to actionflow and the actionflow will take those inputs and operate.

60
S
Level 2
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?

30
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.

30
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.

570
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!

280
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.

260
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

Badge Winners

  • Value Assessment Expert
    gabriela.cruzhas earned the badge Value Assessment Expert
  • Qualified to Identify and Drive Opportunities
    gabriela.cruzhas earned the badge Qualified to Identify and Drive Opportunities
  • First Post
    joaocarlos.maciehas earned the badge First Post
  • First Post
    asdfghas earned the badge First Post
  • Celonis Technical Expert
    Clarahas earned the badge Celonis Technical Expert
VIEW ALL
Community Code of Conduct