Success Hub
Product Updates
Groups

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,457 Topics
3,459 Replies

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

1456 Topics

Most replies

Most views

Newest first

shane.proctLevel 3

asked in General Product Q&A

Is there a code-level search function for Spaces and Analyses?

My company is planning to update the codes used in the MARA.MSTAE and MARC.MMSTA fields. What I'm trying to figure out is where these fields are used in formulas and filters. I can look at the data models and see that we only use those tables in three specific data models. The knowledge model in one of those was pretty easy, because it has an internal search function. I tried to use the search bar inside of each package, but that appears to only do a surface level search of column titles and such. My question is this: is there a way to search the filters of each analysis/component and code within OLAP tables without opening/editing each analysis and table individually? To phrase it differently: a code-level search function within a space or analysis?

9 months ago

kandi.naiduLevel 4

asked in General Product Q&A

Can I create a pdf report using Action Flow there should be views dashboard should be pass as input.

Thanks, Kandi Ajith Naidu.

10 months ago

beau.melliLevel 1

asked in General Product Q&A

Hello, has anyone set up a connector to Intaact, Netsuite, or dynamics great plains? Also, does anyone know if Celonis even has connectors for these three ERP's? If you could let me know, and where to find this information, I would greatly appre

10 months ago

lukas.goder12Level 3

asked in General Product Q&A

Hi, how can I write the value of a KPI into a variable, to use the value in another Views component? Thanks!

310

10 months ago

ugandhar.konapLevel 3

asked in General Product Q&A

Hi, I'm working on new views, having some issues.

In analysis we can use component filter to filter by using saved formulas whereas in Views able to filter only by selecting attributes but not saved formulas. Even I have created filter in KM and tried using that filter for a component in Views getting error like PQL ErrorA PQL error is preventing this query from executing.KPI with name "Case_type_new" could not be found.

10 months ago

bennita.dutoi12Level 4

asked in General Product Q&A

How do I keep the denominator in my Calculation constant (so that it doesnt change when I filter on it for different dates)

KPI("cancelled_cases")*(KPI("cost_per_transaction"))The Cost per transaction should stay the same figure:Cost per transaction: KPI("total_operating_costs")/Global(KPI("case_count"))So the Case count above must stay the total amount of cases and not reduce if I filter for a shorter time. The Total operating cost is a constant figure.

10 months ago

guillermo.gost11Level 3

asked in General Product Q&A

Anybody there have experienced getting data from Bonita, Activiti or Camunda?

Do you recommend one in particular? Found issues to integrate? TIA!

10 months ago

andres.naran12Level 4

asked in General Product Q&A

Hi folks! Is it possible to create a table in a view that every time a user enters an input in that view, that input can be stored in a variable and this can be used to add new rows to this table inside the view?

10 months ago

sevde.aydin11Level 3

asked in General Product Q&A

Hello, I want to export my activities table as a csv file with Celonis EMS API and PyCelonis in MLWorkbench. I have some problems with this issue.

Firstly I wrote the following code: space = celonis.apps.get_spaces().find('Accounts Payable')package = space.get_packages().find('Accounts Payable Starter Kit')analysis = package.get_analyses().find('Process Cockpit Advanced')content = package.get_analysis(analysis.id).get_content()data_model_id = content.data_model_id I got this output from the code above: [2024-06-26 11:01:22,515] INFO: `get_analyses` returns analyses without content. To fetch the content for a specific analysis call`analysis.sync()` or use `package.get_analysis(analysis_id)` And then I run the following codes: sheets = content.draft.document.componentssheet = sheets.find('Activities') -It worked. components = sheet.componentscomponent = components.find("APTable")Finally, I got this error:---------------------------------------------------------------------------PyCelonisNotFou

650

10 months ago

phil.cookLevel 2

asked in General Product Q&A

What do the "dataSources" within YAML refer to?

I had removed ALL instances of KPI("3_days_") KPI("1_to_days_") and KPI("0_days_") from the view...but they still show up as if they exist in my Vendor LINK Scorecard table. name: Vendor LINK Scorecard options: density: compact resizeMode: expand allowDataExport: true dataSources: - id: 8e94d967-cd94-40a2-b167-34a913ae69fa pql: TABLE("contract_item_link"."LINKHDR - Vendor Org", PU_LAST("contract_item_link",LTRIM("contract_item_load"."YYSUPNR",'0'), ORDER BY "contract_item_load"."YYSUPNR"), PU_LAST("contract_item_link","contract_item_load"."NAME1", ORDER BY "contract_item_load"."YYSUPNR"), KPI("contract_item_score_link"), KPI("3_days"), KPI("3_days_"), KPI("1_to_2_days"), KPI("1_to_2_days_"

10 months ago

.1683757Level 3

asked in General Product Q&A

How to implement a Filter to filter Invoices with amount >, =, < certain value entered by user?

I want to create a filter for invoice amount where the user can select between (>, =, <) and be able to add/select certain invoice value. Example: amount > 1025 or amount >1000 Is that possible in the new view? Thank you

10 months ago

julia.bauerLevel 5

asked in General Product Q&A

How to add an augmented attributes (status of a data record to build a worklist - NEW + DONE) in new views?

Hello everyone, I'm currently building an action view for employees to use. It contains a table that should have interactive functionalities. In the 'old' views I have created a record identifier (if not existing beforehand), an augmented attribute for this identifier (STATUS) and then added this attribute to my table. Now, in this new view, adding an augmented attribute within a table is not possible anymore? How can I add the status so that I can build a NEW and OPEN tab for my employees to see what was already processed and which data records are still new? Any ideas or documentations on this? Thank you so much! BRJulia Bauer

450

10 months ago

abhishek.tando12Level 3

asked in General Product Q&A

I am getting error on my case explorer in views "Case Id should be of string data type." but I checked all case_ids in activities and cases table are in string only.

10 months ago

shane.proctLevel 3

asked in General Product Q&A

What does this data job error message mean?: Jobs in this schedule are on inactive team

One of my scheduled data jobs keeps skipping due to this message: "Jobs in this schedule are on inactive team". What does this mean? To my knowledge, there were no changes to the data job. This data job has successfully been running for months, but began failing on 06/05.

10 months ago

rebeca.padil12Level 3

asked in General Product Q&A

Action Flow - Screenshot of an Analysis as image in a mail body

HiI have a request to add the screenshot of a Celonis Analysis as an image in a mail Currently it is being sent as attached PDF, but the user would like to have a clear view of the report without having to open the attachment Is it possible? Thanks!

10 months ago

andreas.rauchLevel 2

asked in General Product Q&A

Why is my tableSchema not understood by Celonis Data Push API

i want to push data using the continuous-batch-processing/api using this function def push_new_chunk(self, dataPoolId, tablename, file_path, primaryKeys, table_schema, fallbackVarcharLength = None): api = self.get_jobs_api(dataPoolId) + "/items" payload = {'targetName': tablename, 'primaryKeys': primaryKeys ,'connectionId': self.connection_id, 'fallbackVarcharLength': fallbackVarcharLength ,'upsertStrategy':'UPSERT_WITH_NULLIFICATION', 'tableSchema':table_schema} headers = self.get_auth() file = {'file': open(file_path, 'rb')} return requests.post(url=api, params = payload, files=file, headers=headers) tableSchema is defined as per the celonis documentation here: e.g. thats how my tableSchema looks like in python before pushing: table_schema = { "columns": [ {"columnName": "CreatedAt", "columnType": "DATETIME", &quot

160

10 months ago

dimari.slabb11Level 2

asked in General Product Q&A

Showing where process exits straight through processing on a graph.

I need some help. I might be over complicating this, but I would like to see the following KPIs in one bar graph: Each KPI has one less "OR" as we move up in numbers, but this is the KPI for the last number: In other words this is the KPI and corresponding PQL code: KPI 1:KPI 1 - corresponding PQL code: KPI 13 (last KPI on the list): KPI 1 - corresponding PQL code:

10 months ago

girish.hemra11Level 2

asked in General Product Q&A

which SQL is used to build transformation scripts? is it possible to adjust template coding for predefined process? is it possible to join transparent and cluster tables (BKPF/BSEG, CDHDR, CDPOS)? how flexibly filter conditions for tables be applied?

10 months ago

peter.bodel11Level 2

asked in General Product Q&A

Hey everyone, do you guys know if it is possible to do a delta load for tables i want to retrieve on the ML Workbench using Pycelonis?

Background info: I have a data transformation script called "Preprocessing'. In that Script, some SQL operations are done. Afterwards, i retrieve the resulting tables in the ml workbench to execute statistical python operations. Then, the result is uploaded back to Celonis where another data trasnformation script called 'postprocessing' enriches the data for visualization. Currently, the python part takes 4 hours to execute as i execute levenhstein ratio for a very large dataset. So my idea is to use delta loads in order to reduce the amount of operations. Thanks for your help!

10 months ago

shane.proctLevel 3

asked in General Product Q&A

Action Flows/'Microsoft 365 Excel, Search Workbooks' module

I see where I can have the module look for a file in my OneDrive, or a Teams/Sharepoint location. How do I route the module to a network drive?

10 months ago

koert.kritz11Level 3

asked in General Product Q&A

Hi all, I have an issue with the Case explorer in the new views. It is currently showing how long ago the activities happened for a selected case. I would like to configure it to show the time between activities. Is this possible?

10 months ago

sevde.aydin11Level 3

asked in General Product Q&A

Is there a technical way to export backups of processes/data model in Celonis so that we can restore them when necessary?

150

10 months ago

harini.p26Level 2

asked in General Product Q&A

How to create an embedded view in the new views

140

10 months ago

weijing.shiLevel 2

asked in General Product Q&A

new studio: use dimension in coloring?

one of the main inconvenience for me in the new studio is that it does not allow me to use color with dimension in the chart. For example, earlier it is very easy to plot e.g. KPI xxx in the time series chart and use e.g. country dimension to color the KPI . Now i do not see this option to use dimension in coloring. any advise?

110

10 months ago

herique.sarmeLevel 3

asked in General Product Q&A

Is there a way to update the Python notebook being used within MLWB? I have it on 3.8.6, but I require it to be at least 3.9 or higher

I want to use certain ML libraries that require python 3.9 or higher to work properly, but my MLWB is on 3.8.6, is there a way to update it? If so, how?

10 months ago

Page 8 / 59

Badge winners

erick.matoshas earned the badge Qualified to Manage Change and Scale Adoption
yuri.fujimhas earned the badge Qualified to Manage Change and Scale Adoption
samer.odehhas earned the badge Value Realization Expert
samer.odehhas earned the badge Qualified to Manage Implementation Projects
zayneb.alsum11has earned the badge Value Realization Expert

VIEW ALL

Community Code of Conduct

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 Portal arrow_outward

Partner Portal arrow_outward

Marketplace arrow_outward

CHECK US IN

YouTube

Instagram

Facebook