Product Q&A

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?

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";

Here is the example

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?

Hello everyone, could you tell me if there is a formula in PQL where I can get the top 1 activities of a document? Example, the Purchase Requisition, had several repetitive reworks, I would like to pick the top 1 rework.

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!

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

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?

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

I want to add a background color to my table component if the kpi value for a specific row is less than 10I’m aware of how we can achieve this in analysis sheets. Need help to do this in Knowledge Models and Views nowthank you

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

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.

Hello everyone,  Is there a function or possibility to combine four different columns with the same possible contents into a single dimension? These columns are dependent on other columns and only if the value in column A = X I want to read the value from column A2, otherwise not. I have inserted an example.Thank you very much! For example: Here i would like to build a column chart where the dimension is X (coming from A-D) and the KPI is a sum from column A2-D4 where a X was in A-B (everhting marked red) 

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 ?

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

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

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  

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?

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 

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 

Are there any use cases whereby Celonis was used before an orginisation implemented an ERP like SAP? In other words, how can an organisation use Celonis to prepare for SAP implementation?

Working Student (f/m/d) for Process MiningSiemens Healthineers We are #hiring 2 students interested in Process Mining and supporting in the development of the huge backlog of Process Mining use cases for Siemens Healthineers: Please apply here: Working Student (f/m/d) for Process Mining | Erlangen, Bayern, Germany | Siemens (siemens-healthineers.com) The Location is officially in Erlangen, but open to Home Office inside Germany. Feel free to contact me for any questions. Do you know anyone who might be interested? Thank you for forwarding and applying!

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!