Product Q&A

Hi all, before Christmas I experienced an error when executing a skill for the task creation. It seems to be that there is a limitation of data entries for a table in the data model when executing a create task skill. I am confused because the table which gives me the error is not even used in the skill. It is just in the data model which is loaded for the knowledge model and skill. The threshold seems to be 30Mio entries. Did someone experienced the same issue? For large companies like BMW we have more than one table with 30 mio entries. @CelonisTeam: Does this means for such data models the task inbox feature is not useable?

while running a python code we are getting the above error . what will be the reason for it?

I've build a solution with PyCelonis to extract process analysis data from Cyelenois cloud envioronment. I used URL and API key to make connection. This solution was built and tested with Celonis cloud environment. I need to deploy same solution in Celenois on-premises instance. I'm not familiar with on-premises instance and wheater it support PyCelnois API and if it does support then can i still use URL and API key to establish connection?  

Need your help/update to know whether Celonis has connector for SAP CRM as source system. 

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.

Like 1. How many attempts we have? 2.Do we have both Theoretical and Practical Questions? 3. what's the passing percentage?  

How to change celonis logo to my customer logo in celonis cloud.

In my training cloud one of the vendor details table(LFA1) got many records due to which my data consumption limit is already exceeded. How can I free up some space ?

How do I get the ABAP Request Template?

Hey There! We are experimenting creating custom extractor to connect to an external application. However the connection is successful and we are able to extract the tables/data, one particular column of a table is extracted as an individual nested table through the JSON response. Is there any way to modify the JSON response and bring them as single table through the extraction? suggestions or reference doc's are most welcomed. Thanks in Advance!

Good morning, Recently, at Solvay, we've been trying our hand at using Celonis' Data Deduplication ML solution Now we've reached a point where we want to further customize it, which means we need to understand what is behind it! For example: Here, in point 3), it is mentioned that common scanning errors in Invoice References will be checked like "8" <-> "B".  Is it possible for me to see (and modify) the list of Similar Characters? How do I access / change this code? Thank you in advance! Best Regards, Vasco Carona, Solvay

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.