- - Knowledge base overview
Product Updates

Welcome to the Celonis Community

3 months ago

Home
Community
Product Q&A

Product Q&A

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

3049 Topics

Most replies

Most views

Newest first

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

dilyar.iskan11Level 3

asked in Data Ingestion & Infrastructure

DATA INTEGRATION - DELTA EXTRACTIONS.

I want to extract a table "SRRELROLES" from SAP system. For this table, I have to use dynamic and private parameters on the column "UTCTIME" UTC Timestamp in Short Form (YYYYMMDDhhmmss). I get an error for delta extraction since the data type I use is date (I have tried integer and double but neither worked)and the data type of UTCTIME is float according to SQL vertica in Celonis and UTCTIME has data type DEC in the SAP system. My question is which datatype can I use for my dynamic and private parameters? Or how can I define a variable inside the FILTER STATMENT or DELTA FILTER STATMENT in order to get the max of the UTCTIME and use it for my delta extractions?

1 year ago

joyce.cardo12Level 4

asked in Process Improvement

I want to create a filter in PQL that gives me only the POS >90 by the end of the current month.

SELECT TO_DATE( TO_CHAR(ADD_MONTHS(CURRENT_DATE, 1), 'YYYY') || '-' || LPAD(TO_CHAR(EXTRACT(MONTH FROM ADD_MONTHS(CURRENT_DATE, 1)), 'FM00'), 2, '0') || '-' || '01', 'YYYY-MM-DD') AS FIRST_DAY,DATE '2023-12-01' - INTERVAL '1 DAY' AS END_OF_THE_MONTHFROM "CRM_VBAK";

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

patrik.patriLevel 2

asked in Data Ingestion & Infrastructure

Pycelonis to extract and pull data from analysis/datapool to external MySQL or similar

Hallo, as pycelonis states: Using this package you can programmatically interact with Analyses, Workspaces, Data Models, Data Pools and other Celonis objects. The package also allows pushing and pulling data to and from Data Pools and Data Models. I would like to programmmatically interact with celonis analysis (mainly) and extract the data for other purposes and to other sources. That means, the statement suggests to me the possibility to extract the data from Celonis into an external database like say MySQL. I dont find a supporting material on this in the documentation. Can someone shed a bit more light into the darkness here?

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

ravinkumar.panchLevel 2

asked in Process Intelligence Graph

I'm not able to see 'Objects and Events' under Data menu. This is required for OCPM.I'm using Celonis training cloud. How to resolve this?

I'm not able to see 'Objects and Events' under Data menu. This is required for OCPM. I'm using Celonis training cloud. How to resolve this?

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

kiarash.dibaLevel 2

asked in General Product Q&A

Hi All, I want to count the number of activity 'A' WHEN the user is 'automatic' and it happens after another occurrence of activity 'A' with user 'manual'. Note that I want to calculate the number of activities and not the cases that this happens.

1 year ago

raman.silot14Level 4

asked in Process Analysis

PQL in comparator (Custom Objects)

Hi By now I have implemented comparator in custom objects using static value But is it possible to use comparator dynamically by applying pql formula in it ?

1 year ago

stephan.herma12Level 2

asked in General Product Q&A

How to color code/group activities in Process Explorer used in Studio/Views

Hi,previously in process analytics I could manually group activities in the process explorer and designate a unique color. Is there a similiar function in Views (except of using different eventlogs which wouldnt make sense in my case) ? The "customs" option in the knowledge modell doesnt seem to be working with the process explorer. Thanks for your feedbackkind regardsStephan

1 year ago

joshua.asenhLevel 2

asked in General Product Q&A

Views input-box with type number still considered a string on Javascript side

Hello there, is it intended behavior/am I doing something wrong, that even with the type attribute for an input-box set to number, the variable will still be considered a string on javascript side once set to a value via the input box?This of course results in the + operator behaving differently when performing calculations with javascript (see the example in the picture). While obvious in this case, as other operators will dynamically cast to int or float just fine and the default values work as intended before being changed by the variable input, it took more time than I'm willing to admit for me to understand, that this was the reason my annotation lines would sometimes not show up for my histogram. Here the Yaml-code for the example:metadata: key: variable-input-test template: false name: Variable Input test allowAdvancedFilters: truevariables: - id: Value1 name: Value1 defaultValue: 1 type: NUMBER - id: Value2 name: Value2 defaultValue: 1 type: NUMBERla

1 year ago

raman.silot14Level 4

asked in Process Analysis

Inputs for action not visible

Hi I was trying to implement new functionality of connecting views directly with action flow Although, I cannot see the option of adding inputs in "Actions" menu of KM Is there any specific module to be added in action flow to enable this ? Please refer to the attached training video screenshot where we can see the option, but is not visible in training env

1 year ago

jumbo.szkLevel 4

asked in General Product Q&A

Is it able to keep conected activity information in BPMN export?

Hi all. I created BPMN diagram in one project and exported it in my local PC but it doesn't contain activity information. Is it able to export BPMN with activity information which BPMN box is tied with a activity?

1 year ago

tushar.kondeLevel 3

asked in General Product Q&A

can we store the email alert date for particular order when we are sending alerts from action flows and skills?

In our use case we are sending emails alerts to requisitioner in that we are sending them the emails and we are attaching the excel/csv file into that we want to store the date of email alerts somwhere in celonis and use that date to send escalation alert

1 year ago

jonas.schei12Level 3

asked in AI

PyCelonisPermissionError: You don't have permission to perform 'GET'

Hi all, I want to pulling data from a knowledge model through the following code ... space = celonis.apps.get_spaces().find('Default')package = space.get_packages().find('Knowledge Model Test')knowledge_model = package.get_knowledge_model('999-automation-rate-bw-download')content = knowledge_model.get_content() But I get the error "PyCelonisPermissionError: You don't have permission to perform 'GET' ", even I have set all possible permissions (for "Space" / "Package / "Analysis").Any ideas which permissions are missing. Unfortunately the article below does not help me here. Thanks in advance,Best,Jonas

130

1 year ago

.1463214Level 2

asked in Data Ingestion & Infrastructure

What is the meaning of this error ?

1 year ago

jens.rohde12Level 1

asked in General Product Q&A

Extraction Server: "Internal error" when changing connection prerequisites

Hi, we have an on-prem extraction server with a working uplink connection and working SAP/JDBC connections running.When we try adding a new DB connection, we receive this error message:"Connection test failed, please check the Data Connection's configuration and ensure that the system is running: Extractor responded with an internal error" This is hard to troubleshoot, since the service is definitely running and working. Any idea on what might have gone wrong here? I can rule out a port error, as I can force this one by changing the port of an existing DB-connection. Thanks for your help in advance!

1 year ago

sree.cLevel 4

asked in General Product Q&A

Hi Team, How to attach pdf and csv to a single mail using action flow?

1 year ago

teun.gilis11Level 3

asked in Process Improvement

Is it possible to use a dropdown menu when using Actions to trigger an Action Flow?

Hi all, With Automation Skills, it is possible to update an Augmented Attribute with a dropdown list using Actions. The action button triggers an Automation Skill which updates the Augmented Attribute. I would like to migrate this action from Automation Skills to Action Flows, but I'm unsure about how to include dropdown values in an Action Flow. Anyone that knows how to do this? Thanks,Teun

1 year ago

Page 28 / 122

Badge winners

hubertus.schmihas earned the badge Qualified to Create and Deliver Demos
svenja.winkl11has earned the badge Qualified to Deliver Business Value with Celonis
hubertus.schmihas earned the badge Qualified to Prove Celonis Value
surendra.alamhas earned the badge First Post
ardi.zulfahas earned the badge Qualified to Manage Change and Scale Adoption