Product Q&A

Hello Community,I hope you can help me to find the best approach of my issue. My challenge is to build a table with the complete SAP Process Flow: Order, Delivery, ShipmentFor this I have created a data model with the following linked tablesVBAK (1) - (N) VBAP (1) - (N) LIPS (N) - (1) LIKP (1) - (N) VTTP (N) - (1) VTTK When I try to add fields from all tables into one studio table I get the following error:I have understand the problem but missing the best approach to solve it.What do you think? Is the a studio table with different PQL formulas the solution? If yes, how can I do it?Or is it better, when I create a table (e.g. TAB_PROCESS_FLOW) within the transformations that includes all the key columns and connect the other tables (VTTK, VBAK...) within the data mode

I am using the free version and custom functionality.Have two event logs and trying to create two flows with transition using the process explorer.Data model, KM, Data Explorer everything is working.  In the KM link between logs is enabled. In Views - Process explorer , it shows two flows. but the transition is not showing so trying to enable the configure transition in the Transition toggle and getting the error as Invalid PQL query. TRANSIT_COLUMN: No join path between the case tables1.What should be data structure.?2.Do we need same event in both logs?3.How does multievent log works with Transition enabled in backend.   

Hi team,I am using this command content-cli profile create.I am asked for name,url and api key.I have added all the three, but it gives me error as - The provided team or api key is wrong.Name of the profile: XYZYour team (please provide the full url): https://XYZ.eu-5.celonis.cloudProfile type: OAuth Device Code (1), OAuth Client Credentials (2) or Application Key / API Key (3): 3Your api token: XYZ*API token is directly fetched from celonis-edit profile-api key.Is it necessary to have admin role for this.Currently i have analyst access.Please help me with this.

Hi Community I need your inspiration for a big challenge of mine: Share an Insight made on a dashboard to colleagues with the least amount of effort. a bit of context:I have an Analytical Dashboard, it is not ment for Management and its not Operational. Its purpose is for Process managers to analyze the visuals and find inefficiencies. Now quite naturally if the enduser found something they want to communicate this finding (current Values+ be able to document which filters allowed to come to this finding). Receivers of those findings could be:other Users of the same Celonis Dashboard or persons which do not have Celonis access and also should not have it.Ideally I would like to have a Button or Action within a table called “Share Insight” which automates the  process for the enduser as much as possible. My initial thoughts around this:“Export PDF” is nice to share with non-celonis users. “Share L

How can you configure the sorting of activities in OCPM?

i have activity table which have same timestamp(T) for multiple activities in a single case. for eg : activity A has T 5:00, Activity B has T 5:10, activity C has T 5 :10. here i want the flow to be like A->B and A->C. but flow is A->B->C

Hi Celonis team, If I have Activities ‘A’, ‘’B, ‘C’ , how do I confiugre the petri model inside the Conformance query found in CONFORMANCE?If Synax is as per below, whee do I add A B C, provided A is starting activity and C ending activity?NB: I don’t have a BPMN model. CONFORMANCE ( activity_table.string_column, [ places ], [ transitions ], [ edges ], [ mapping ], [ start_places ], [ end_places ] ) I’ve tried the below without success, based on the examples from the website:  CONFORMANCE ( "ACTIVITY_TABLE"."ACTIVITY",[],[],[],[['A' 'B'] ['B' 'C'] ], [], ['A'] , ['C' ] ) and

Hi,We previously built the conformance checker in Analysis, but after migrating to View, I couldn’t find the feature. Does this mean that the conformance checker is not available in View?Looking forward to your clarification.

Is it possible to use a KPI in a text box like in Legacy Views? I currently use this to display the last data refresh date of the use case in Legacy Views, but this option isn't available in New Views. Has anyone tried using any other component ?

There is a case I want to solve, see below. I have a solution I would apply if I had classical programming language + RDBMS, but I'm not sure how to implement this in celonis or whether there is another solution. Could you please help? The case I want to solve is sending email notifications to users via action flow in case there are missing invoice receipts.For each missing invoice receipt there is a notification type that can be chosen with their own subjects, body text, etc., for instance:If the date1 >= today + 7 days then group 1.If the date1 >= today + 14days then group 2.If the due date >= today - 7 days then group 3. One possible solution would be to keep the history of the sent emails in some table and join it to the missing invoice receipts data to filter out the emails for each new iteration of sending - so that we don't send some letters twice if we already sent them.E.g.

I'm encountering a persistent error in the View: "Failed to auto save the View. Please save your changes manually." Even when I attempt to save the changes manually, the View does not get saved, and none of the modifications to the UI are being retained. Is anyone getting the same issue? what could be the possible resolution?

Hi CommunityAny possibilities to change the object colors in an object centric graph? 

Hello,I am just starting with Celonis and I have the following question: I would like to find out which activities are repeated the most (rework). What could a corresponding PQL function look like? I have already looked at Calc_Rework and Index_Activity_Type, but both do not provide me with the right function because I would like to look at the rework number of activities across all cases (across all sales orders together) in order to make a statement about which activities cause the most rework in the company under consideration.Thank you very much in advance!

I was wondering why it is not possible to create a free account to be able to preview this solution. Thanks.

Hi, I want to know if there is a way to export the following listData model name ------ Data permissions ( Enabled/Disabled )if enabled then Group / User name ------ condition ( if any ) ----- unlimited (yes/no)i want to download this list as an excel, is it possible?

HiI’m curently working on OCPM Data Pool and have trouble in an object transformation.In the Currecny Conversion object(o_celonis_CurrencyConversion),I checked that I can see data record in Preview,and executed publish to development.Then I ran the Data Job Transformation(full load), succeeded,ran the Data Model Load, succeeded,but at the end o_celonis_CurrencyConversion has no data.I don’t know why but when I go see the object preview again, the preview doesn’t show anything.Has anyone had this kind of experience ever?If yes please kindly help. FYI as the prerequisite, - the relevant sap table data is sycronized from another data pool - the object and its transformation script is celonis default one​​​​​​​ - Data job is done by the duplicate of test:ocpm-data-job(celonis default test data job) - the reason why I use the duplicate data job is that the original one returns an erro

I am trying to access transformation scripts from ML worbench with pycelonis 2.6 . But i am not able to fetch SQL scripts from transformation jobs which belongs to a template with visibility type protected. How to open the protected from task templates?

Hi! I would like to personalize the event names for a client demo. How can we do it? Regards

Hi everyone,the company I work at is interested in using the Process Adherence Manager (PAM). We already started setting it up for a first use case. While doing so, we encountered some questions. We would be very happy if some of you could share your experiences with PAM, particularly regarding (but not only limited to) the following questions:How do you handle numerous deviations that might be acceptable in some cases but not in others? Is it better to filter on each variant based on known attributes and break it down by creating multiple PAM instances? Or can it be a solution to create a lot of “allowed deviations”? Is PAM more suitable for complex processes including multiple objects or is it more effective to look at little sub-processes individually? The idea behind this question is that when a large process with deviating variants, the conformance rate tends to be low. Do you have experience if there are any types of processes where PAM is

Hi team,I am working on creating a dashboard out of a table created by TASK(cel Task).I am able to find the table in legacy view but not in new view.Please find attached screenshot of legacy view and new view. Legacy view: New view:Can you please help me in this? Thanks and Regards,Gauri Pai

We are using an action flow to query data and send it to Snowflake.  The issue is that it transfers 1 line at a time even if we use a csv module or leave that out.  It takes 18 minutes to transfer 2000 lines (10 fields per line).I think about how fast it is to download a MUCH larger table from a view or an analysis and think there has to be a faster method.  Is there a faster way to do this?

Hi all,I have a set of IDs/Case Keys that is spread accross 2023-2025. Focusing on 2024, I would like to calculate the daily average based on the Last activity dates.These IDs are divided in products, so when I create an OLAP table in Studio Views, then it takes the IDs per product, for large samples it’s closer to a correct daily average. On the other hand, when the product has 1 or 2 case IDs, then the Daily average is far from correct.Instinctively, I believe I should create a DOMAIN_TABLE but it doesn’t work. I tried using GLOBAL but it is not accepted.Hereby the code i’m using:Originaly:KPI("number_of_cases")/(  MAX (REMAP_TIMESTAMPS (PU_LAST("PROD_CAS

Hi,is it possible to use a COUNT_TABLE together with CASE WHEN to form a KPI? Below Query works for a simple COUNT with “TABLE”.”COLUMN” in THEN, but doesn’t work for COUNT_TABLE. COUNT_TABLE(CASE_WHEN(PROCESS EQUALS XY OR PROCESS EQUALS XZ) THEN "CASES" END) Thanks!

Hi everyone,With the latest views in Celonis, is there a way to filter multiple values across one or more dimensions in one go?For example, I want to filter all the purchase orders where field vendor name contain any of the following: ‘zxc’,’et’,’corp’ - without having to manually select each value one by one from filter dropdowns.Is there a more efficient way to achieve this instead of configuringdropdowns to select dimensions, input boxes to enter search patterns, and variables?For multiple dimensions, this setup becomes impractical.Thanks in advance!

Hello Celopeers,  we would like to start using the Package Dependencies to maintain several package as DEV and one package as PROD. For KMs seems everything working fine with the KM extensions. We want to follow similar approach also in case of Views. Creating a View in DEV package and automatically synchronize the change made here to the PROD package.After some tests, we realized that changes made to View in DEV package are not reflected in the PROD package when updating the dependency.As per following description, we understood that this shoud be possible:By adding a package as a dependency, its Views and Knowledge Models can be reused using this extension mechanism. Does someone has experience with the Dependencies usage on Views and could help us overcome our issue? Thanks a lot.Jan