Product Q&A

Hi all,I want to use a random value/number. How is that possible?​Furthermore I want to get a sample of random 5% of my line items. E.g. when I have 1000 line item I want to filter to 50 line items. And these should be​ a random selection.​How is that possible?​Thx and br Daniel​​

how can i get badge after training ?

I have one saved formula that I want to apply to data from different tables. the data within the tables is different but the underlying logic and structure is the same. Therefore I would like to know if and how I can use parameters to replace a part or the complete table name with parameters.  I tried already to use a text parameter {p1} with the name STREAM, but received syntax errors. Can someone help out on this matter? I couldn't find anything about this in the official documentation.  Thanks in advance!

I want perform dual control test on segregation of duties where two activities A, B have been performed multiple times and i wish to flag the cases where they have been performed by a single user.Activity A -> Activity B then if A is performed again then it should be followed by B from a different user. is there a way to flag these multiple times per case id

Hi, I need help in building a KPI using two columns, I'm trying to build the KPI but the code is not getting executed for all the rows i.e. the 2nd condition code is not getting excecuted i'm getting the o/p as Blank . Requirement:  Below is my code: CASE WHEN ("CONTROLLER_xlsx_Sheet1"."KEY") = '10' AND COALESCE ("CONTROLLER_xlsx_Sheet1"."CONTR", 'RANDOM_VALUE') != 'A50' OR("CONTROLLER_xlsx_Sheet1"."KEY") IS NULL AND ("CONTROLLER_xlsx_Sheet1"."CONTR") NOT IN ('A01', 'A02', 'A03') OR(ISNULL ("CONTROLLER_xlsx_Sheet1"."CONTR") = 1 )THEN 'CLEANSE' ELSE 'PERFECT' END   

is it easy or tough app creater exam and webcam is on or off??

what is the addition cost for third and fourth attempt

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?

when we create a PQL formula including variable . I am unable to use the pql formula with variable in python to extract data or work on data.please let me know if there is any way to avoid error when variable is used. Currently I am using formula without variable in it.

Hi there, wasn't there an option to export transformation scripts or am I in the wrong location? Thanks,Saša    

We are trying to group tasks together so that they can act functionally as one. For example, we might have the tasks "Frame", "Mechanical", and "Paint". We ideally, the process should be conforming if the case flows through any or all of those tasks, and in any order. So if the activity just went through "Frame", or if it went "Mechanical" to "Frame", or from "Frame" to "Mechanical" to "Paint", all should be conforming.  In regard to the screenshot, we are getting violations because "04 Paint" is followed by "04 QA Post-Paint". We have tried grouping them in a subprocess, and we have also tried tried grouping them as a series of tasks in parallel connected by parallel gateways. Neither seems to work. Is there a better method for grouping tasks inside of the process model?  

how much is the maximum time that a workflow can be run in Celonis/Action engine? In both free or paid versions?

How I could configure a simple action flow? (stage 9 part1). I could not proceed in the stage (Configure your first module part).

in Celonis Action engine, If I use HTTP module to call an API, it times out in about 40 seconds, even if I set the time out property value to 300.

Hello, I start training "Analysis Building Basis" on the old web site. What is the training kurs on the new web site

Ready to seize unlimited opportunities? Visit the EMS Store from your EMS team and discover the different new Apps, Extractors, Connectors, Action Flows added every week we are offering to our global customer base made by Celonis and Partners. Visit the EMS Store or find your team. Recently Added: Inventory Management Connector:The Inventory Management connector leverages Celonis’ core expertise in O2C, P2P and PP process mining, whilst also mining for the very first time Inventory Management data. The result is an End to End connected inventory management data model, centred around the Stock Keeping Unit (SKU).This revolutionary data model allows you to combine the insights from O2C, P2P, PP and now Inventory Management (IM) into a coherent model, enabling use cases such as Identifying Obsolescence, E2E Root Cause analysis for poor Service levels, Stock Out predictions and so much more! Additionally, for the first time in Celonis history, this data model connects your Bill of Material

​

What is the status of the tickets i raised?

Please find our Thesis Program FAQs here: https://www.celonis.com/acal-thesis-support/

Hi all, I am analysing the approval process of various documents in a single system.  As the approval processes differs a lot depending on what document is, I would like to know for every single type of document, what % of cases have been regarded as the most common variant. I have read the Cloud Help documentation and came up with the PQL below but still the results differs from what I looked up individually in Variant Explorer, would you please advise what could have gone wrong in the PQL? Thanks a lot! AVG(PU_COUNT (    DOMAIN_TABLE ( "Table"."Document" ) ,    "Table"."Document ID" ,    INDEX_ORDER (        PU_COUNT (            DOMAIN_TABLE ( VARIANT ( "Table"."Action Name" ) , "Table"."Document" ) ,            "Table"."Document ID"        ) ,        ORDER BY (            PU_COUNT (                DOMAIN_TABLE ( VARIANT ( "Table"."Action name"  ) , "Table&quo

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

Has Celonis stopped Data Engineer and Data Analyst certification Exams? If its still there or name has changed , please guide how to find one and register for the same? Thanks in advance

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

Hello,I get an error when trying to install pyCelonis locally. Can you please give me advice (additionally to what is already available in the documentation). Thank you, Martin