Product Q&A

Hello everyone, I want to send out every Monday (e.g. 12.08) all data records (e.g. deliveries) for the next workweek (19.08-23.08.24). I think I haven't found the right functions yet, therefore cannot wrap my head around how to implement this. Does anyone have an idea how to filter the data like this? Thank you! BRJulia Bauer

Hello everybody,I have a data model in which I need to manage one of the case attributes that can have multiple values simultaneously for a single case (i.e. a multi-value attribute) and I am wondering about which is the proper why to model it. In other DBs and DWHs, I usually model this situation with an additional table linked to the main master data with an N:1 relationship (N records for each master data record), but if I do such thing on Celonis and then connect the master data table to the Activity Table with a 1:N relationship (N activity records for each master data record), when I try to display the Throughput Time by the multi-attribute values, I get the infamous "No common table could be found" error message. Which is the recommended way to model multi-value attributes in Celonis data model creation? Thank you, best regards,Andrea

Would like to add fields from the AR_KNVV_KNVP_PA002 in an OLAP table along with fields from the BSEG table. However, have the error below - will the PQL functionality BIND ( ) work here?

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc.  I know that with the following code I can get the number of cases where the activity happened at least 1 time, but I do not know how to calculate the number of cases where the activity happened 1 time and not more often.  SUM(CASE WHEN INDEX_ACTIVITY_TYPE ("ACTIVITY_TABLE"."ACTIVITY") = 1 THEN 1 ELSE 0 END) The other thing I still miss is how I can calculate the number of cases in which that activity occurred >=2 times. When I change the formula to >=2, I get the wrong count as then a case with 4 activity occurrences is counted as 3 instead of 1 (it counts the second occurrence, third occurrence and fourth occurrence all as one 'case'). Is there

Hello together, I want to build a dynamic filter that can vary depending on when a particular button is clicked. This means I write a variable and update it depending on the button. The filtering also depends on this. Unfortunately, I cannot use the variables created in the view as input for the filter.  Specifically, I have a button called “Process start” and one called “Process end”. Depending on what was clicked, the start of the process in the filtering should not be longer than 12 months ago, or if the end of the process was clicked, it should not be longer than 12 months ago. I'm using this for a diagram. Unfortunately, the dynamic variables cannot be used in filtering.  Does anyone have an idea? I'm really desperate. Thank you very much and kind regards! 

Hi all, I want to update the value of a runtime variable with a Button input from a View (JAB) in order to use this runtime variable for a KPI with a PQL Statement inside a knowledge model .But I can't find the runtime variable in the 'update variable' selection of the button. Any Ideas how I can dynamically update the runtime variable value from a View?

GRIR Analysis Value Quantification Is there any Business Case Where GRIR Analysis Value Quantification is a Tangible Outcome? - E.g. P&L, WC Type impact apart from Productivity?

Debit Balance Analysis. Can anyone provide any UI/UX parameters which was deployed across their AP Analysis? Any wireframes which i can refer?

Hi,   I have two questions;   -I created variable into the KM but I cannot see them in the View Asset to be used -I have Input dropdown in the View asset and I want to assign user selection into KM Variable; is it possible?  

I have created an activity table with 5 activities,i also created the change activities by joining both activity table and change table,but when i use select distinct activities from activity table im getting only 5 activities,i want change activitis also

If FIRST(column) would return the first element and LAST(column) the last one, I would like to obtain the n-th element of that list. There isn't a straightforward function to do that but is there a way?

WRONG Name: PRIYADASHINI RCORRECT NAME: PRIYADHARSHINI R 

Hello, This is regarding the error I am getting when I add object relation transformation where relationship is m:n. Not sure what exactly I am missing here. Below is the error. Error while executing transformation transformation_ENTITY_OBJECT_custom_PurchaseOrderHeader, with id f4583963-8785-4497-b862-e063abc0db63: ERROR: Cannot set a NOT NULL column (PurchaseOrderRequisition_ID) to a NULL value in INSERT/UPDATE statement

Hi everyone, I would like to create a color mapping for a KPI in a OLAP TABLE.Each row in the table represents a case, with ID, an attribute from the same table (numeric), and a KPI created on that attribute (also numeric).I would like to color the value of the KPI based on the value of that attribute, for each case. For example, if it is greater in red, if it is less in green.I selected color mapping based on Dimension, and entered the first threshold as in the figure, but it colors everything red, not taking into account the value of the attribute.  Where am I going wrong? Thanks 

I am new user for celonis, I would like to apply for the new account for COTD (Customer order Deliver Delay). but there are so many choice when I raise a support for new count ticket, I am quite confused, where can I get guide or support?

I need to create an action in KM, which will help me to take specific input from a table and pass it to actionflow and the SAP rfc module in actionflow will write the infos in Source. From a skill i am not able to pass the inputs to actionflow. How to do this? the input should be multiple single values to actionflow and the actionflow will take those inputs and operate.

I'm trying to update a column in the activity table, but the Write data to table skill only writes to the global scope, where my Data Model can't see it. Is there a way to change the skill configuration? Or maybe the Data Model?

Hi,  Can you help me with a PQL that can showcase total time spent by each workgroup on an incident? The incidents can be re-assigned between different workgroups in its life cycle. output required  Workgroup Avg time spent on incidents Volume of Incidents handled A XX mins. 10 incidents B XX mins 20 incidents Example data below.

I am trying to create a Analysis level filter which will filter according to the user input given in the input dropdown. But not able to figure it out.

In my output (OLAP) table I want to have each activity name from the activity table and then an overview of the number of cases in which that activity name has occurred. Then I want to get an overview of the number of cases in which that activity name has occurred two times, three times, or multiple times etc. I know with MAX of INDEX_ACTIVITY_TYPE I can get the max occurrences of the activity name, but I do not seem to be able to find out how to use this in an OLAP formulation. Thanks in advance!

Hi all I have a fairly common question I believe:I have a linked View which focuses on one single instance of object. This has two augmented attributes: status and freetextfield of reason. The View has an ID variables (and filters) to narrow down on exactly one object. Now I am only aware of updating augmented attributes via a table and a row. But I would rather use a more userfriendly way of a Button + Input Field to update the Object characterized by the ID.  Does anyone have a similar setup and a solution on updating Augmented Attributes via anything else but an OLAP Table? I could imagine an Action Flow and passing in the ID, but I am unsure if its possible to trigger one via a Button Component.

I tried it already with the Extractor Builder and a "Basic Authentification" but it didn't work.

Hi,Is there any way for a team admin to extract/gather view statistics for analyses and views?Ideally - event logs with events like object (analysis/view) + timestamp when it was viewed. Also it would be great to have user as well. The goal is to get an objective picture of how often particular objects are used instead of interviewing the users.For example, users say: "We use this report every day!", but you look into the stats and see that this report is open once per week/month. Therefore, maybe smth can be done to improve user experience. Thanks in advance!

API to extract and push it to data pool, so i can build an analysis for visualization. Right now i am manually exporting to Excel and uploading it into to a data pool and then to Data Model. Have a visualization on top of it, so it is too many manual tasks, trying to automate this. ThanksMuthappan

For instance, ... 5 WO's have 3 Distinct Claim ID's, 7 WO's have 2 Distinct Claim ID's, and 125 WO's have 1 Claim ID. Thank you ... I am sure this is simple, but I can't find how to do it.