Welcome to the Celonis Community
Recently active
Hi together, I'm working with legacy views and can't manage to pass the value of an augmented attribute of type date to a variable to use it as parameter for KPIs. The record containing the augmented attribute - id: CM_MONTHS identifier: id: id displayName: Id pql: '"CM_MONTHS"."MONTH"' attributes: [] newAttributes: [] augmentedAttributes: - id: late_creation_deadline_date displayName: "Late Creation: deadline date" possibleValues: [] columnType: DATE format: "%Y-%m-%d" housekeeping: false type: AUGMENTED_ATTRIBUTE flags: [] priorities: [] triggers: [] businessRules: [] type: RECORD origin: PACKAGE The component to update the augmented attribute type: table settings: data: columns: - id: 3486adcd-a996-49a5-97e0-af17da07e9af field: CM_MONTHS.MONTH order: 100 - id: 10c08937-649f-48a0-88fe-929d3107e824 field: CM_MONTHS.AUGMENTED_late_creation_dead
How to add a custom KPI in the OCPM process explorer?
hey,i completed the whole module in process mining but didnt recevied my certificateplz help me in solving this problem mail id :- snehachanna1125@gmail.com,thank you,sneha.
It is possible to create a table that is filled with defined variables that count certain tasks.You see, in my organization we have 2 people responsible for the tasks, which would be the User and the Supplier. The User is responsible for 3 tasks and the Supplier for another 2, so I would like to make a table that appears Responsible #Quantity of tasks completedUser 30Supplier 5 I can only add them as a columnCOUNT (DISTINCT CASE WHEN "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Approved' OR "_CEL_CRED_ACTIVITIES_ARIBA"."[APRO] Estado de la tarea" like 'Reviewed'and "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" like 'Revisión Usuario' THEN "_CEL_CRED_ACTIVITIES_ARIBA"."ACTIVITY_EN" ELSE NULL END )
Hi everyone,We’ve recently started trying the Transformation Hub, which looks like a fantastic tool for tracking the realization of value. While exploring its capabilities, we’ve noticed a few limitations (though we might be mistaken, as it’s still new to us).Is there a roadmap available that outlines when new features might be added? Specifically, we’re curious about the potential inclusion of:Custom processes Custom objective types Custom currencies (e.g., $CAD) Ability to track value based on something else than a financial amountThanks in advance for your guidance and any updates you can provide!
plz help me in sloving this problem i completed Use the Variant Explorer in process mining but it is not showing any progress for this module because of t6his module iam not receving my cerificate
SKILL:OUTPUT ATTACHMENT:Can someone explain why this is happening that encoding is not perform - what do I missed?
Hello all,I am struggling to calculate the average count of activities for similar cases. The calculation returns a wrong result. It doesn’t matter if I use PU_COUNT on the activity table or CALC_REWORK. Example DataCase ID Parameter Number of Activities in Activity table 1 A 10 2 A 10 3 A 20 4 B 15 I would like to know the amount (count) of process steps (activities) on average for cases with a certain parameter.Expected ResultParameter Average activities count A 13.33 ((10+10+20)/3) B 15 (15/1) What I getDimension: ParameterKPI: AVG(CALC_REWORK())Parameter Average activities A 15 B 15 It does consider the ‘10’ activities for case 1 and 2 only once. So if the number of activities is the same for multiple cases (which might very well be the case), the calculation is wrong. If I remove the Dimension, I get the correct overall result of 13.75. But as soon as I add the Parameter as a dimension (which I need), the result is not correct anymore
Hey, I can see that we have alert subscription option for action flows. But can we get the error information somewhere for each email sent ? I am currently working on creating an action flow tracker, for which I want to track and visualise the number of emails sent with each action flow stream and what error that action flow stream faced that too. Let me know if any ideas for the same. Thank You
Hi all, is it possible to alter the push csv to Data Integration but instead of using one drive using sharepoint. I tried it but it always tells me that file cannot be found. Also the id that i have to use for the make a request in the documentation does not exist Push CSV to Data Integration (celonis.com).Thanks in advance :)
I'm using a SharePoint connector and the Microsoft 365 module to read data from XLSX files. These files are constantly updated, and I needed a way to get rid of them after a certain time. I know that Microsoft 365 has a function to delete a table, but it deletes a sheet, not the whole file. The SharePoint module has a "Delete an Item" action, but it doesn't seem to bring the correct files. Is there a way to do this? If not, is there a way to move files from one path to another inside SharePoint, still using only Action Flow?
Hi all, is it possible to code in the Academy Studio or not. For me it always show that there is no data model or data pool that i can use. Thanks for your helpbest regards Louis
Hi everyone,I have completed the training track “Internal - Core Processes”, still I am not receiving any confirmation upon its successful completion and the overall training status remains at 75%.I have done the courses of that training track twice but I couldn’t get to 100%… Do you have any idea on how to solve it? Thank you very much!
Dear all,I am currently working on building a view for the management team to track KPIs across the entire organization. The organization consists of multiple entities, each using different systems (e.g., SAP, MSSQL, etc.), and as a result, we have multiple data models in the backend.In the overview view, we want to visualize data from these different models in a single interface. I have created a space that contains one view and multiple knowledge models. I would like to confirm whether this approach aligns with best practices and if it is possible to achieve my goal with this setup.Looking forward to your insights.Thank you,Yuyao
Hey community, Is it possible to combine two ocpm objects with each individual eventlog to combine into on object & eventog?My szenario is that i have two objects for two different type of documents. They have the same structure and events but they are not named same as each event ends with they name of their type.And i want to perform on both the same analysis and i am looking for a way instead of duplicating all analysis and adapting the kpi to simply my it. So both less duplicate work for me and easier for the enduser to work with. Is there like a “union” function to join them or is it possible with a parameter to switch the object/eventlog in a view? Thanks in advance
Hi,we are looking for an option to restrict the dropdown of an “Asignee” component to a selected number of persons. Currently the dropdown shows ALL persons / groups in our tenant (see example below): Is it possible to restrict the dropdown to display only pre-defined users or user groups? If so, how can this be achieved?BR,
I extended my duplicate checker perspective, add the objeties what i want, and change my data model variable to my data model extended, but my view warns are records missing, these records have “aug” in the name. Anyone know how to change my data model to my data model extended and create these records missing?my perspective extended:the error when i change my data model:
Hi,I want to create an action flow by querying a data within a specific range of date (e.g. total number of PO created from 01 November 2024 to 01 December 2024). How can I achieve that?
Hello,I’m trying to create a link in the editor that directs to a specific scenario. The only method I know is to copy the link to the scenario, but when clicked in Navigator, it opens in a new tab.Is there a way to create this link so it stays within the same screen? Edit the link in Editor
I have completed my course track “Process Mining Fundamentals” but the course badge is not received yet. Out of 7 badges only 4 badges I received. I have attached the image that I completed proof of that track. What can i do for solving this issue?
Hi All,When using a case when statement how would I go about excluding all the values which are not true from the result.Lets say:CASE WHEN PROCESS EQUELS 'A' -> 'B'THEN 'A to B'WHEN PROCESS EQUELS 'C' -> 'D'THEN 'C to D'Now I'm only interested in plotting the values fall in the 'buckets' basically. How do I exclude the rest which are NULL (very large number of cases).
The Process Explorer can have its activities cropped via use of the Crop Selection page filter, however when using the formulas CALC_CROP and CALC_CROP_TO_NULL in its component filter, the Process Explorer fails to crop Can the Process Explorer be cropped via component filter? If yes, what is the correct formula / way to do this?
Hi all, I am using the COUNT function to get the total number of invoices, PO, and line items that fulfill the conditions in the code statements. The problem is the KPIs I am using were created using COUNT functions, which makes it impossible to get the total numbers by nesting the entire code in another COUNT function. This gives the error message: Aggregate expressions cannot be nested inside aggregate expressions. Does anyone have an idea how I can resolve this issue? The code is added also.
Hello everyone, not sure if this is a bug but I am very new to knowledge models and views. I only worked with analysises beforehand and I am trying views for the very first time. I somehow added a record here. Not sure how, since I never pressed “Create record”. I tried to create an augmented attribute but it somehow failed. Anyways I am trying to clean up my mess now. This is the newly created record: It is autogenerated and now is included everytime I create a Knowledge Model based on that Data Model: I NEVER touched the BackEnd at all. When opening the DataModel in the preview section, it exists as a standalone table: But when I ppress “Go to Data Model” it does not actually exist in the BackEnd (obviously, since it doesnt exist).But how do I get rid of this record? It annoys me that it exists and I can not do anything about it… Thank you!Sincerely, a very confused new Views-User
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.
