Product Q&A

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, 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

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 

how to change the nanme

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:  

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 

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).

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: 

Hello everyone, we currently want to display the Bill of Materials Hierarchy in Celonis.The issue with that is, that the hierarchy is not present in any SAP-Table. But instead in the related tables MAST and STPO.I have the MAST which has BOM and Material (component) relationship which needs to be traversed to STPO with the BOM-Nr. to identify the compenents and each component may be split into sub materials and new BOMs which needs to be looked up in the MAST for its BOM again and it goes on and on. Up to 4 levels deep.So the 4th level has no relationship to the first level. This recursive issue with inputing the results from MAST into STPO into MAST into STPO… is not possible in the FrontEnd (I assume).I am going crazy with knowledge models and action flows, the documentation is absolutely horrible. So it probably needs to be done in the data model itself. Additionally we want to add the Vendor from open orders f

Col 1 and Col 2 are the two columns in the OLAP table I'm attempting to generate.Where Col 1 from Table A can have 0 or many values associated from Col 2 of Table B.The cardinality of Tables A and B is (1:N). Currently in place-Values in Col 1 of Table A that have no value associated with Col 2 of Table B are excluded from the OLAP table. What I hope to accomplish-Values in Col 1 should be shown, and values that have nothing related with Col 2 of Table B should have (Null/-) displayed in front of them. The Join Functionality of Celonis does Left Outer Join, and considers the (N) side table (Table B) on the Left Side implicitly, while I want it to be the other way

I am working on creating views and created Filter check box with on click option , but  Select All checkbox is not coming at right side.Below is the YAML I am usingid: dropdown-list-60b99e03-3e73-459b-87be-9d51464f35type: dropdown-listsettings:  data:    columns:      - id: c3c70431-d853-4ff1-95ac-50bc70a226ff        order: 100        onClick:          update:            selection: multiple            variables:              - name: target_attribute_name1        attribute: TABLE_1_2.TARGET_ATTRIBUTE_NAME        displayName: ""

I am working on a script in PyCelonis to search assets and compile a list of the data models/Knowledge models that the assets are using, with the aim of non manually figuring out which DM/KMs are currently in use by production assets.  Using PyCelonis I have been able to navigate down to the asset level and find lots of information for each asset, but have so far not found anywhere that you can identify the DM/KM an asset is built on. The “.dict()” function provides a lot of information and I thought would be the intuitive place to include this kind of information but it is nowhere to be found, except when the asset is a view and the KM gets referenced in the yaml code that is provided in “.dict()” Does anyone know if this is information that we can pull from PyCelonis? And, if so, how to find this information on the asset level? Thanks in advance for your help!

I am trying to make an action flow which gets triggered when the data load is more than a day old i.e., when the data load failed, and we are unaware of the failure. Current problem is that I am able to get the last refresh date from event log which is the MAX of the time stamp but to put a trigger to see if the MAx is more than a day old, the FILTER function in general does not allow aggregations. Is there a way out of it or any other path that can be taken to create an action flow to trigger a mail if the last refresh date is more than a day old.

Hi, I am trying to query data in Celonis module in the Action flow . However, I have requirement to split the data into two paths and then prepare a csv and then merge it back into one using a text aggregator. Is there a module that can merge paths in action flow. Or is there a way to split data based on filters and merge or append it into one file

Hello Community,I'm currently migrating my analyses to the new views and have encountered a “problem”. I hope you can help me solve it:Within “Analysis” the table component has the function “calculate share in percentages”.Hee it is possible to calculate the percentage of a column per line, also what percentage of the total for a column a line represents.How does it work in the new views?Thank you so much for help.Best, Thomas  

Hello crowd,I need your swarm knowledge for this issue:I selected July + August in date picker, which is 9 calendar weeks.My objective is to calculate the average sales orders per customer per calendar week.You can see it in my screenshot. One customer per line, count of sales orders and count of calendar week where sales orders are created.The challenge is, that not every customer is ordering in every week.My question is: How do I get the total number of calendar weeks (9) from the date picker in my formula?I would like to divide the “number of orders” by the “total calendar weeks from date picker” and not by the calendar weeks in which the order was placed.Best, Thomas   

Hi, I am just learning about Trigger with Action Flow in an academy.But I am in a trouble how to use a trigger for Action Flow that I made in KM.After making this, I tried to use it but It could not be shown in a setting field.How do i solve this problem?  

Hello, I have received the data set I want to analyze in several CSV files (due to the row limit of 1 million rows). Now I would like to merge this split CSV data set in Celonis, but I have not found the function to do so. The data set is structured in such a way that CaseID, Activity, Timestamp and other case information are each in one line, as can be seen in the screenshot. Thank you for your help.Edit: Sorry for posting in the wrong category, it looks like it can't be changed.

Hey, I wasn't logging into celopeers for some time, congrats on being first! :)Celonis defenitely should send you a t-shirt or something else! Thanks for engagement, probably I'll also return to helping some people here.

We are working on linking the ordernumber from Celonis to a link in SAP perferably to 4hana. Does anyone know of a way we could automatically generate such a link?

Hi Community, while using Send Email action in Views table, there are 2 options:Launch default email program and Send from serverbut second option is disabled and status is ‘In Progress’ (unable to select it and proceed with this option). what’s the meaning of this? is it a permission issue or what?please check attached image as well. 

Hello,  do you know if it’s possible to hide/unhide tabs in a new view as a business user in apps?  

Hi Everyone. I am trying to create a table in Data Jobs, but I want two zeros infront of a number.  nothing I try works? what could the issue be? See ‘00’||”COL-1”