Data Ingestion & Infrastructure

Where can I see the frequency of the activities in my event log? The process overview shows frequency per day. Or, how can I create a sheet which simply shows the frequency of events?

I am trying to create a dynamic drop down for case count and percentage case count but if in KPI formating i select percentage with 2 decimal then my count also coming with percenatge sign while i want to set case count with round no .how can i create dynamic formating?

Is it possible for admin right user to know who the task-mining-user is with userid? In my understanding, it is possible if the admin user ask the task-mining-user of their user id. Are there other ways to grasp the end-user?

Dear All, What should be level of access which analyst needs on Celonis while doing analysis on variants / process without need to change the data model. ? Reason i am asking is currently i am having access on views where i cannot do activity selection and add 6 types of filters but i can only do minimal analysis . Best regards - Shaif

Hi all, I am wondering if I could give default value in the component Throughput Time Search other than using Filter. Do you have any idea to set following criteria e.g. as below so that the analyst confirm the crop selection is applied to this component?

We tried retrieving data from SAP SF via SFTP and we were able to successfully connect to system. But when we run EMS loader we are receiving only 1 single record of file. Can any one help e out if we can enable PGP connection as pagination in SAP SF can be enabled in PGP encryption in SAP SF. Thanks in advance for help

Hi all, just wanted to know that is there any way to trace the overview of the space data pool/Workspace wise? Currently in Celonis Event collection there in data consumption section we can see data pool size but it is not in consolidated form and it will be a tedious task to add up all table size every single time we run the process data model. Any help will be much appreciated.

Is it possible to use the PU_STRING_AGG function as an input to the IN operator? Here's the snippet I'm trying to get to work: CASE WHEN LIPS.POSNR IN ( ' \\'' || PU_STRING_AGG(LIKP, LIPS.UECHA, '\\',\\'' ) || '\\'') THEN 'Y' ELSE NULL END  Not very clear as to how the PU_STRING_AGG handles the values - does it wrap the whole string with an additional set of start/end single quotes? If so - will the single quote delimiter along with a comma turn the string into a list of strings?

​

Good morning,‎I know the title is a bit convoluted, but I will provide additional information here.‎‎Essentially, we are trying to build a Bar Chart, with 1 Dimension and 1 KPI:Dimension: Purchasing Document Item Creation MonthKPI: % of Distinctly Named Suppliers that have at least 1 Purchasing Document Item with certain characteristics:‎This is what it currently looks like, without any filters.However, it does not effectively evaluate each supplier, each month.It evaluates each supplier across the entire data pool.Example:Supplier #1 Selected: ‎Great performance right? 100% Across the board! Now, if I look at the actual data, through some non-clustering formulas (no use of PU_SUM, PU_COUNT, etc.): ‎‎As you can see, this supplier actually had no Purchasing Document Items within the defined characteristics (Acknowledgement) for the months of November and December 2021, however, looking back at the graph:‎    ‎100% for both months.. ‎ To summarize, the formula is:Looking at each distinct

Hi everyone, My goal is to count on a daily basis how many cases were between two specific activities on that day. See the following example: So the result table needs to include every day in the timeframe (GENERATE_RANGE?). For each day I count all connections where day lies in between Start and End of the connection. Is this possible in Celonis? Thanks for any ideas, Patrick

Thanks to Celonis, it’s time to free up execution capacity and finally perform at your full potential. Therefore, we want to make sure you didn’t miss any of our Webinars. Here you can find the recordings of each of them: Create your first Action FlowAutomate your communication with Action FlowsKickstart your Action Flows with Use Case TemplatesUse Celonis data in Action Flows The next webinar, Automate in SAP with Action Flows, will take place on Thursday, December 16th,  2021 (4-5 pm CET).  Make sure you won’t miss it and register now! Best,The Celonis Team 

Hi, Lately, the loading time for editing the process data model took a lot of time. Especially today, I wanted to add an additional table in the data model but the page keeps on loading for about 30 minutes now. Is there a way around it? Need to complete asap the data model load.

Hi peers,I try to set up new components using CALC_THROUPUT. The two following components show different results. This is presumably caused because the OLAP tables have multiple lines with single CASE_KEY though the process pattern only occurs once (and it should since we use FIRST_OCCURENCE).  It won't change when we use Attribute selection overhead to limit to single KUNNR or give KUNNR in Dimension. Why OLAP returns several line items? Single KPI (Number)<KPI>CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['Create Delivery'], REMAP_TIMESTAMPS("_CEL_SD_ACTIVITIES"."EVENTTIME", DAYS)) OLAP (identical with single KPI)<KPI>CALC_THROUGHPUT(FIRST_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['Create Delivery'], REMAP_TIMESTAMPS("_CEL_SD_ACTIVITIES"."EVENTTIME", DAYS)) 

Good Morning : Preparing to install on perm Extractor , and the we would like to use Windows Server. The documentation refers to 2012 R2. This appears to be out of support , will 2016 R2 work as a data base?.

Can task templates be shared with multiple data pools?

Is there a way to change the email or name in the training platform?

Hello,I created a action engine skill and its going very well. Since I am using approver name as a connection for the process automation to send email. I dont want that the approver will be bombarded with multiple email if he/she has many invoices that needs action. Is there a way to remove or filter approver with the same name only regardless of the other columns he/she has?Thank you.Example:

Hi there, we are currently in the middle of the extraction of a production planning process from our SAP ECC. Now there is the need to extract only certain lines of the CDHDR and CDPOS. We know that a join is theoretically possible between AUFK.AUFNR and CDHDR/CDPOS.OBJECTID. To make it an exact join, though, one has to extract a substring of the OBJECTID, as the AUFNR is only a part of the OBJECTID. We tried this: SUBSTRING (CDHDR.OBJECTID,6,12) = AUFK.AUFNR. It returned an error, though. Does anybody know, where the problem is or is there a better solution to our problem? Happy for any help and best regards, Carl

Hello !I am trying to display the number of cases with a change activity on a monthly basis (ROUND_MONTH("_CEL_O2C_ACTIVITIES".EVENTTIME)).Without this column I obtain the right numbers but as soon as I display the column, numbers increase.To made sure I have a analysis filter on 2018-01. Without the month column I have:image1046404 13.6 KBWhen I put the column I have:image1066365 14.5 KBDoes that come from the PU function that does not handle well event time?The forumla for Change Rate Case isCOUNT(CASEWHEN PU_COUNT(VBAP,"_CEL_O2C_ACTIVITIES".ACTIVITY_EN,"_CEL_O2C_ACTIVITIES".ACTIVITY_EN IN (<%=changedFields%>)) > 0THEN 1.0ELSE NULLEND)Thank you in advanceEDITThe problem comes from using _CEL_O2C_ACTIVITIES.EVENTTIME. Using the sales order creation date gives me what I want.

Hi Team,I have a scenario in AR, I need to derive a new activity in AR, which should tell us the payment made by the customer is Over/Short/Exact Payment.Im checking in BSEG table, by taking BELNR and the corresponding WRBTR but not sure how to match the Invoice amount to paid amount.Suggest me a possible way to match the Invoice & Paid amount.ThanksChanti

Dear Colleagues,I am using below formula to calculate AVG processing time per vendor.It works generally OK, but it always calculates an average from the whole available set of data. For example if we have 3 years history of invoice posting and I only want to see an average for year 2020, applying time selection filter does not change the result of this formula, which keeps calculation for 2018-2020. Is there any way to keep this AVG dynamic and alligned with current selections?Thank you.PU_AVG(DOMAIN_TABLE(LFA1.NAME1||LFA1.SOURCESYSTEM),CASEWHEN MATCH_ACTIVITIES(NODE[WF step: Remove Qty block] )=1THEN CALC_THROUGHPUT(FIRST_OCCURRENCE[Invoice posted] TO LAST_OCCURRENCE[WF step: Remove Qty block],REMAP_TIMESTAMPS("_CEL_AP_ACTIVITIES".EVENTTIME, DAYS))ELSE CALC_THROUGHPUT(FIRST_OCCURRENCE[Invoice posted] TO LAST_OCCURRENCE[WF step: Price difference approval],REMAP_TIMESTAMPS("_CEL_AP_ACTIVITIES".EVENTTIME, DAYS))END)

Hello Community, Using Python API , how to create Authorizations ? Example of Create User user = User.create_new(Username, FirstName, LastName, foo@bar.com, Password123) How to Create Authorization with similar approach ? , documentation for that seems missing. Regards Vivek Oza

Dear Team,I would like to create the throughput time for two different destination activities.example, from sales order creation to delivery note creation (automated) is one and sales order creation to delivery note creation (manual) is another.i wanted to combine both the manual & automated in one throughput chartin our data model, we have considered above as two activity based on the user type.

I want to display the comments for the particular customer. My requirement is once i click the comments button description should display the pop up screen. Hope i get the solution here.Thanks in Advance.