- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months 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,425 Topics
3,374 Replies

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

1425 Topics

Most replies

Most views

Newest first

sooraj.edayaLevel 3

asked in General Product Q&A

HI Community,I have created some views on Celonis Studio and published. But these views are not visible on Apps. Do you know what could be the possible reasons for it?

HI Community, I have created some views on Celonis Studio and published. But these views are not visible on Apps. Do you know what could be the possible reasons for it?

1 year ago

yujuan.liu12Level 1

asked in General Product Q&A

About the definition (formula) for each KPI as below

For the following AP KPIs, is there anyone who knows the definition (formula) for each KPI. And in which Apps where can I find the KPIs.・Collection Effectiveness Index・Accounts Receivable Turnover Ratio・Average Days Delinquent・Days Sales Outstanding (DSO)

1 year ago

gina.diettLevel 3

asked in General Product Q&A

get_data_frame() returns following Error: Exception: Export failed.

I use PyCelonis to get Data as follows: analysis = celonis_manual.analyses.find()sheet = analysis.draft.sheets.find()component = sheet.components.find()df = component.get_data_frame()But sometimes get_data_frame() doesn't work and i get the following Error: Exception: Export failed. Status: {'id': 'aab0d447-a0d5-419d-b25d-36ee3d504b71', 'exportStatus': 'FAILED', 'created': 1702286071091, 'message': 'Encountered " "(" "( "" at line 1, column 10.\\nWas expecting one of:\\n ")" ...\\n "||" ...\\n ', 'exportType': 'PARQUET'} I dont understand why as the Tables do not seem different from the ones where it works. Im working in pycelonis 1.4.1. Any help would be greatly appreciated. Thank youGina

1 year ago

federico.sparaLevel 3

asked in General Product Q&A

Variable preview different from actual value

I've built a simple variable with static value. If I enter in the code editor, it shows a value (like 3.05, that is fine), but if I exit, it shows me NULL, and in the analysis it follows the NULL behaviour, creating lots of messes. I don't understand why it is happening, since if I try to fix it, it shows me the correct value.I can't replace it in the formula of the KPI, since I'm calculating a static QUANTILE value to be compared which every row of a table, if I put it directly in the formula it tells that I can't use aggregation function etc etc...

1 year ago

tamano.inoueLevel 2

asked in General Product Q&A

Does anyone know anything about Extract display value columns?

Does anyone know anything about Extract display value columns?They are displayed in General under Extractions in DataJob.

1 year ago

suvam.nayak12Level 3

asked in General Product Q&A

In marketplace , we are seeing Concur connector, but while installing it it not showing any transformation scripts and Data model. Any help?

1 year ago

julia.bauerLevel 5

asked in General Product Q&A

I'm saving data records sent via an AF with a skill and the module execute process automation skill. The module sends an error message once one field cannot be filled. It should fill it with null and then proceed with the flow. How do I manage this?

The rescheduled date is sometimes null and in some cases there is an entry, hence the whole module should not stop once the date is null.

1 year ago

simone.nardiLevel 3

asked in General Product Q&A

Converting from LONG VARBINARY to STRING

Good morning, I am looking for a way to convert a BLOB field (i.e. a long varbinary in vertica sql) into a string, in order to capture a hidden information. Is there a way to do this conversion? I am not finding anything in the documentation, except for the question in https://www.celopeers.com/s/question/0D50700000lQGtPCAW/converting-from-binary-to-string-in-ems?language=en_US . Thanks

1 year ago

julia.bauerLevel 5

asked in General Product Q&A

Is the process explorer customizable in such way that in addition to the number of activities per process step, the automation rate of each step will also be shown. Is this possible or has anyone tried to implement such a requirement?

1 year ago

abdul.hayeeLevel 2

asked in General Product Q&A

Display parallel processes in the Process Explorer Single event log

Hi, I am working on a university project. For that, I constructed event logs in such a way that the event logs contain some parallel processes. But Celonis is showing all parallel processes in a linear style. But I want to see all parallel processes in parallel style in Process Explorer. So, can you please help me know how can I modify my event logs or how can I visualize parallel process as parallel in the academic version of Celonis. If you recommend some video tutorials that will be more helpful.

1 year ago

jacob.visse14Level 2

asked in General Product Q&A

I am using the " target=_"blank" statement in a text button to open a new tab with a link to Celonis documentation. But it opens in the same tab as my analyses. How to solve this?

Below an example of the code I am usingFor detailed information go to Celonis info page:<a href="https://docs.celonis.com/en/process-ai.html"target=_"blank"> Process AI</a>

1 year ago

tobias.boehm12Level 3

asked in General Product Q&A

Can someone help with embedding views via variable?

Hello there,I am trying to embed a view by variable value. Using the explanation on (https://docs.celonis.com/en/views-variables.html) this is the current state. Here I have created the view-variable 'embed_variable' and two separate views with the keys 'embed-test-source' and 'embed-test-source-alternate'. If the value of 'embed_variable' is '1' I want to embed the 'embed-test-source' view just how I want to embed 'embed-test-source-alternate' when the value of the variabe is '2'. I tried to follow the example from Celonis metioned above, so I'm not too sure about what the errors mean. Has anyone experience using this method and can tell me where I went wrong? I would be very grateful.

1 year ago

weijing.shiLevel 2

asked in General Product Q&A

Is it possible to generate PDF from Views and send as attachment in email? We are able to generate such from analysis , but the visualization of analysis is limited e.g. cannot produce line chart with 2 dimensions (1 dimension by x asix and 1 b

1 year ago

ayushi.ade12Level 3

asked in General Product Q&A

Hi All,Need to apply filter while extracting the data to have rolling month/year data. For example the first day of extraction of data is 01/12/2022 to till now then after a month data should be extracted from 01/01/2023 to till now.

Tried applying the filter statement in one of the filters of table but it didn't support the sql query. Any guidance would be really helpful.

100

1 year ago

tushar.kondeLevel 3

asked in General Product Q&A

How can we send excel attachment from action flow since csv is not working in some region/country(e.g. Germany)?

In our use case we need to send the data into excel format we tried with csv but in some region csv files are not working and client requirement is they want data in excel file so please provide the solution on this

1 year ago

trevor.nixonLevel 3

asked in General Product Q&A

OLAP Table Conditional Formatting based on value of an in-row KPI

I have an OLAP table with a flag KPI (0 or 1) calculated at its end.How can I, or can I reference that KPI in a custom object to define a style rule to highlight rows where that flag is 1?

1 year ago

marina.de.caLevel 1

asked in General Product Q&A

Hi everyone!. I have a question. How is possible discriminate a process flow accordin to a specific hour?For example i would like to discriminate a process where a specific activities is done before the 9 a.am respect the other.Thanks

1 year ago

alexandra.strohLevel 1

asked in General Product Q&A

Hello, my name is Alexandra. I wanted to ask if it is possible to make the data model that is in the background visible. So that I can see which tables and keys are used. I am an analyst.

1 year ago

joyce.cardo12Level 4

asked in General Product Q&A

Hi, Everyone! I have another question regarding AF. How can I combine the POs by Sales Rep and send all of the PO’s related to that person in one table/email? I tried to create a text aggregator and applied variables, but it's not working..

1 year ago

kleber.cazot12Level 2

asked in General Product Q&A

Hello,I need to make a field (column) of a table clickable. How can I do that?Thanks

Hello, I need to make a field (column) of a table clickable. How can I do that? Thanks

1 year ago

david.teixeLevel 1

asked in General Product Q&A

In a View, how do you center the text inside a kpi? I want the "179" to be centered and not on the left as it currently is.Thank you in advance

1 year ago

simone.nardiLevel 3

asked in General Product Q&A

Good day,I am trying to use newly created attibutes on a record in Studio to define a new KPI, but it seems that the PQL editor for the KPI does not see the new attributes. Am I missing something?Thanks!

Good day, I am trying to use newly created attibutes on a record in Studio to define a new KPI, but it seems that the PQL editor for the KPI does not see the new attributes. Am I missing something? Thanks!

1 year ago

manish.srima11Level 2

asked in General Product Q&A

Is anyone know, how to configure KPI Parameters in Knowledge model KPI's and YAML code.?If yes can you please let me know the syntax in PQL.Thanks in advance..!

Is anyone know, how to configure KPI Parameters in Knowledge model KPI's and YAML code.? If yes can you please let me know the syntax in PQL. Thanks in advance..!

1 year ago

jack.everaLevel 3

asked in General Product Q&A

Is it possible to calculate the time taken between an activity and today's date?

1 year ago

bhupendra.singh.thakuLevel 3

asked in General Product Q&A

Why I am getting Error: No common table could be found in S4HANA starter kit although I am using Celonis standard transformation and model.

I am getting below error in Knowledge Model ->Records->Transaction Activities. Although I have joined both the tables BSEG and _CEL_AR_ACTIVITIES in data model, using key columns Join

1 year ago

Page 17 / 57

Badge winners

bruno.carva11has earned the badge Qualified to Write PQL Queries
tim.sandehas earned the badge Qualified to Build Action Flows
bruno.carva11has earned the badge Qualified to Build Action Flows
bruno.carva11has earned the badge Qualified to Build Views
bruno.carva11has earned the badge Qualified to Build Analyses

Show all badges

Terms & Conditions

Sign up

Already have an account? Login

Login with SSO

Celonaut Login Celonis ID Login

Login to the community

Login with SSO

Celonaut Login Celonis ID Login

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

ANY QUESTION?

Talk to an expert

FAQs

MORE CELONIS

Academy arrow_outward

Documentation arrow_outward

Support Center arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook