Welcome to the Celonis Community
Recently active
Can anyone help me with this problem, I'm not able to convert this date field in this format to SQL. Does anyone know if I can get this in PQL? Or even in SQL 08-JUL-24
Hi, I'm getting this error in Open PR app, "Table could not be found. Table with name "PR_ITEMS_CEL_TASK" cannot be found". can anyone please help me with the solution. Thank you
There is 9 similar operations/output from the Array aggregator module inside action flow. How to reduce or remove the duplicate operations from the array aggregator(considering that change is any prior modules not possible but ready to adapt any filters ot add any more modules after the array aggregator module giving 9 similar operations)? Thanks!
I need to show a client all available permissions in the platform in order for their security department to determine which user gets what permission. Before doing all this manually, I wanted to know if there is a way to obtain all available permissions in the platform?
When selected from dropdown entry the result should reflect in both donut chart as well as in table. Can anyone help me to resolve it?
Hi all, i am trying to build a table and profile view that is similar to the ones that are shown in the celonis demos (table from celonis demo)(profile view from celonis demo) What I am trying to show is some root causes for the bottlenecks in the process and when user clicks on the category, a detailed analysis will be displayed But im still struggling with the first step which is how do i get to display those bottlenecks in the table, do i need to create a new table just to store those 'inefficiencies'? Thanks for your help in advance!
Hi, I was working on scripting transformations in OCPM events. I came across a scenario where events having m:1 (involves one) relationship with objects are populating those objects in the transformations as the mandatory field. I could not find these fields in the object table, that made me think that why can't I use source tables here ?
Hy,I have connected a skill with action flow using webhooks module and connected a view with that skill.As I wanted that user be able to enter text at runtime, I am getting error if I enter text in next lineThe 'execute action flow' module throwing error as follows
I tried this system. The first module gets all the data from the table to be checked, stores it in an array and then uses the if operator with the contains function to verify the data (CASE_ID) doesn't exist in the array, but this system doesn't work. I end up with duplicates every time because the if function always returns 0.
Dear Experts , I was searching for Oracle procure to pay process connector from market place but it appears its not available , is it true ? has this been removed ?
may I know what is the definition of case selected on top left of the analysis and how can it be determined?
Hello While extraction from SAP I am getting this error. Does anyone know what could cause this ?
Hi, I would like to set up a connection with an Azure data lake consisting of same parquet files. Does anyone know which data connection to make and with which settings?
Hi, my one data model is failing with this error: The Data Model Load experienced an issue loading to the PQL Engine. Celonis Support ID: b9be2416-8fc9-4d33-a121-0e8fa013da32 Is there a problem in Celonis or in my data model?
For example, I have a table listed with below values in one of the columnsComponent-AComponent-BComponent-CComponent-DPopup screen should show details of Component-C when I click it . I couldn't find any relevant material on this.Thanks in advance for your help.
Do the application keys for Outlook have a limit of emails they can send out? If not, what else can be the reason for this error: [429] Application is over its MailboxConcurrency limit?
In PQL, how do you concatenate a single quotation in a string? I am trying to generate a column of SQL input, e.g., value=to_date('date_value' , 'MM/DD/YYYY'). I need to concat a single quote on the front/back of the date_value.
Hi Celopeers and Celonis team. I have quite a conundrum that is bothering me quite a bit and I don't know what else to try. I have a case-when kpi that creates a risk category for customers based on a set of parameters. It works perfectly for customer by customer basis. But when I try to do any aggregations by the categories it always shows just one value. In the below image you can see it in action. In one the KUNNR number is the dimension and the Category as the KPI, in the other, the Late payer is as dimension and COUNT(KUNNR) as a KPI.
I am trying to upload my excel file with date and time to run the event log / process mining. The date and time format in the excel file is yyyy-mm-dd hh:mm:ss but Celonis does not recognise this and is calling it out as the wrong data format type?
Hi Community, I am working on augmented attribute in new Studio experience. There is a requirement that business wants to track the user who made a change to the augmented attribute. As each augmented attribute has it's own table in the data model, I am using the Changed By attribute in the view but it shows some alphanumeric value (some coded output and not an existing user). I tried adding additional attribute with the name USER_EMAIL in augmented table where it uses USER_NAME() as PQL formula. It does show correct user email in preview of record in KM but when I try adding same column in view it throws error "PQL Error - A PQL error is preventing this query from executing.COLUMN_REFERENCE: Column with name ["user_email"] cannot be found on table [<data model table>_AUG_<Augmented Attribute Name>]." Is there a way to get correct username from augmented table into the view?Any help would be appreciated. My BestHamood
Hey, is it possible to have two date picker on one view. One date picker is supporting one table and the other date picker the second table? I want to compare different times with each other to see the difference... Maybe you can help me
The error message states: "Data Export not enabled or missing permissions. Please check permissions or contact Celonis customer support."As an admin, I have verified that all permissions are correctly set. I'm not sure how to proceed from here. Has anyone encountered a similar issue or can provide some guidance on resolving this error? Any help would be greatly appreciated.Thank you!the error output : ---------------------------------------------------------------------------PyCelonisPermissionError Traceback (most recent call last)File ~/.local/lib/python3.8/site-packages/pycelonis/ems/data_integration/data_model.py:430, in DataModel.create_data_export(self, query, export_type, query_environment) 429 try:--> 430 data_export_transport = IntegrationService.post_api_v1_compute_data_model_id_export_query( 431 self.client, self.id, data_export_request 432 ) 433 except PyCelonisPermissionError as e: File ~/.local/lib/python3.8/si
Hi, when I tried to use variable in views, and it turned out with error "Runtime variable Error. The variable Duplicate key detected: <objname>. Please make sure that this variable is defined." However, my view turns out to be blank for all the components. Even in the Edit mode, unable to launch the PQL editor again. Can anyone please advise what can be done to fix this? Thanks.
We have a global date filter for filtering out dates. Now we want to create case explorer that should have the global filter on. If the global filter is on it dont show all the events that is not in the date filter. any ideas how I can exclude the global filter for 1 view
Hello Celopeers, whats the best way to handle NULL results in PU-Functions when I need 0 if no PU results are available? Here a example how I do it today: CASE WHEN ISNULL(PU_SUM(VBAK, VBAP.KWMENG)) = 1 THEN 0 ELSE PU_SUM(VBAK, VBAP.KWMENG) END Is there a way to make it better? BR, Thomas
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
