General Product Q&A

Hi Celonis Team, Do we have an option to calculate the approximate time to be taken before extracting data from external sources /tables ? It will help us to plan the time accordingly and if needed, to skip the mammoth data and continue with rest OR schedule specific tables extraction during non-working hours. Attached example: DD03M takes a day to complete the extraction. Log file21191080 151 KB

Hi, In some cases, the calculation of certain KPIs has to be done using PU_FUNCTIONS. However, as these function do not consider the actual analysis filters, the values calculated might not be the expected. Although I agree that not taking into consideration the current analysis filters is quite useful, I believe that it would be a great improvement to have the possibility to consider also the filters. Best Regards, Bruno

Hello Community, I am playing around with the backup content function for Celonis analysis. https://python.celonis.cloud/docs/pycelonis/en/latest/notebooks/99_Use_Case_Version_control.html#Create-backups-of-all-analyses-that-are-published-in-separate-workspace-directories While investigating, I realised that you have to store your file locally, before you can push it to Git, or AWS S3. I was wondering if anyone tried to directly send the backup to S3, or Git?

Dear all, in the past 11 months we implemented several data models from the content store now facing the following issue, that the content store evolves over time but being a complete black box for us, which I would like to describe with a short example: We implemented PTP almost one year ago. As the content/app store is enhanced over time we now face the issue, that we do not know, if there happened any update to the data model / basic analyses. E.g. we found a new basic analysis (Three-way-matches) which was not available when we initially implemented the data model. After downloading we noticed that our data model is missing tables for this new analysis meaning that there was also an update to the data model. As there are 20++ analyses for certain data models it is impossible to track manually on a regular basis, if there were any new analyses added or if further if there was any adjustments to existing ones. Additionally, as the data models are provided seperately, we have no insig

Hi, I have got the feedback from our users that they miss the select/deselect all feature in the attribute selection, which has been removed with release 4.5. They are not entirely happy with the invert selection feature as replacement. Could you consider including it again? Even if redundant, I think the users would appreciate to have the choice with which feature they prefer to work! Thanks, Stephanie

A few months ago it was mentioned that user/analyses stats and usage would be coming to the IBC. From the SaaS hosted version, this information is available and it would be nice to see this implemented in the IBC. Any update on this?

We have seen that there are some of the KPIs which has to be recreated in different analysis , may be becuase of data security. Role based access etc. Wouldnt it be nice that we have an App as Global KPI where we can drag and drop the KPIs which are used in different analysis and control where we would like to manage it. With that, any changes done to KPI is reflected across different analysis. This removed redudance of work, eliminates human error. Also managment dashboard and operation dashboard has the same calculations of the KPI.

Hello Celonis Development Team, Thank you for developing such a fantastic product. . I am a big fan already. Please share your opinion on having the following new features: Button - An option to show or hide one or multiple components. This will help us use the space for more innovative analyticsButton - An option to change the chart type of an existing component.Charts - The Series color mapping - options are limited and apply to all the series points. Instead, we should have a free code window wherein we can put codes to calculate color thresholds.The grid to put any component on the screen should have small steps giving freedom to arrange components more aligned. Thank you Regards, Sachin

Hi Celonis Community, were currently using Celonis 4.5 and have a large number of projects. At this point it would be very helpful to be able to search for a certain project. Unfortunately the search only supports folders, analysis and data models within the projects. Have I overlooked a way to do search projects? Otherwise Id appreciate some feedback if others would find this helpful as well. Best, David

Hi everyone, we currently face the following issue while analyzing a product lifecycle. After a development project we added a sales activity, holding the sales volume. Showing the timestamps of that activity on the x-axis and the volume on the y-axis, we receive the development of the product. This leads to the issue, if there are no sales in certain months, those months are not shown on the x-axis, meaning a year with sales each month is represented 12-times in the chart but a year with sales in only 2 months is represented only twice. This makes it impossible to read out trends on a case level. As the dimension formula is a regular (ROUND_MONTH(XXX_ACTIVITY.EVENTTIME)), there could be a checkbox to fill missing month between the highest and lowest available month. Best regards, David

When working with data jobs transformations; specifically going through them to edit a field on multiple transformations, it would be nice that once you make an edit, save the transformation, then have the ability to click on a Previous or Next button to move to the transformation before or after the current one without having to go first click on the back button, then hunt down the next transformation that you want. Ive included a screenshot of what Im suggesting. Thanks! -Dallas PrevNextTransformation.png1672776 58 KB

Issue: As we are building more and more dashboards we realize that some dashboard sheets are printed and spread, for instance in Obeya rooms. However, there is no way to include the applied filters, unless you make a screenshot, and therefore it is unclear what the printout represents. Feature request: Include the applied filters either in the print version, or make them available via a macro such that these can be added in a text field to be added to the dashboard sheet, and therefore will show up in a printout of the dashboard sheet.

We have connected Celonis to our central data core. This means we have data of over 700 processes in one generic table structure (case, step, process, client, etc.). However, this also means that if we want to have different case notions (for instance one analysis has a process as scope and hence case=case, while another is focusing on customer journey where case=client). Currently this means we have to load in the data twice (or more), with different activity/case notions set. This means duplication of the data. It would be nice if this setting could be data model independent (or: one data model has several case/act notions from which the dashboard can select one). Im aware of the process explorer option to change the activity attribute, but my request/suggestion is also concerning the case notion.

Hi everyone, with an increasing number of datamodels there might be an increasing connection between the data models for certain aspects. With the functionality of a button, you are currently able to jump between certain analyses even between different projects/data models. Still many data models use same base tables, like customer/material/ or other information. In many cases a complete end-to-end process cannot be covered within a single data model in a reasonable size/complexity of the data model. Thats why most of the times Order/Development/Planning/Production/Accounting/ are covered within seperate data models, even though there are information that are used in all of those data models. Would it be possible to enhance the functionality of jumping between analyses with matching certain attributes between the data models (easiest way would be if the same tables/attributes are available) to keep the filters without manually re-selecting them in every analysis you jump into? That wou

I often export results: to Excel, PDF of PNG. However, even more often I make screenshots/screen clippings of charts/items to paste in e-mails, presentations, notes, etc. It would be really neat if the visual representation of a component (/sheet) could be copied to clipboard as an image to be pasted later on.

Hello, Sometimes we struggle that how we can define activity correctly. Thats why we search for more data driven approach to define activities. For example, for change activities , we get count of changed fields and , then evaluate if it gives any inside or not. As a summary we search for more data driven, automated way for activity detection. Could you please share with your ideas ? Best Regards, Vahide.

Today I loaded the BPIC 2017 event log and noticed that although the event log contains both event and trace level attributes, Celonis flattens all to event level attributes. Feature request: XES import results in both an activities as well as a case table. Minor feature request: support for gzip-ed XES files (BPIC17 is 560Mb as XES XML file, but less than 30 Mb as xes.gz, something you notice when youre working from home).

Currently axis ranges can be set to automatic or manual. Issue: What I observe is that the axis range is determined on the >visual< bars/dots/etc. However, this is confusing as scrolling causes the axis to dynamically change. Proposal: Add a third option which either sets the scale to all data points visible and not. Alternatively, but less user friendly in some use cases, allow PQL in the manual ranges (MIN/MAX() would need to be added by the user manually and in sync with the displayed KPIs so not that user friendly.

Currently when adding dimensions/KPIs in the code editor there is a list with PQL functions and a summarized explanation of the feature. It would be really helpful if there would be a direct link from this summary to the Celonis help documenation with usually more extensive explanations and examples.