- - Knowledge base overview
Product Updates
Groups

Welcome to the Celonis Community

5 months ago

Home
Community
Product Q&A

Product Q&A

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

3103 Topics

Most replies

Most views

Newest first

andre.maerk11Level 1

asked in Data Ingestion & Infrastructure

Hi Guys, I am trying to calculate the time between two activities. But the second activity is not unique.

For example: The time between activity A-1 and activity LIKE A. Activity LIKE B can be A-2, A-3, ..., A-n. I always want the activity that is closest to activity A. Between A and B can be other activities. thanks for helping

3 years ago

franziska.sch√§Level 2

asked in General Product Q&A

Format Field vs. Format Function

Why is the format field in the pql-editor offering more options in formatting the output than the FORMAT() function? E.g. I can enter in the format field in the pql-editor the format '%d.%m.%y' without any occuring errors but not in the format function while converting a date to a string.

3 years ago

.14600111679Level 2

asked in Entry Products (Celonis Free Plan & TryCelonis)

Kann man CO2 Werte anzeigen lassen. Ich möchte eine Excel Datei mit Aktivitäten und deren CO2 Werte hochladen, doch bislang habe ich keine Lösung dafür gefunden?

3 years ago

.14600103620Level 2

asked in General Product Q&A

Hello Everyone,I am trying find the duplicate values in one of my field but could not able to write the code for it. I have tried with Count(Distinct) > 1 with Case when statement however I'm not getting the output for it.

In the below table I am checking for duplicate values in Name column. I need the count of duplicate values for example Name ABC has twice, so the out put should be 2. Could you please help me with it. OUTPUT:

3 years ago

sanchit.khann15Level 3

asked in General Product Q&A

Converting from BINARY to STRING in EMS?

Converting from BINARY to STRING is available directly on On-Prem system.But the same is not available on EMS or I am missing out on the feature.Can you please suggest a good way to CONVERT BINARY to STRING. I do not want to CAST AS STRING as that doesn't help. I need to CONVERT BINARY to STRING

3 years ago

sanchit.khann15Level 3

asked in General Product Q&A

Create and store a Sequence in a Table

We have a functionality where we need to create a sequence from 0 with increment of 1 and going up to a maximum value (count of a table).We are using a dynamic variable 'maxi' that take the max count of a table and stores this max value.Next we are creating a SEQUENCE between 0 and maximum value that we obtained in the previous step.Query we are using is - CREATE SEQUENCE SERIES increment by 1 minvalue 0 maxvalue <%=maxi%> start with 0 The problem is: We need to store this sequence in a table and then use that table to do a CROSS JOIN with another query. We are not able to develop a correct syntax to store this sequence in a table. We would need your help in developing the correct queries to:Create a table that stores a sequence from 0 to a max value (say 100), andCreate a correct CROSS JOIN reference with another query

3 years ago

.146003818Level 2

asked in General Product Q&A

How do I upload an html file to an analysis, using pycelonis?

3 years ago

mayank.padhi11Level 3

asked in General Product Q&A

There will be a change in behavior of Case-When in PQL from this February. Will it have any effect in the transformations in Event Collection?

3 years ago

thomas.spuraLevel 1

asked in General Product Q&A

Workflow for unlocking user accounts with the "User locking policy"

We are using the "User locking policy" to clean up not required accounts in our environment, so that those users, which did not use Celonis in a specific amount of time are locked. The issue is now with the unlocking of the users:When a user asks to be unlocked again, the user must login again at the same day again, and if not, the user is locked again at the next day. This happens quite frequently and the user needs to ask again to be unlocked. Is it possible to change this workflow to e.g.lock the user again after a defined number of days? Orsent the user an unlocking mail, which is valid for a week, where the user can unlock again? How are others using the "User locking policy" and what is your usual workflow on how to handle this issue?

3 years ago

cayetano.romerLevel 2

asked in General Product Q&A

Would it be possible to change the default colour of the Process Explorer and Variant Explorer without the need to create new KPIs?

3 years ago

dinesh.reddy.alimiLevel 1

asked in General Product Q&A

Our jobs are running on SSMS. So we are planning to trigger Data model on Celonis after the job is completed using a shell script. I would Like to know if this is possible? Or if there is any other way to trigger the Data model after our job is done?

3 years ago

EBrozioLevel 2

posted in General Product Q&A

Ready to seize unlimited opportunities?

Ready to seize unlimited opportunities? Visit the EMS Store from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners. Visit the EMS Store or find your team. Recently Added: Koerber Digital Obsoletely:An inventory management app that enables you to reduce the risk of having obsolete parts in your installed Assets reduces your mean time to repair and enables you to build a stock of the right spare parts at the right time when the costs are the lowest. Aptivio Buyer Intent AIOur Buyer Intent AI platform is built to drive and support action in real-time, fuel sales pipeline growth, and produce revenue outcomes. It’s an all-in-one AI-powered package that empowers digital sellers, provides opportunity discovery and blind spot coverage, predicts customer buying stage at every level, leverages existing networks, and monitors and detects early risks to allow revenue tea

3 years ago

david.caldeLevel 1

asked in General Product Q&A

Does Celonis have a connector for Microsoft Nav 2018

3 years ago

lisa.thomaLevel 1

asked in General Product Q&A

Has anyone worked on Workday to Celonis integration ?

3 years ago

sasa.redze12Level 5

asked in General Product Q&A

[pycelonis] How can push data to analysis?

I'd like to change the query of an analysis and upload the analysis. The documentation notebooks show how to extract the queries but not how to change them or upload them. Is there a way to change the analysis object directly or do you use the backup_content method for this. I find the working with the extracted json files a hassle since they are very nested and use the same keys. I've tried finding the components and their "path" recursively but that didn't work as desired. I haven't tried importing it with pandas. Any tips here are appreciated. For manipulating the analysis directly, I imagined something like this:analysis.draft.components["component_name"].queries = myquery But that didn't work. Also I found some references to older notebooks "https://python.celonis.cloud/docs/pycelonis/en/latest/notebooks/99_Use_Case_Copy_Analysis.html 50" (https://community.celonis.com/t/pycelonis-script-merge-analysis-sheet-from-two-different-

3 years ago

.1460093504Level 1

asked in Process Management

Interface: Celonis & Business Process Management Tool

How to deal with the interface between celonis and a business process management tool that serves to manage the process landscpae of a company? Does anybody have experience or best practices?

150

3 years ago

attila.cserv11Level 3

asked in General Product Q&A

Looking for in-depth technical/IT-security info for the call of an API-extractor built in Extractor Builder

Hello Team,we have built an API-extractor in the EMS Extractor Builder in order to get data from an on-prem system. Calling the on-prem API has been tested via PostMan (within the enterprise network), and works fine. But when calling the API from the EMS, we faced connection issue, due to the company IT security policies and measures (firewall blocks the external call).Now I am seeking for a very detailed in-depth tech info on how the API-call proceeds step-by-step in order to design and approve the necessary IT security changes.There is a good call/pipeline diagram for the database extractors in the Online Help: "help/display/CIBC/Pipeline+End+to+End+Overview", but nothing similar for an API extractor built in Extractor Builder.Any ideas are welcome, BR, Attila

3 years ago

zahra.sadeg11Level 2

asked in General Product Q&A

How can I generate a log from an existing process (Action engine process), that contains information such as which module, with what variables and values, in what time/duration has been executed?

3 years ago

.14600102854Level 1

asked in General Product Q&A

I am aware that there are around 100000 python packages on celonis platform. But I would like to know if we can install other packages if needed.

3 years ago

florian.mrkviLevel 4

asked in General Product Q&A

Where do I find the settings for the thousand seperator and decimal seperator?

In Celonis 4.6 (On Premise) I was able to set the seperators for thousand and decimals in my profile. I can't find those settings in the EMS. Can those still be set globally? Please see screenshot of the former options in the user profile:

3 years ago

janpeter.van.dLevel 8

asked in General Product Q&A

Extract Team data (users and APC usage) via PyCelonis

Hi all, We are looking for a way to automatically obtain data from teams regarding the number of active users and APC used. Via PyCelonis would be ideally, but unfortunately we didn't find it implemented. Has somebody any idea how to do this? Kind regards,Jan-peter

3 years ago

.146004175Level 3

asked in General Product Q&A

Filtering by date

While creating a sheet in Celonis studio(free plan), is it possible to filter cases based on when they start/end? When I try to filter by time range, it gives cases which are active in that range, but not necessarily entirely contained in the range.

3 years ago

sivakumar.sivap14Level 3

asked in General Product Q&A

UiPath Integration with Celonis

Hi Guys, if someone had built a action flow to trigger a RPA BOT from celonis to Uipath by providing the input arguments then please share the documents/suggestions on that.

3 years ago

.14600103498Level 2

asked in General Product Q&A

Is there a way to add an interactive column in an OLAP table, so that the user can take notes, or mark the rows in any way?

The purpose is for the user to add tags in a table, marking a row as "done" or "pending" and so on.

3 years ago

Anonymous

asked in General Product Q&A

General advice dealing with CASE WHEN behavior change (pycelonis)

Hi there, I am wondering how to approach the behavioural change to the Case When PQL operator best. I came up with 2 options and would like to know how others are approaching this. Option 1:Export a technical document for each Analysis in each Workspace. Then for each documentation search for the Case When operator, then edit the analysis in process analytics. Out of curiosity, is it possible to generate the technical documentation with pycelonis? Option 2:Exporting each analysis with the backup_content method, "changing the exported json file" and then use rebuild_content_from_backup(). Changing the export json file is another issue for me. The dicionaries are very nested and the structure (so far) irregular to me. Besides the json package and pandas are there other ways of importing the json files?Oh, I am exporting the files in order to rebuild the analysis later on. Would there be a more direct way of changing the data, one without the export? I just started with pycelo

3 years ago

Page 85 / 125

Badge winners

niels.holzhas earned the badge Solution Creation Expert
niels.holzhas earned the badge Qualified to Get Data Into Celonis
sharon.josep13has earned the badge First Post
parvathi.choudhas earned the badge Celonis Certified Data Engineer
anna.temel12has earned the badge Qualified to Deliver Business Value with Celonis