Product Q&A

Hi, I'm working on a case where we're analyzing activity time by users, by leveraging source - target. Looking at the simplified example below, I want to show that John has been working for 1 hr while Paul worked for 4.5 hrs. This works fine, however I'd also like to show the number of activities they have performed in the same table. As John only has one SOURCE activity (Activity 1, as Activity 2 is the last activity of the case and is therefore not connected to a TARGET activity), it appears if he only performed 1 task while Paul performed 2.The intended output is as shown below, with SOURCE(Name) as dimensionIs it possible to adjust the SOURCE config to include Activity 4 in Johns activity count? Or is there any other approach to get this done? Note that the actual throughput time calculation is rather complex (taking various attributes like user activity type into account), so SOURCE/TARGET seems to be the only way to calculate the right duration. Thanks in advance!

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

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

HELLO, CAN YOU HELP WITH THIS ERROR: The load failed: Load failed. Error message: Error joining table ["OE_ORDER_LINES_ALL"] with table ["HR_ALL_ORGANIZATION_UNITS"]. The data type [FLOAT] of column ["OE_ORDER_LINES_ALL"."ORG_ID"] does not match the data type [INT] of column ["HR_ALL_ORGANIZATION_UNITS"."ORGANIZATION_ID"]. I HAVE ALREADY PARAMETRIZED THE COLUMNS AS FLOAT IN ALL EXTRACTIONS BUT THEY STILL HAVE AN ERROR

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

Hello; I get the error message "Extraneous ''' "when I try to write the following PQL-Query in Views. KPI("REPEATED_CASE_COUNT_SELECTED", VARIABLE('Scan Invoice', 'Send PO Auto (Jaggaer)')) Does anyone recognize what the problem is here?

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 published & 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.

if so, do I need to make this change in all Filters?  Thank you BRAna

I am using the new Studio views and I can't find a way to pick any non-predefined colors. I only see the those options in the screenshot: 

I'm getting "undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES_AUGMENTED_FRAMED_VALUE cannot be found." Error in the Procurement Starter Kit I have added INEFFECIENCIES as well kindly help

Is it possible to update package dependencies automatically (via pycelonis, action flows...)? My base knowledge model is extended in multiple different packages and I would like to automatically update all extension KMs.

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.

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!

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

Hi Everyone We are looking into the use of Celonis for SAP SuccessFactors, is this possible and do we have any connectors available for the use case? Would also like to know what the typical event log would log like for the following modules if that is possible:EC (Employee Central)On/Off boardingSuccession planningRecruitment Thanks in advance! 

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: 

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?

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!

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?

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?

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

How to create an embedded view in the new views

Is there any way to somehow connect one filter with one specific process explorer instead of filtering both simultaneously?Was trying with the YAML editor, but with no success.

System: SAP S4/HANAApp Name: Accounts receivable Starter Kit Section : Value Discovery App  undefined [id:table-380082fa-c77c-4d37-9710-9408474b11d1]: Table could not be found. Table with name INEFFICIENCIES cannot be found.