- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

1 month ago

Home
Community
Product Q&A
General Product Q&A

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

1,413 Topics
3,352 Replies

When you subscribe we will email you when there is a new topic in this category

1413 Topics

Recently active

Most replies Most views Newest first

bennita.dutoi12Level 3

asked in General Product Q&A

Global FIlter in old views

We have a global date filter for filtering out dates. Now we want to create case explorer that should have the global filter on. If the global filter is on it dont show all the events that is not in the date filter. any ideas how I can exclude the global filter for 1 view

3 months ago

janpeter.van.dLevel 8

asked in General Product Q&A

Components not loading due to 'large amount of data'

Hi all, In one of our Studio Views, some components are not loading. We see the error message: 'The component contains a large amount of data. Loading may cause the browser to crash'. It is just a KPI-bar component that worked properly before, but after we did some additional checks in between to set the scope of the cases correctly, it is not loading anymore. My question is, what are the limits before such error messages pops up, or are there any best practices to solve this easily (for instance, a max number of nested KPIs or max number of rows?). This would help us in solving the issue. Best regards,Jan-peter

3 months ago

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?

3 months ago

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?

3 months ago

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 ExcelCelonis

3 months ago

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!

3 months ago

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 AAppend TABLE A.User ID, TABLE A.Name in TABLE C Select * from TABLE B where TABLE B.User Id = TABLE A.User IdAppend 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.

3 months ago

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

3 months ago

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?

3 months ago

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!

4 months ago

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

4 months ago

bennita.dutoi12Level 3

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-b90b8aa0069dtype: chartsettings: 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

4 months ago

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.

4 months ago

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.ipynbbut my idea is to use this SQL and run it and export (.csv files ) or work this data with Python ( pandas data frame ) .

4 months ago

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.

4 months ago

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 isHeaders-->Add new header-->"Key and Value" enteredPagination Method: Leaved as it is (C)Configure Response: Leaved as it is Clicked Fininshed.

4 months ago

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.

4 months ago

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.

4 months ago

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 regardsJulia Bauer

4 months ago

raisa.ukuLevel 2

asked in General Product Q&A

Automate user list overview & send notifications with a specific schedule

Hi Celopeers, Is it possible to create an overview (i.e. Olap table) of all Celonis users (per group), and set up an action flow with this info (i.e. send a list of all users to specific email addresses monthly). Does something exists about it? I`m looking for smth that automates the manual process: manually going to Admin/Users & downloading the user list.

4 months ago

richanda.wrighLevel 3

asked in General Product Q&A

Hello All, I am trying to get a KPI PQL statement for SAP field KDATE(Date) when the date in the field = 9999-12-31 Has anyone done PQl statements like this before? Thanks for your help in inadvance

4 months ago

jumbo.szkLevel 4

asked in General Product Q&A

How to use SAP ABAP data extractor custom table download option

Hi all, I have questions about SAP onetime data download ABAP program.Doese anybody give me the screenshot for selection screen sample? I mean, I'd like to know the syntax to write in selection scree, such as comma separating or if I need to use quotation to define table name.Is all data extracted if I push Execute extraction in background if I write selection condition to custom table data download field? (I mean, will data be downloaded wheateher O2C data + selected data or only selected data?) (In case I'm using O2C download template.) Regards,

4 months ago

Anonymous

asked in General Product Q&A

When I am inserting data into my activities I get "Execution error: ERROR: Column "event_time" is of type timestamp but expression is of type varchar" error but both columns are in timestamp only. Can you please suggest

I want to insert date-time data from one table to another but I am getting Execution error: ERROR: Column "event_time" is of type timestamp but expression is of type varchar error

4 months ago

saurabh.garg11Level 1

asked in General Product Q&A

How can I pass data from all the tables from a view on a button click to a webhook, if through YAML then how can I configure it in YAML?

4 months ago

harshini.s23Level 1

asked in General Product Q&A

What happened to the value calculator?

I am unable to find the Celonis value calculator anymore where we could input value and it would give us the potential benefits that can be uncovered. Has it been removed or am I doing something wrong?

4 months ago

Page 5 / 57

Badge winners

sayali.randh11has earned the badge Qualified to Build Action Flows
lyzanne.tr24has earned the badge Qualified to Deliver Business Value with Celonis
el.mostafa.janahhas earned the badge Celonis Certified Data Analyst
jumbo.szkhas earned the badge Masterclass in Implementation
makun.sharmhas earned the badge Masterclass in Implementation