Product Q&A

@sverre.klein11​  Hoping you can help on this question.

Hi, I can't see the solution here. Can someone give me a hint? is in the Value Realization course- Manage change & scale adoption 

 I have a table that I am doing an extract of last 1 year. Once the extract is complete, there is 1 column in it (let's say invoice number) that had some activity occurred for it few years back. I am trying to do a second extract of the same table where no date constraint is in effect but using invoice number column values in "Additional Filter" condition.Steps Performed:Extract table data for last 1 year.Create a dummy table to save invoice number column values in it.Create a list parameter to save all those invoice number values in it.Try a second extract of same table without "Enable creation date filter" condition.Use the parameter value in Additional Filter condition (Invoice IN <%=hist_param%>. I am getting an error in the second extract "ORA-01795: maximum number of expressions in a list is 1000".Its an on-prem extractor in use. Any help would be appreciated.

How can we calculate the average throughput time per unit without errors? ーーAVG(   CALC_THROUGHPUT (    FIRST_OCCURRENCE [ '伝票登録画面表示' ]   TO FIRST_OCCURRENCE [ '伝票保存' ]   , REMAP_TIMESTAMPS ("t_Activity"."日時", MINUTES ) ) )ーーーーErrormessage​ーーThe aggregation function AVG is applied on a column from table "t_Case" which has a 1:N relationship to the common table "t_Activity". This means that one input value can contribute to the aggregation result multiple times. For more information search for "Join functionality" in PQL documentation.ーーErrormessage​ーー 

Hello, how to set up the connection to sharepoint through action flow? While registering the application what should be the redirect uri? The one which is mentioned in the celonis help documentation is not working.

Hello everyone, the following KPI is implemented within a view:  Safety Stock / Sum Demand of the next 12 M (= Coverage Range [Years]) This coverage range is visible within a table in the view. I now want to incorporate the KPI as a filter. I created an attribute on the basis of the KPI:  My Celonis users now want to filter the coverage range individually e.g. >0.5 and <0.6 or >1 etc. In Excel this is very easy to do. Does this also somehow work in Celonis?As of right now I can only select the possible values from a list and without some intelligent clustering. Thanks! Best regards,Julia Bauer

Hi All,How can we clear View selection in 1 click? This is fairly straightforward in Analysis, where it is possible to create a button component that will 'Delete selections'. I find no such equivalent in Views. To add some context, we are creating views that integrate several KMs, which we'd like to separate by tabs (tab1 for KM ABC, tab2 for KM XYZ). The problem is that selecting on tab 1 will apply the filtering for the entire view and all KMs.  if the table.field (item creation date) i'm am filtering for is present in both KMs, then both KMs will be filtered for that selection, even though the filtering is only relevant for KM ABC. This will lead to misunderstandings. Ideally, i would like to create a view that upon clicking on a tab selection will clear the user selection. Is this doable?

Hello Dear Community, I'm trying to write PQL query that will return Material Numbers which are ordered on both active Scheduling Agreements and open Purchasing Orders in SAP.  Do you have any suggestions which PQL functions will be suitable for that? I've attached example with the input/expected output. Thank you! 

Hello All! Hope you all are doing great!We are working on a use case for which we are using Sap Concur connector available in Celonis market place. Wanted to check if anyone has used this connector.What is the method of extraction is uses? For now what I have seen in the connector settings, it seems it is using API. Could anyone confirm it. Regards,Tapan

Hi. I'm a new user, while I created the account / login incorrectly created as 'Guest' it is supposed to be 'Partner'. In the same I have completed welcome kit and Foundation. I planning to undergo certification. I need help to change access to Part

I've tried to follow the directions from Celo Docs, but the 'User Provisioning' area shown in the directions doesn't exist for me. I've looked in the other services areas, and my API key doesn't show.

Hi, As an admin can i see celonis from a user's prespective?As if i had their permissions? Best,João

Hi Celopeers Is it possible with PQL to create a KPI that will give you the name of the activity with the lowest / highest automation rate?

I'm want to create a dashboard and I'm trying to add the needed components, but the available height is not enough!  Is the option of adding components and allowing scrolling not available anymore?

What is the difference between the median throughput time of the first and second most common variants in days rounded to the nearest integer? select one: A. 17 B. 12 C. 5

Hi all One of my use case is to monitor a number of fields being left empty at the sales order creation. In order to keep track of these issues and make sure the root cause are being resolved permanently, I want to create a "status" for each item (in the example below, we are monitoring the Plant field). Status:NOK = plant field is missingOK (fixed) = plant field was changed from NULL to any valueOK = all the other cases it is the second option 'OK (fixed)' that is causing me some headaches and I would appreciate your help. I tried several options but for now, none of them are working.  Option 1:CASEWHEN "VBAP"."WERKS" IS NULL THEN 'NOK' WHEN ("_CEL_O2C_ACTIVITIES"."ACTIVITY_EN" IN ('Change Plant')AND "_CEL_O2C_ACTIVITIES"."CHANGED_FROM" IS NULL) THEN 'OK (fixed)'ELSE 'OK' END the result of this option gives me a table that will display 2 rows for one item, one with the 'st

Hello everyone,I have the following button dropdown set up in an analysis: In each dropdown selection the following coding is saved:I have already prepared the KM for the view like this - custom attribute:I now added the custom attribute to the dropdown list but the data is not filtered accordingly. To solve this, I think I need to add some variables to the KM which I already did like this:Yet, the variables are not avaible for me to select in this view:  Can someone help me with this? Is this the right procedure to migrate the button dropdown from an analysis to a view? Thank you for your support! Best regardsJulia Bauer

Hi,I have a table of 5 columns. Eg: Ticket_No, Description, Priority, Closed_Date, Owner.The 'owner' column has different email addresses. The requirement is to send the first 4 columns 'Ticket_No, Description, Priority, Closed_Date' in a CSV file to whatever email address available in the 'Owner' field. Can it be done via Action FLow - If yes, please let me know what are the steps/modules? If it is possible via ML code ? If yes, what are the steps. Your help would be appreciated. Thanks!

@Sophia Stephenson​ @Brian Dees​ 

I have tried the below code:CREATE TABLE TABLE_COUNT_TC AS(SELECT t.table_name AS table_name,SUM(ps.row_count) AS row_count,  CURRENT_DATE AS Record_Date  FROM tables t  JOIN projections p ON t.table_id = p.anchor_table_id  JOIN projection_storage ps on p.projection_name = ps.projection_name  GROUP BY t.table_name,ps.row_count  ); This code is giving multiple lines for one table and they are not the raw tables. They are the tables that are created in transformations. Can anyone have idea on the above query? Thanks,Supriya.   

I failed rising star technical assessment 4 times only one module i complete 75% please give me a solution i need to complete the assessment

Hey is it possible that hte Process Automation Bootcamp basically became the Rising Star Programm? Thanks in advance

Hi, the filter dimension reacts with the filter button, but after the button is pressed, the dimension is cut. When the section next to the dimension has a width less than 1, it doesn't work at all and when the width is more than 1, it's cut even more...  Does someone know how to show the full dimension?

What can be used to compare selected cases in celonis with the source system entries