Welcome to the Celonis Community
Recently active
I am unable to get the option to schedule a notebook in my ML workbench.Does it require admin access to get the option? Documentation says to have a valid executable file, which I have. Any code to be written in the notebook to make it eligible for scheduling?
I would like to create a use case to analyse the throughput times of finished goods flow from one warehouse to another.Unfortunately, there are no pre-existing data connectors available for this particular use where i would be especially looking into goods issue and goods receipt.I did go through the celonis academy trainings but the trainings were basic and i cannot seem to apply what i learnt in the trainings to my use case.Does anybody have any help/ leads?Best RegardsKenny
HI Team,I have One table which has Vehicle ID and other Table which has PartDetails. I want to count claim number from this but both columns are coming from different tables. When I tried using this with DOMAIN TABLE it is giving me following error message:-Pull-Up-function could not be executed. PU_COUNT_DISTINCT: Cannot execute PU-function on tables [<DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )>] and ["o_custom_Claim"], since they do not have a 1:N relationship. You might want to make use of the BIND function. Join path: [DOMAIN_TABLE ( "O_CUSTOM_CLAIM"."VEHICLE_ID" , "O_CUSTOM_CLAIMLINEDETAILS"."PVTXT" )]1 --> N[o_custom_ClaimLineDetails]N <-- 1[o_custom_ClaimLines]N <-- 1[o_custom_Claim]. For more information on the join path, search for "Join functionality" in PQL documentation.Can anyone assist?
Hi all,In my View analysis I added the filters into the ‘Show Filter Bar’ that resided on the right side of the view. However, once the same view is opened in overlay, the ‘Show Filter Bar’ is not visible - hence I have no access to the filters. Is there a way to include a Filter Bar into a view opened in overlay? Thanks and kind regards,Mateusz
Out of the blue, every single Excel module in Action Flows has stopped working. Has anyone gone through something similar recently? Has any announcement on this topic been done by Celonis?The screenshot of the error is meant to help better understand the issue as it seems to be a simple ‘access’ problem, but every account that’s been used within those modules has the same issue and all of then started at the same time, so it feels something structural is going on…Either way, if anyone has some insight on this it would be greatly appreciated! Thanks!
I have built process maps using OCPM. When event timestamps are equal for more than one activity, the events are sequenced based on alphabetical order of event names in process explorer. This is misleading and does not make sense as it is supposed to be in the sequence of sort order.Is there a way to configure sorting order based on sort column when events timestamp are equal?
Hello Community,i have the challenge to extract and transform data from various SAP System und to combine them.My problem is, that there are tables who are filled or not depending on the system. If not filled, there is also no table in the schema. So I get an error while running the SQL script.My question: Is there an option to check with the SQL script if the table exists or not.In my example below: How to check if TABLE1 is existing or not. If yes all fine, if no only run the TABLE2 part.Thank youThomas CREATE VIEW TEST_VIEW ASSELECT"TABLE1"."MANDT" AS MANDT,"TABLE1"."TKNUM" AS TKNUM,"TABLE1"."TSNUM" AS TSNUMFROM "TABLE1"UNION ALLSELECT"TABLE2"."MANDT" AS MANDT,"TABLE2"."TKNUM" AS TKNUM,"TABLE2"."TSNUM" AS TSNUM,FROM "TABLE2"
Hi Team, I am trying to create a column chart where I am using 2 tables custody and activity_table .However I am end up with no common table error. The joining in the datamodel as follows:custody(N) ← MCA_CA_ID_NEW(1) → Line_table(N) ← Head_table(1) → Activity_table(N).How I can write the pql statement for this .
Hello guys,I am currently taking the pathway “Automation” in the Rising Stars Program and in the Module “Process Automation Basics” / Automate with Action Flows (https://academy.celonis.com/learn/course/automate-with-action-flows-i/automate-with-action-flows-i/course-outline?client=academic-alliance-celonis&page=2) I have a problem with setting up the GMail Trigger. I set up the API and the OAuth-Client just as presented in the tutorials. the only change was that, because we dont have the affected persons Email I used my regularly GMail. As I am setting up the Trigger I have to sign in in Google and just like the tutorials i use (the same) Gmail Account. As I want to proceed following error message pops up: I hope somebody can help me, because I have absolutely no idea left what I could try to fix it.Thanks in advance for helping me out!Best wishes,David
How can you configure the sorting of activities in OCPM?
Hi, in the legacy view there was possible to change background color of textbox, buttons etc. but I cannot find a way how to do it within the new views. I tried to do it through the YAML but it’s not working. So if someone has an idea it would be awesome!
Hello, I am trying to create an ActionFlow for updating augmented attributes but its keeps giving me errors. The operation failed with an error. 400: Failed to update augmented attribute. Failed to query engine to map identifier from one value to separated columns. Unknown query engine failure I created an augmented attrobute in legacy views with a unique identifier. Now in the ActionFlow I do all my selections with the correct identifier: And I get the correct result in the input: But it doesnt update the augmented attribute due to the error: As you can see the identifier is the same. What am I doing wrong here?
I recently attempted the Celonis assessment but have exceeded the allowed attempts, resulting in a six-month block. I understand the policy, but I am eager to improve my skills and demonstrate my understanding of Celonis. I have been actively studying through the Celonis Academy and other resources. If there is any possibility of reconsideration for an additional attempt or reducing the blocking period, I would be extremely grateful. Please let me know if there is a way to review my case.
Hi everyone I need to add 3 kpi’s together (new views) each with their own filters. Here is an example of one. How can I add these KPIs together without having to build these filters into my PQL. If you save the KPI it does not save the filters with it. Can I maybe let it write to a variable with the filters? Or is the only way building the filters into the PQL with Case when or PU function?
https://academy.celonis.com/learn/course/celonis-rising-stars-program-business-assessment/main/celonis-rising-stars-program-business-assessment?client=academic-alliance-celonis&page=4 My assesment attemps is closed. Please solve this
I am trying to retrieve a count of a specific column based on a **CASE WHEN** condition using PQL. However, I am encountering the following error: *"A PQL error is preventing this query from executing. No common table could be found. The tables ["LINK"] and ["JS_PGT_Resolved"] 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: [LINK]N <-- 1![SUPPORTCASE]!1 --> N[JS_PGT_Resolved]. For more information on the join path, search for 'Join functionality' in PQL documentation."* I would appreciate any guidance on how to resolve this issue. Thank you!
Hi,I was wondering the following: I want to export my entire data pool (extraction, transformations and data models) using the pyCelonis API. I have been trying to code it myself but there doesn't seem to be a straight forward way to do it. I was wondering if any of you have been using this method and can help me find the right code to use. The use case is to back up our work once per day. A very nice to have would be an additional script to use the exported data pools to automatically recreate the back-upped work. In other words: Run script > back up written to files > run script > recreate celonis environment in case of total loss of data
Dear Experts, If there is decision to be made in terms of best practices on connectivity to S3 , could you comment on option 1 : connecting S3 bucket directly which contains source tables option 2 : transforming data from S3 using databricks converting into activity and case tables and placing it to seperate bucket and then data shared with celonis ? Thanks, Shaif
Dear all, I have in one view two OLAP tables(with complex calculations and predefined conditions) for which I want to create independent dropdown filters. The reason for that is that one should be filtered based on date type “received entries” and the other one based on date type “processed entries”. I was wondering if you maybe came across such an issue or if you have maybe some tips & tricks or solution for me? In advance thanks for your help. Best, Bunyod
Hey all looking for some insights whether this will work or not if I want a previous years data e.g ( I have 2023-2025 data in CDHDR but I also want 2022 ) can I change the UDATE filter from ( 2023 to NOW ) to ( 2022 to NOW) and disable the change date check and do a DELTA load to only extract fresh records that are not present in celonis ( even if it’s from the previous year of already ingested data )
I want to create an Aging/Market custom objects so my graph can be change based on dropdown I will select. let say If you select Aging then aging should be applied on the chart. How to implement in new views?
Hello,Is there an effective method to restrict exports to specific users or groups of users in Old Views?
Hi,I'm trying to create an Action Flow that allows me to convert a CSV file to XLSX and then send it via email.Current Flow:The user enters their email in the application view and clicks the "Send Email" button.A webhook retrieves the data. We then use Celonis Get Rows to fetch data for a specific Account ID (one Account ID may have more than one document). The data from Get Rows is added to a CSV file.Expected Solution:Instead of saving the data to CSV, I would like to:Aggregate the data differently, e.g., fetch it from another HTTP output or webhook. Use ML Workbench in Celonis to convert the JSON format to XLSX. Then send the XLSX file back to Action Flow to attach it to the email.Question:Is it possible to implement such a solution? Or is there a simpler way to generate an XLSX file as an output?
Dear Experts , I have a doubt here, on what logic does the objects appear on scroll bar in Process explorer like shown in snapshots attached. Are they dependent on number of objects i defined or events or relationships ?
Hi, Came across the below slide in Partner asset library but couldn't find any file in the below format. Can you please let us know where to find activity definitions for a particular process along with the conditions used. Thanks.Regards,Deepti
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.
