Product Q&A

Can we connect our locally installed SQL express under data model ? If yes, please help with detailed steps 

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, I am getting a run time error creating a table and I am wondering if this concerns only the editor or also a scheduled transformation job?  Kind regards,Sasa  

How to get the connection details used by the extraction. We have the below scenario. There are numerous connections being established with different sources, and some are duplicated connections were created depending on the need of different credentials with different of permissions of a particular source. Now the permissions have been sorted by the DBA, need to clear out Data Connections which are no longer in use. Stating the IBC is being treated a PROD and any fail schedule will be treated as a downtime needed to identify the connections which are in used by the current extraction process.

Hi Team, I need to create some dashboard which shows the value added by Celonis in the organization based on Procure to Pay data. Do you have template/analysis which should help the organization to understand the value addition from Celonis. This will help to get the idea about what I can implement and show it to management. Thanks, Aakash

Hello Team, Im downloading the Process Flow from the Process Explorer as a PNG Output. Unfortunately the left most part of my PNG output is getting truncated. Are there any settings whereing I can specify the width, so that the PNG download is not getting truncated. Attached is the leftmost part of my process flow which shows the TP time as 81 Minutes. But in the PNG download, it shows only the Connection line with only minutes without 81. Kindly advice. Warm Regards, Jayanta Borkakoti

How could be a filter realised with the following condition: Activity_1 was performed by Division A and a following change Activity was performed by Division B We started with: FILTER (ACTIVITIES.ACTIVITY = Activity_1 AND ACTIVITIES.DIVISION = Division A) AND (ACTIVITIES.ACTIVITY LIKE %Change% AND ACTIVITIES.DIVISION = Division B); Which resulted in a empty OLAP-Table. Does anyone have an idea how to realise this filter?

Hi all, Im looking for a way to use variables to restrict the standard component " Throughput Time Search". As an example: I want the standard component to show me the average lead time of the process steps C-F. I have tried a filter on the component and used the following code: (CALC_THROUGHPUT(FIRST_OCCURRENCE[<%=dlz_start%>] TO LAST_OCCURRENCE[<%=dlz_end%>], REMAP_TIMESTAMPS(WFMT_EVENTS.TIMESTAMP, DAYS))) Unfortunately the filter does not change anything. But I do not get an error message either. Is my code wrong or does the standard component not provide this possibility? Thanks for your help!

Dear community, I have created my own eventlog from sap (field names are the same as in celonis eventlogs) and imported it to default analysis. I do not have problems with process explorer nor with process variants. However when I open Process Overview I can see some happy path but with 0 cases: Bildschirmfoto 2020-09-27 um 16.55.4725101336 249 KB Througput times and activities are displayed correctly. What could be possible cause for this strange behavior. Greetings, Ula Jessen

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

Hi Community, Im currently building a Map in Celonis that shows the number of events per Location or Country. The calculated KPI uses a regular COUNT Function and is shown perfectly fine on the component. Now I want to apply coloring threshholds according to the data shown on the Map. The highest thresshold is supposed to be the maximum the KPI on the Map. Lets say the marker Germany has the highest number for the calculated KPI, e.g. 1000. Then the thresshold for red should be 1000, 800 for orange and 600 for yellow. Sounds easy, right? Well, it isnt. Although you can generally use functions to calculate the threshholds, you cant accomplish this behaviour in a consistent way: Wed need to manually aggregrate the KPI towards the Location, then take the MAXThe way do determine the MAX per Location would be to use MAX and a PU-Function inside (with a Domain Table for the Location).This works if youre not applying any selections. As soon as you filter your dataset, that function will no

Hi all, I want to compare/concat a string (e.g. SupplierName) with a date/day. Target: Are there days where I have used more than 5 suppliers. My formula suggestion: FILTER COUNT(DISTINCT SupplierName||Date)>5; Nay ideas? Many thx and br Daniel

Hi Community, I am trying to make ranking olap table. As rank, I use INDEX_ORDER() with desc tentatively, and it returns sequential numbers to identical values. Id like rank like DBMSss rank function like in MSSQLServer or Orale that returns identital ranks to identical values. image865452 16.6 KB Is there any ways to do above? Thank you,

Hi everyone, I have a table with activites that are created at the purchase order item level. Each purchase order have a supplier. I would like to see what ratio of activites is deleted for given supplier. But not at the line item level but at the purchase order level. I work with EKKO , EKPO Tables (EBELN, EBELP) and have both EBELN (Header) and EBELP (Position) in my activites table for example:: PO Nr Position Supplier Activity PO Deleted 101 10 A X 101 20 A X 101 30 A X 101 40 A X 102 10 A - 103 10 B X 104 10 B In that Case on Line Item level I get the Ratio for Supplier A - 80% Deleted and for B 50 % deleted. Actually the purchase order would always be deleted at the header level . So both A and B should have 50 %. I have tried that with pull activities but I do not get the right results. I thought something in the direction: PU_COUNT_DISTINCT(EKKO, MATCH_ACTIVITIES(NODE_ANY[PO deleted] )) and to bind it to supplier in the table. Any help would be apprecia

Hi, I have a table of Agent who first performed an activity A calculated using (PU_FIRST(Case,Activity_Table.Agent_Name,Activity_Name"="Activity_A) and KPI of Number of times a particular activity was repeated within 7 days using : SUM(CASE WHEN DATEDIFF(dd,LAG(WorkOrder.CreatedDate,ORDER BY (WorkOrder.CreatedDate), PARTITION BY (Case.CaseNumber)),WorkOrder.CreatedDate) < 7 THEN 1 ELSE 0 END) . I want to rank the agents based on this KPI as another column. Can you please guide me on how to do the same ? Thank you for the help

We have created multiple Authorization objects on sales org from VBAK table and applied on data model and provided analyses access to users by adding the authorizations objects to the users and data model. when users try to access the analyses process explorer, they can only see the message all existing activities are hidden and no data displayed in any sheet of the analyses. There is no issue if i add only one sales org. auth. object to user. if 2 or more sales org. auth. objects are added to the same user, the analyses is not showing data and showing message as all existing activities are hidden . Could you please suggest the possible root cause an fix of this issue! Thank you for your support. Regards GopiCelonis authorization issue.pdf (75.2 KB)

Hi everyone, Ive created an Approval ratio of cases by using out-of-the-box KPI Ratio of cases flowing through an activity = KPI(Ratio, MATCH_ACTIVITIES(ENDING[Approved] ) = 1). It works as expected, out of 243343 cases 108698 of them are ending with Approved task which gives rounded up the value of 45% visualised as a Number single KPI component. However, when the KPI is added to the OLAP table and sliced by example Sales Channel dimension the result in OLAP and Number visuals is different. In the OLAP table Approval rate is 52% (wrong result) and in Number single KPI component is 31% (correct result). It turns out that in the OLAP table the KPI is switched to count activities instead of cases, hence the result is 52%. celonis different result1159530 61.2 KB Is there a catch how to get the same correct % in the OLAP table? All data is contained within a single table. Thanks, Ivan

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.