Home > Success Hub > Get Learning
Dive into training materials and grow your knowledge with our expert-led content
Join our free online training platform
Follow learning paths designed for your role
Elevate your skills guided by expert trainers
Stand out in the crowd. Get #CelonisCertified
Good morning all, I need assistance with PQL to compare the timestamp of a certain activity of case A with the timestamp of another activity of case B, has anyone done this before?
Hello,My goal is to create a filter which, after clicking, will only show cases which contain specific activity in them. In my case I want to include all cases which do contain activity with string ‘reject’ in the name of activity.I’m trying to create a filter with this expression: FILTER MATCH_PROCESS_REGEX ( "_CEL_MERGED_ACTIVITIES"."ACTIVITY", 'X' >> LIKE '%reject%' ) = 1; Although it does not seem to be working.How can I create and apply a filter to show only all cases which do have such activity?
I have event log as leading_object_id activity_name resource1 Create Invoice A1 Approve Invoice Z2 Create Invoice A2 Create Invoice B2 Approve Invoice BI want to write PQL query (KPI) such that I get count of all objects where resource of Create Invoice matches with Resource of Approve Invoice. How can I achieve this?
I'm facing an issue where my charts and tables show the message "You don't have data yet" even though I have connected them to the data model.When I create a Case Explorer, it only shows 1 row with these columns: Case ID Number of Activities Duration In the table section of the Case Explorer, it only displays CDHDR.CASES.Can someone please help me understand why I’m not getting any data in the charts or other tables I create?Thanks in advance!
Hi all, In the case explorer, in YAML or Views, how can I change the Throughput Time and use my own formula in PQL?Thanks for helping.Br,Leonardo
Hi All,Just wanted to ask whether there is any documentation on how to migrate existing CCPM datamodels to OCPM one.Thanks,Akshay
Hi, I have completed all the levels of the Business Analysis Internship successfully. However, I couldn’t pass the final assessment even after 4 attempts. Now the system says I have to wait 6 months before I can try again.Is there any way to retake the assessment sooner or get support from the team to complete it and receive my certificate?I would really appreciate any guidance. Thank you!
How can we apply colours to charts/process explorer/tables in Views?
Within an OLAP table, I would like to use both the Delivery Line Item Date ("VBEP"."EDATU") and the shipment gross weight ("LIPS"."BRGEW") Does anyone know how I can apply a PQL function to combine these tables? Please find the error below. I looked into the PQL documentation but I can't find the solution. Error in formulaNo common table could be found. The tables ["VBEP"] and ["LIPS"] are connected, but have no common table. This means that they do not have a direct (or indirect) 1:N or N:1 relationship. Join path: [VBEP]N <-- 1![VBAP]!1 --> N[VBFA]N <-- 1[LIPS]. For more information on the join path, search for "Join functionality" in PQL documentation.
We are working with a prospect who uses JDE and he requested us this information.
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.