General Product Q&A

If I may suggest for your previous question, there are tools that calculate the sustainability impact of operations across the business. A REST API connection can bring in that data for the processes and the same can be ingested in Celonis. Thanks.

Ín the documentation for the settings of such components it states in point 5 of the Throughput Time Search section that you can select the activity node and it refers to the selection of the Background Options which unfortunately does not offer the functionality? For the Variant Explorer there is a selection for the process nodes where you can set a custom dimension. Is this also possible for the Throughput Time Search Component or is there a workaround?

Hi All,I need some PQL coding help. I want to get a flat (or mostly flat) averge line for a 90 day period, but am not quite sure what I am missing. output table format:[created date] [id count] [90 day avg of id count] 90 day Avg (PQL):PU_COUNT(DOMAIN_TABLE("Account"."AccountNumber"), "Account"."Id", (CASE WHEN ROUND_DAY("Account"."CreatedDate") BETWEEN ROUND_DAY(TODAY()) AND ROUND_DAY(ADD_DAYS ( ROUND_DAY(TODAY()), -90)) THEN 1.0 ELSE 0.0 END) = 1) /90 Any suggestions on what to adjust?Thank you

Like the title says, I'm trying to filter a BSEG extraction as follows: (KOART = 'K' OR BUZID = 'Z' OR EBELN IS NOT NULL) AND (AUGDT >= <%=startDate%> OR AUGDT IS NULL) In English:One or more of the following 3 must be true:Account Type (KOART) = 'K'Line ID (BUZID) = 'Z'PO Number (EBELN) IS NOT NULLAND, One of the following 2 must be true:Clearing Date (AUGDT)>= 2021.01.01 (startDate parameter)Clearing Date (AUGDT) IS NULL Screenshot: However, when looking at the data, I'm not getting any cases where Clearing Date (AUGDT) is nullWhereas, in a previous extraction that omitted AUGDT as a filter field, we have 50K+ Cases with a NULL AUGDT Field, and adhering to the other Filtering Conditions: Therefore I can only assume that there is something wrong with the way that the filtering works.....that OR should always include cases with a NULL AUGDT. Not being able to use AUGDT as a filter is causing me to have to extract a gigantic amount of

We have a use case where we want to read the content of attachment and find some pattern. If the pattern is there then we want to extract this data in to some table using action flow. Is there any action flow module which can read the content of pdf/word.We want to use the Salesforce action flow module to download an attachment. Next action is to read this data find pattern and then put the data in to some table in celonis ems.

We are installing a Celonis extrator on a internal network and firewall rules must be configured in order to reach the EMS. Address "p-s-business-process-management-ciussse-chus-c4c.us-1.celonis.cloud" on port 443 has been opened as mentionned in the Celonis doc but it looks like authentication also tries to access https://id.celonis.cloud.Can you please provide the precise rules that need to be opened (from Extractor to EMS)? Thank you,Frédérick

Hi All, is there anyone having documentation for MS Dynamics on-premise? thanks

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

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

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 ?

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.