General Product Q&A

Here the amount is still in ascending order even after sorting it as descending.

Who knows it?Sometimes I get DPO like this: 466,243,595,672,831,872 daysFor example: one vendor, two invoices, sum of these two invoice is 0 €. I think it is a problem with the sum of 0 €. But how can I resolve it in the PQL formula?

Can any provide a sample Table-ABAP-Configuration.xlsx file

Hello,  Anyone knows how to reference array without keys (1. Value A2. Value B)or just a string ("Value A, Value B) in a outlook recipients module? I've tried several approaches but nothing seems to be working properly. I do not want to send multiple emails to single recipient (1 mail = 1 recipient). I want to send 1 email to multiple people in both "TO" and "CC" fields. It's improtant as we've got dynamic recipients list. Usually I end up with one of two errors: or  Best Regard,Mateusz Dudek 

I have started creating more of my use cases as "Views" and realized I am unable to use the "Generate PDF Report" action flow with them... Seems like Views are what will be the preferred destination for use cases premade and custom. I would like to be able to use them the same in action flows

Helo everyone,  I struggle with a topic that has came up twice now in different data models:. Following scenario with the folowing data model:[MSEG] N --- 1 [MARC]1 --- N [MARC] I have a frontend table with different MARA and MARD information. It showcases each Material, their storage location inside a plant and several other information. Now I want to add a certain field from MSEG: The last time a material was moved inside a storage location (inside plant). Now I have to use a PU-function since MSEG and MARD are not connected, only through the MARC-Table. The issue is, that MARC aggregates all data on the plant level, but I want to have the date on storage location level. Example: Material A is stored in storage locations 10 and 20 in plant X. (Inf

Hi everyone, i got following activity table structure:Item ID (case ID), Activity (activity), Timestamp (timestamp), Item position ID One Item ID can have multiple Item Position IDs; so 1:n relationship. Some activities tend to repeat themselves for each distinct Item Position ID, example: Item 1, Activity A, 08.08.2023 10:00, -Item 1, Activity B, 08.08.2023 10:01, ItemPosition 11Item 1, Activity C, 08.08.2023 10:02, ItemPosition 11Item 1, Activity B, 08.08.2023 10:03, ItemPosition 12Item 1, Activity C, 08.08.2023 10:06, ItemPosition 12Item 1, Activity D, 08.08.2023 10:07, - I want following throughput time calculation to be considered for each Item Position ID, which i am not able to generate.   CALC_THROUGHPUT (  FIRST_OCCURRENCE [ 'Activity B' ]  TO  FIRST_OCCURRENCE [ 'Activity C' ] ,   REMAP_TIMESTAMPS ( "Activit

Is this official Celonis email address: partner@celonis.com from which you are sending the newsletter to your customers?

There is no sign-up functionality for Celonis for Consulting Partnership. I signed up but as a Guest and no feature to change from Guest to Partner signup. Can you please kindly change my sign up to a Partner in the name of Sceamdo Technologies? Thank you

Want PQL Query for Paid Early.

How to force load empty csv/xls files using pycelonis? Its a client requirement

Hi everyone! I am trying to set up triggers on my sanbox enviroment but It does not has that.. Does anyone know why?

コンポーネントのアクティビティエクスプローラーで検索されるアクティビティを固定したいです。 通常の状態だとアクティビティエクスプローラーのアクティビティを選択しても、パッケージを移動すると値がリセットされてしまいます…

Hence we would like to delete the rest of the components in Business View.But Delete option is not available for them. (We tried copying Business view into another and delete the other components to keep only Execution gap list(Inefficiencies)) Please advise. Regards,Deepti

How to apply Line break in KPI List for each KPI..?

Hi everyone,  I am trying to set a Display Rule for a KPI List in a View in Studio. I want to use the Display Rule to set the background color of the KPI based not on a fixed value, but rather on a dinamic input coming from a table in the data model.  I wanted to configure this input using PQL just as it is done with variables in a regular analysis, but I have not found such an option in Views or Knowledge Models.  I would want to know if it is possible to work in an analog way to an analysis in studio, defining a variable with input written in PQL, and then using such variable as a parameter in the Display Rule YAML code.  is that possible? Thank you!!!Best regardsJavier

I am using this formula but I know that is not right. : AVG(PU_COUNT ("_X_INC_CASE", ROUND_DAY("_X_INC_SECONDARY_ACTIVITIES"."_EVENTTIME"), KPI("Efficient Conditions_ All Reopen") = 'Efficient')) The X_INC_CASE has unique values and the X_INC_SECONDARY_ACTIVITIES has all events

Innovation Generation 💡  What do you think is the best way to map and measure scope 3.1 material emissions?Comment your thoughts and ideas below! Kind Regards,The Celonis Sustainability Team 🌍

Embracing Sustainability - The Celonis Training Academy  🏆  The Celonis Sustainability Team invites you to further your expertise surrounding sustainability topics by embarking on a learning journey with our training academy. The two most important courses to complete to further your knowledge on sustainability topics are the Sustainability Base Camp and the Sustainability Bootcamp. The course will help you to improve your expertise on sustainability and apply it in your day to day job

I am looking for the way how to apply in Action Flow Alerting Mails the condition "apply different color classes based on percentage ranges"? It needs to be dynamic where the colors will be changed based on value. Thanks a lot!!

Are there customers that are using both BI tools and Celonis in their environments? If yes, how do they use both tools? Thank you

Does Celonis offer capabilities to simulate business processes performance? If a business process is found to be in-efficient, does Celonis offer capabilities to simulate an optimized version of the same process?

Hi all Celopeer, I would like to ask if there is a level of job seniority required to take expert badges.For example, if the company where I work in would like to become a Celonis partner could I be one of the Value Assesment Expert even though I started working two years ago and I am a Business Analyst figure?Thanks

how can we push the OLAP from one instance to another instance without having to replicate the logic written on the back of the olap in action flow.

Hi everyone,  I am building a View, where I want to list some KPIs from my Knowledge Model on top of a table. For that purpose, I first chose an Attribute List, as I see in the documentation that it can take KPIs as Input. Then I tried a KPI List instead, with the same KPIs from the Knowledge Model, and I noticed that the numbers displayed in each KPI are considerably different, when I use one component or the other. (I checked it and the numbers on the KPI List are right, and differ greatly from those in the Attribute List). Does anybody know what the cause of this discrepancy might be?  How do Attribute Lists function overall? When should I use them? I was not able to find further information about that in the docs. Thank you very much! Javier