Skip to main content

Product Q&A

Ask questions and get answers about Celonis products from experts and peers.

3152 Topics
A
Level 3
arturo.orteg11Level 3
asked in General Product Q&A
when testing one of my connections to sapp ecc this error pops up: Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Error during connection validation: User is locked. Please notify

... the person responsible does anyone know how to solve this?

120
A
Level 3
carmem.caval
Level 3
carmem.cavalLevel 3
asked in General Product Q&A
Is it possible to aggregate operations in Action Flow?

I'm dealing with an issue in Action Flow. I have a text cell within an xlsx file that needs to be parsed using regex, and this data needs to be saved into a new table. I can handle this initial part using the text parser, iterator, and array aggregator, but it results in the data being separated into operations. I have around 5k records to process and iterate through, which ends up generating more than 10k operations. What I want to do is aggregate all of these into a single file, thus avoiding the need to make 10 thousand HTTP requests. Does anyone know if this is possible?

150
abhishek.chatu14
Level 7
chi.wing.liu
Level 2
chi.wing.liuLevel 2
asked in General Product Q&A
Date value different between excel and data model

Hi all, I am new to Celonis and I am trying to upload the data model using excel / csv, however the time value looks different when i upload it to Celonis. Would you please help to see how can i show exactly the same time on Celonis? Thanks in advance! Time value in Excel Celonis

30
S
Celonaut
filippo.venut
Level 2
filippo.venutLevel 2
asked in AI
MLWorkbench: Data Push status: QUEUED

Hi all! First time here, but god a question. I am running a python script (pycelonis 1.7.6) that needs to push data into a table. Everything work fine unless the data push: datamodel.pool.create_table(df_or_path = res,table_name = 'TABLE_NAME',if_exists = 'drop',column_config=column_config) which returns: [2024-07-23 16:26:09] INFO: Data push job status: QUEUED... [2024-07-23 16:26:14] INFO: Data push job status: QUEUED... [2024-07-23 16:26:19] INFO: Data push job status: QUEUED... [2024-07-23 16:26:25] INFO: Data push job status: QUEUED... [2024-07-23 16:26:30] INFO: Data push job status: QUEUED... [2024-07-23 16:26:35] INFO: Data push job status: QUEUED... [2024-07-23 16:26:41] INFO: Data push job status: QUEUED... [2024-07-23 16:26:46] INFO: Data push job status: QUEUED... [2024-07-23 16:26:51] INFO: Data push job status: QUEUED... [2024-07-23 16:26:57] INFO: Data push job status: QUEUED... Same functionality on another table worked flawlessly, for this specific one it queues. Is th

100
S
Level 3
chi.wing.liu
Level 2
chi.wing.liuLevel 2
asked in General Product Q&A
Export OLAP table to Excel

Hi all, I was trying to export OLAP table data to excel but couldnt find the export button, where can I enable this? Thanks!

450
chi.wing.liu
Level 2
M
Level 2
mikel.izaskLevel 2
asked in General Product Q&A
Is there any way to loop over a table in a SQL transformation?

Let's say I have two tables: - TABLE A: User ID, many other cols. [PK is User ID] - TABLE B: User ID, many other cols. [Many lines per User ID] Is there any way I can go through each User ID in TABLE A and do in the SQL transformation something such as: Declare TABLE C for each User ID in TABLE A Append TABLE A.User ID, TABLE A.Name in TABLE C Select * from TABLE B where TABLE B.User Id = TABLE A.User Id Append TABLE B.User ID, TABLE B.Other Field in TABLE C The idea would be to create a table in which you can find each line in TABLE A followed by every line for that same ID in TABLE B. Sorry for the poor SQL terminology, as I am not very used to it. Thank you so much in advance.

20
rita.kiss12
Level 4
A
Level 1
agnieszka.grzesLevel 1
asked in General Product Q&A
In my studio settings and/or package settings I am missing themes creation option. How can I configure a theme/colour/logo template -> https://docs.celonis.com/en/2442167.html

In my studio settings and/or package settings I am missing themes creation option. How can I configure a theme/colour/logo template -> https://docs.celonis.com/en/2442167.html

00
rita.kiss12
Level 4
siva.bahad
Level 3
siva.bahadLevel 3
asked in General Product Q&A
Dear Community Members,Have anyone of you tried applying the table using the ERDAT field in Daily Delta load. If yes have you reconsiled whether it captures the change and insert data?

Basically, delta load captures when there is any change, update, insert happens based on the Change date like CPUDT, UDATE. But when we have the ERDAT as delta filter it will just capture the new record but what will happen to the Change ? Does any one tried this or come across this senario?

20
connor.manth
Level 3
K
Level 2
keval.shahLevel 2
posted in AI
Hi Team,

Hi Team, I need assistance with building a Generative AI-based use case in Celonis. As a starting point to understand the various functionalities of Celonis, I aim to develop a basic chatbot system. Here’s where I need help: I want to create a view in Celonis that mimics the look and feel of ChatGPT, where I can ask questions related to the data and receive responses. I have successfully integrated OpenAI with the Machine Learning Workbench, but I’m not sure how to trigger the Machine Learning Workbench from my Celonis views using a button click and display the response appropriately. As I am new to Celonis, I would greatly appreciate a detailed explanation. Thank you for your help. TLDR : Help me understand to built the UI, where i can write in input box my query, on click the button i want to run my ml work book code and then show it as a text response on my views(my ml workbook has open-ai integrated)

111
K
Level 2
F
Level 2
federico.arribLevel 2
asked in AI
How to call ML Python from Action flow and receive a response

Hello everyone, I am trying to call a ML python script from an Action Flow with some parameters. Do some math with it, and give a response to the same Action Flow. Following the documentation in Trigger Machine Learning Script (celonis.com), I have been able to call the Python code, pass some parameters, process them and then call a NEW Action Flow. Is it possible to make the first action flow wait for a response and make a GET or something similar so you continue in the same action flow? Thank you, Federico Arribas.

410
K
Level 2
axel.bühle12
Level 3
axel.bühle12Level 3
asked in Process Analysis
Parsing of variable containing list of string values not working as expected (filter evaluating this list for an IN statement doesn't work)

Hi, I have been trying to build a filter in the new view based on a variable - but couldn't get it to work. Target filter should look like this (and the explicit example below works): FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in ('9000100043','9000100188','2000000007') The variable contains a list of strings, each string enclosed by single quotes, separated by a comma, see below - as I couldnt make it work I tried different versions in respect to start and end of string (with or without parentheses and single quotes) ('9000100043','9000100188','2000000007') '9000100043','9000100188','2000000007' 9000100043','9000100188','2000000007 I didn't get any of these filter expressions working: FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in ${path_from_top} FILTER "DEV_CUSTOMER_HIERARCHY"."KUNNR" in (${path_from_top}) the filter is flagged with a red square on the left, but doesnt break the view interestingly - if I artificially add an error into the filter to get an error message, the error message s

80
axel.bühle12
Level 3
N
Level 2
nicola.lomba11Level 2
asked in General Product Q&A
Create a chart in which we count for every month the number of cases ending with a precise activity

Hi everyone, I would like to create a chart where I show for each month the number of cases that satisfy some conditions in terms of process activities. Specifically, I need to count the number of cases that every month end with activity A. Therefore, if a case at the end of the May and at the end of June ended with activity A and in July it ends instead with activity B, I want to see it in both the column of May and June but not in the column of July. I tried to combine the TIMELINE_TABLE function with the MATCH_PROCESS function but it only takes into consideration those cases that satisfy the requirement today. Do you think it is possible to get what I need? Thank you in advance for your help!

80
luis.marti11
Level 2
.
Level 3
.1683757Level 3
asked in General Product Q&A
How can i add description to dashboard KPIs to be shown when the user hover over them in JAB?

I want to add descriptions to KPIs and predifined filters in my view so that this description is shown when the user hover over. I tried to do so in the KM, but nothing is shown and the components themselves don't have the label or description field. Any idea how to do that?

40
.
Level 3
bennita.dutoi12
Level 4
bennita.dutoi12Level 4
asked in General Product Q&A
How do I create a stacked bar graph where the bar is broken up into a specific dimension e.g. vendor names.

Hi, Please help. I want the blue bars to be broken up /split up into vendor names, so if there is 2 vendors their order values should add up to the total stacked on each other. id: chart-c1c15300-c92b-4d97-8598-b90b8aa0069d type: chart settings: limit: 20 sortBy: - id: f8639d07-e8cb-4f72-b6b4-16da36b1d74b field: KPI_PO_ITEM_THREE_WAY_MATCH_ORDERED_VALUE direction: DESC order: 100 visuals: - id: 3eabb17a-7f5a-43d1-8d50-0d24bfa526e8 mark: type: bar bandwidth: 0 order: 100 encodings: {} encodings: x: field: PO_ITEMS.MATERIAL_GROUP_MATERIAL_GROUP_TEXT y: field: KPI_PO_ITEM_THREE_WAY_MATCH_ORDERED_VALUE

310
bennita.dutoi12
Level 4
kandi.naidu
Level 4
kandi.naiduLevel 4
asked in General Product Q&A
How to apply time range filter in create pdf filter option using two variables.

Hi, I'm attempting to create a PDF report that includes a time filter, such as a start date and end date. The timestamp column in my data is currently in the format of "Mon Feb 28 2022 11:45:11". The values in the timestamp column are in the format of YYYY-MM-DD HH:MM:SS. I've set up a filter using the following code: FILTER "table"."column" >= TO_DATE({{13.Start_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' )) AND "table"."column" <= TO_DATE({{13.End_Date}},FORMAT( '%Y-%m-%d %H:%M:%S' )); However, I'm still receiving an empty PDF report. Could you please help me identify what I'm doing wrong? Thank you.

80
kandi.naidu
Level 4
A
Level 3
anil.vishLevel 3
asked in Data Ingestion & Infrastructure
We would like to have a date range component and save the end date to a variable, based on the date variable have a PQL filter that would refresh the table in a view. I tried to implement it but it is erroring out.

The PQL statement is FILTER ("ACDOCA_AP_SUSPENSE"."AUGBL" IS NULL OR "ACDOCA_AP_SUSPENSE"."AUGDT" > {d '2024-06-02'}) AND "ACDOCA_AP_SUSPENSE"."BUDAT" <= {d '2024-06-02'}; The above PQL statement works fine when I hardcode the date. I have created a date variable in a view(Is it possible to default it to the current date?). I want the user to select a date from the date range component, the date variable gets updated from the END date of the Date range and the PQL statement gets executed based on the selected date. But for some reason, it does not work for me. The PQL Statement is FILTER ("ACDOCA_AP_SUSPENSE"."AUGBL" IS NULL OR "ACDOCA_AP_SUSPENSE"."AUGDT" > {d '<%date_filter%>'}) AND "ACDOCA_AP_SUSPENSE"."BUDAT" <= {d '<%date_filter%>'}; The error I get is attached in a screenshot. Any suggestions on fixing this or alternative solutions would be appreciated.

200
A
Level 3
A
Level 3
anil.vishLevel 3
asked in Data Ingestion & Infrastructure
Is there a variable in PQL that I can use to display the datamodel refresh date & time?

Is there a variable in PQL that I can use to display the datamodel refresh date & time?

40
rita.kiss12
Level 4
rui.mende11
Level 1
rui.mende11Level 1
asked in General Product Q&A
Extract data from Celonis using SQL script and Pycelonis lib

Hi Everyone, I want to ask if exists some way to extract data with PyCelonis lib but based on SQL scripts ( with transformations, for example). I know that we have access to the SQL script by this example: https://github.com/celonis/pycelonis-examples/blob/main/pycelonis1/03_Connectivity/05_Transformation_Download_to_MLW.ipynb but my idea is to use this SQL and run it and export (.csv files ) or work this data with Python ( pandas data frame ) .

90
N
Level 1
C
Level 2
chandrashekhar.burdeLevel 2
posted in Data Ingestion & Infrastructure
Level 1: Newbie (0 - 10 points)

Level 1: Newbie (0 - 10 points) I just join Celonis. Help me to explore Celonis Platform!

33
C
Level 2
gauri.pai11
Level 2
gauri.pai11Level 2
asked in General Product Q&A
I want to add days to a date in vertica SQL in transformations.I have tried using DATEADD and TIMESTAMPADD, both are showing permission denied.Please help how can i achieve this.

I want to add days to a date in vertica SQL in transformations. I have tried using DATEADD and TIMESTAMPADD, both are showing permission denied. Please help how can i achieve this.

110
kandi.naidu
Level 4
A
Level 3
ayushi.ade12Level 3
asked in Process Analysis
Hi All,I am trying to create a overlay view in new studio, created a target view as well. However when I click on the sales order in my main view the target view value is not updating, mapped a variable as well

Hi All, I am trying to create a overlay view in new studio, created a target view as well. However when I click on the sales order in my main view the target view value is not updating, mapped a variable as well

210
A
Level 3
G
Level 1
gaurav.tripa13Level 1
asked in General Product Q&A
Hi Team, I am facing below error while making connection through Extractor Builder:"Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Connection configuration invalid"

Hi All, This is the detailed explanation regarding what Information I have, what steps and option I followed to make this connection: Steps followed: Add Data connection-->Connect to Data Source-->custom-->Build Custom Connection-->Build a new extractor: (1) Extractor Information: Input provided in the Name filed (2)Connection Parameters: Unchanged (3)Authentication Methods: API Key Authentication Selected and In the API Key header: Key generated from admin setting was entered .e.g. x-api-key:"Generated Key". (4)Define Endpoints: Add new endpoint--> (A)Configure Endpoint: Endpoint name(entered)-->HTTP Method(GET)-->Use this endpoint for connection test(enabled) (B)Configure Request URL: {Connection.API_URL}/"Endpoint URL entered" Request Parameters: Leaved as it is Headers-->Add new header-->"Key and Value" entered Pagination Method: Leaved as it is (C)Configure Response: Leaved as it is Clicked Fininshed.

470
G
Level 1
gauri.pai11
Level 2
gauri.pai11Level 2
asked in General Product Q&A
Hi team,Is there any way to link power apps to celonis to enable workflow mechanism.

Hi team, Is there any way to link power apps to celonis to enable workflow mechanism.

00
mateusz.dudek14
Level 7
gauri.pai11
Level 2
gauri.pai11Level 2
asked in General Product Q&A
Hi team,This is related to PQL function CURRENCY_CONVERT_SAP.I want to know how this field GDATU from TCURR table is converted to date once it is in string in celonis.

Hi team, This is related to PQL function CURRENCY_CONVERT_SAP. I want to know how this field GDATU from TCURR table is converted to date once it is in string in celonis.

30
rita.kiss12
Level 4
julia.bauer
Level 5
julia.bauerLevel 5
asked in General Product Q&A
How to create a dimension switcher?

Hello everyone, I want to create a dimension switcher within a view (s. example from a Celonis App). In the installed APP, however, I cannot access the originial knowledge model as the one visible is an extension. Hence, I do not know how the configuration of a dimension switcher is done on the YAML knowledge model side. Does anyone have a step by step explanation? Thank you! Best regards Julia Bauer

00
julia.bauer
Level 5

Badge winners

VIEW ALL
Community Code of Conduct