General Product Q&A

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.

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

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?

Hello All, I have been looking at the banner notifications feature, but it seems that :  no hyperlinks are possible, only URLs as text no formatting of the text is possible via HTML (e.g. bold text, line breaks etc.) Is there any workaround to that so we can publish interactive and visually appealing messages to the users? Thank you!

i cannot found fundamental process mining in business analysis what can i do

The starter kits usually have a Surface Inefficiencies section where there is a column called ‘impact.’ I would like to better understand the meaning of this column. The example bellow is from the order management starter kit and the tab touchless orders. Thanks,Julio 

while using replace function in celonis pql getting an error because string contains a comma in the value and replace function is considering it as a parameter in the function. is there a work around for it?

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

i failed rising star technical assessment attempt 2 time but fail both time then after 2 days i came back see there is not refill again then what i should do?

Hi I am trying to calculate the time elapsed since the occurrence of a particular activity and all subsequent activities in the case.For example, if there are 5 activities in a case, of which the activity 'Lodgement' is the second activity. I would like to calculate the time take between 'Lodgement' and the 3rd activity, 'Lodgement' and the 4th activity and 'Lodgement' and the 5th activity.Note:1.The number of activities per case is not a fixed number.2.The occurrence of 'Lodgement' activity is not fixed in the activity order. Any pointers on how this can be done in PQL is much appreciated.Many ThanksAshwin Hosbett

Hi All,I am trying to find out how long a case officer spent time on a case on a daily basis.For Example - If there are two officers - Alex and Rick, I would like to find out how much time Alex and Rick spent per case every day.Any pointers on how this can be done would be helpful.Many Thanks!RegardsAshwin H

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'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

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

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?