Product Q&A

What would be the best approach to analyse accounting data for the Newcomb-Benford’s Law?

Hello, While framing some value which the Value Discovery App, I realized that the Inefficiency Augmented table are not getting actuallized, neither for O2C, nor for P2P on EU-1 cloud, although it works well on EU-3. While digging More, I realized that the Update Augmented Atribute Skill is not availble as shown in the following image. How could I fix the issue snd have the value discovery app working properly?  

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.

Here is the context of this error message (from EMS) when trying to connect to the DB:Extractor has been installed on client premises (Windows Server 2019) with OpenJDK11Target DB is running on Windows 2008 server. We're using Celonis to analyze processes prior to a system (legacy as you can see) migration.The same error message appears in the extractor logs obviously.Any insight on how to fix this problem ?

Í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?

Although the file has been successfully uploaded. Because of this I cannot proceed forward. Also the display shown in the video is much different from what I can see in my cloud. I am attaching relevant screenshots

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

Hi everyone, I would like to access a variable input/ dropdown component within an Analysis in the Studio using pycelonis 2.0.0. So far I get to the point where I can access the Analysis "ContentNode", but can't figure out how I can access those components. Alternative: Can someone tell me on how to access the Analysis variables? I can access the package variables but not the once from the Analysis. Thanks,Christian

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