Product Q&A

trying to see how to improve this query and what are the high run time and what to change to improve the run time. QUERY PLAN Access Path:+-JOIN HASH [RightOuter] [Cost: 52M, Rows: 6M] (PATH ID: 1) Outer (RESEGMENT)| Join Cond: (vbap.VBELN = VBRP.AUBEL) AND (vbap.POSNR = VBRP.AUPOS)| Join Filter: (VBRP.AUBEL <> '') AND (VBRP.AUPOS <> '000000') AND (VBRK.VBTYP = 'M')| Execute on: All Nodes| +-- Outer -> STORAGE ACCESS for vbap [Cost: 708K, Rows: 380M] (PATH ID: 2)| | Projection: 8e9add16-f209-4968-8e45-d1442c21cccb_cb2d42c8-e4fe-422e-8ac2-cf82c740f17c.VBAP_super| | Materialize: vbap.VBELN, vbap.POSNR, vbap.YYBOFLAG| | Execute on: All Nodes| +-- Inner -> JOIN HASH [LeftOuter] [Cost: 34M, Rows: 6M] (PATH ID: 3) Outer (RESEGMENT)(LOCAL ROUND ROBIN) Inner (RESEGMENT)| | Join Cond: (vbak.VBELN = VBRP.AUBEL)| | Join Filter: (VBRP.AUBEL <> '') AND (VBRK.VBTYP = 'M')| | Materialize at Input: VBRP.MANDT, VBRP.VBELN, VBRP.POSNR, VBRP

Hi guys! Is there any way to reload only updated data inside the process data model? I mean I need only the updated data supplied but the process data model always makes a full reload, deletes the old data, and leaves only the new one.

Hi, all.  I need to know how works the pql.PQLColumn() function of Python for Celonis. Does anybody knows where is the technical documentation?  I've tried https://celonis.github.io/pycelonis/1.7.6/ , and docs.celonis.com but is not enough. In this case I need to know how to use the format argument. Thanks!   PD.I've found only this short info when hovering over the function in the VS Code editor (class) PQLColumn(query: str = None, name: str = "Unnamed column", format: str = None, sorting_index: str | int = None, sorting_direction: str = None, not_included: bool = False) A PQL Column dictionary that can be added to a PQL query statement. Behaves like dict. Corresponds to Dimension and KPI in Celonis.Args:    query: The PQL query of the column (KPI or Dimension).    name: The name of te column.    format: The formatting of the column.    sorting_index: The sorting index of the column in a table (starts at 0).    sorting_direction: The sorting direction. One of [ASC, D

--Business Miner-- Does anyone know where can I find the Process Workspace needed for setup this new feature of Celonis? Thank you!

I was having Analyst access but yesterday it was changed to member is there any way to find out who has changed my access permissions, I know someone from the admin only must have change but want to figure it out in the system, is there any user log ?

Hi all, I currently have the following challenge. My source table unfortunately does not have a timestamp, but has a column with the date and a column with the time. Now I would like to retrieve in my Delta Filter Statement the data that has been added or that has changed in the last 15 minutes. How can I write this in the delta filter statement?  Thank you and best regardsSarina

Hi all, I have an issue with the way that the data in the CDPOS table is stored in S4/HANA.  The issue occurs when an event triggers multiple follow-on events in SAP. For example, changing the company code (BUKRS) on an invoice will update the country code automatically (LAND1) at the same time. The user has only performed one change, but two are reflected in the CDPOS table with the same date, time, change number etc.  When creating the activity in the transformation, I wish to capture the first activity that the user has performed, not the follow-on activity. Is there a way to detect which CDPOS entry is the first activity? Example of CDPOS entry CHNGENR FNAME DATE USER000001 BUKRS 01-01-23 12:00 John Smith000001 LAND1 01-01-23 12:00 John Smith Cheers,Michael

Hi Recently I started learning about Celonis tool .Already i gone through the training tracks but still i didn't get an idea and clarification how and where to we will use this tool. Can anyone help me to find the solution.

Hi,I am using KPI Bowler to view distribution of a KPI over months. I am interested in viewing the aggregated data for all the available months.I could see that there is limit for number of rows to be displayed using "limit". But, i would like to check if there is any option to change the no. of columns(or months in this aspect). Please help me in understanding how the values are shown for first three months in my data model.Thank you.FYI: @reenu.josep12​ 

I am getting error while creating my workspace. Error- U r not a part of the team. I am an individual wanting to learn so registered with my personal id

Hi everyone, I have an OLAP table with columns like case number and different case attributes.I need to embed a hyper link on case number column that should take me to the Salesforce portal directly from this celonis dashboard. But I couldn't find any way to include such link. Is it possible to ember a hyper link in OLAP table?If not, what are the different options available? Thanks.

Cannot create a new data model. Loading circuit does not end, although the Internet works very well.

Need to do in PQL, not in backend SQL

ADD_DAYS(KPI(BLINE_DATE),KPI(CATEGORY_VENDOR_TERMS_DAYS)) where KPI(CATEGORY_VENDOR_TERMS_DAYS) = GREATEST(KPI(INVOICE_TERMS_DAYS),KPI(REG_VENDOR_TERM_DAYS)). The output of above KPIs is days only in INT value. Not sure why this error is showing up.

I get the following error while trying to "Export Data (XLSX)" from an OLAP Table: "Failed! (Syntax error near < after reading () at line 2" The Analysis settings allow excel and csv export of analysis components "Export Cases (XLSX)" works fine

Is there a way to extract the data from OLAP table which includes color formatting into Excel?

can we create dependency between action flow and Data model/Data Job successful run. This is to make sure that if the data model did not load or the related data job ran in to some error then the action flow also does not run on that schedule.

Hello everyone. I am trying to create an action flow that send a message one on one, creating a chat.   However, when I run the action flow it gives me the following error:  [400] Exception has been thrown by the target of an invocation. Does anyone Know how to solve it or what is causing it ?

The premise is in regards to the process explorer and its behavior when applying different levels of filters:applying process-related filters (flows through, select cases going from A to B) everything works as expected.Applying attribute selections on an activity level, i.e. selecting all activities performed by a single department, process explorer returns all cases where at least one activity within that case abides by the selected filter.Thus it appears that the behavior of the process explorer is as follows:First find all activities that meet the defined conditionSelect all cases that belong to those activitiesvisualize all activities for those cases in the process explorer without filtering the activities that do not meet the criteria. What makes this matter more complex is the following:Standard Process Explorer KPIs (case count, activity count) are calculated based on the latter conditions. So all information of the case and all activities regardless of activity attribute condit

Hi everyone, We are having some problems with the load of data chunks, sometimes its gets too longer to load a single chunk, in the process many times it stops at any point of the execution, its freeze for one hour or more and after continue. Please if someone had face this problem could you tell us what we can do to inprove this stops of execution. Many thanks. Best regards.

Hi I am looking into a product portfolio analysis based on SAP OTC data and would like some input and inspiration related to Celonis use cases. Is the SAP table, VBAP.ARKTX, the correct one to focus on for product information?

I am struggling with the implementation of a Multi-Event Log with O2C and P2P processes. After building the data models and succefully loading it, I am not getting the _CEL_MERGED_ACTIVITIES table generated. How could I do to fix the issue?

Does anyone have a full list of Analysis (Process Analytics) Edit mode keyboard shortcuts? Can you share please? Cannot find it anywhere in the documentation E - enable edit mode Shift - toggle edit mode 1 - jump to sheet 1 etc.

What the max size of number of character that can be extracted in table.column of type Text in celonis.