Welcome to the Celonis Community
Can't find what you're looking for? Ask it here!
Recently active
Hi everyone I have a challenge that I’m trying to figure out related to pycelonis.I’m currently trying to get the component values from a view using pycelonis. Unfortunately, I couldn’t find any information inside the documentation that can help me with this.It seems that the documentation only explains how to work with analysis or knowledge models. Does anyone know how to work with components of a view inside pycelonis?Best wishes!
Dear Celopeers, Currently I am trying to extend the simulation capacity of Celonis in the Machine Learning workbench. To do so, I need to import an event log through, I think, PyCelonis. I would like to use the UI of the Process Explorer in a premade analysis of Studio to define the activities and connections that are imported.The following link suggests this used to be possible within PyCelonis 1.7 using the ‘Share your selection’ URL. (Analysis: Pull data - PyCelonis) This appears like a very elegant and user friendly solution to me.However, I can't figure out how to do so using the newer PyCelonis 2.12. I did find out how to navigate to the correct space, package, and analysis through different IDs. But the Python methods attached to the analysis object created through .get_analysis() do not make apparent how to perform the filtered data extraction I alluded to above.Any ideas or references on how to do this? Thank you in advance, Bas
Hi All,I have created one column Month_Year in one of my tables which I am using for creating the analysis dashboard. The Month_Year column is of type Varchar and so when I am creating a drop-down component in the analysis rather than getting the Month_Year column in date order I am getting it in alphabetical order. Sure I know there would be answers to this query saying to change the datatype to date and then do the to_date function in the front end but in that scenario, I am getting unwanted things like day, time, hour, seconds and all. I only want the month and year to be displayed in the dropdown and that to in date order. Can anyone please help me on this query
Hello,I’m an independent consultant specializing in process optimization and based in the Netherlands. I often help clients adopt and integrate new tools to improve efficiency and am very interested in Celonis.I’m curious if there are opportunities for independent consultants like me to partner with Celonis. Specifically, I’d like to know if the partner program supports using the platform with clients and possibly providing training on the software.Could someone provide more details about the possibilities and requirements for such a collaboration?Thanks in advance!
I’m trying to build a Website journey with OCPM. I expect to have various objects like Web Object, Order Object, etc in the flow. Considering just the Website frontend, in case centric approach, to show the traversal throught the various webpages, I could imagine having the webpages as the activity, however when moving to OCPM, I’m wondering how the scenario should be modeled. Since (I assume) the webpage traversal would be events affecting the Web Object itself and there is a possibility that there is far too many webpages to manually keep adding to events, is there a better way of building this journey with OCPM?
Has anyone implemented JD Edwards P2P connector? I need to understand how it works and recomendations coming from real project experience.
I’m trying to add a total line to a table in Celonis, similar to a total line in an Excel pivot table. In my table, my first column is a dimension and the rest are aggregated KPIs. But my end user needs to see the overall total, too. Any thoughts?
I am trying to filter records using predefined filter assigning value thru parameter in popup view. But the value is not properly assigned to the filter. Its filtering everything and not showing any data. However filter works fine when i assign value in the filter. The value to the view thru variable is passed properly and I can see the value in text box.This works fine: FILTER "o_custom_DeathNotification"."DeathNotificationId"='58b22b1d-771b-4b1a-8937-9fb90d82b491'This doesn't work: FILTER "o_custom_DeathNotification"."DeathNotificationId"='${var_dn_id}'
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
Hi,I am working on a KPI (A), which is calculated based on the result from another KPI (B) but this KPI (B) should not affected by Dimension selections. Do you know if this is possible? Thanks
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 t
