Hi everyone,for our development data model we would like to dive into our top X (e.g. 100) of open development projects in regards to their expected value. Currently I only know the function for an OLAP-table to show a limit number of rows. If we filter on certain areas/regions/plants this option remains, always showing the top X for the current selection. But we need additionaly KPIs above the table as:Total expected value of the top X projectsCertain Process-KPIs like (Average development loops per project) etc.Now Im searching, if there is any functionality to put a component filter or sheet-filter that we respect only the top X projects of the current selection.This might be interesting for everyone who wants to have a look/comparison within their top X cases.Best regards,David

Selecting top X cases

Hi everyone,

for our development data model we would like to dive into our top X (e.g. 100) of open development projects in regards to their expected value. Currently I only know the function for an OLAP-table to show a limit number of rows. If we filter on certain areas/regions/plants this option remains, always showing the top X for the current selection. But we need additionaly KPIs above the table as:

Total expected value of the top X projects
Certain Process-KPIs like (Average development loops per project) etc.

Now Im searching, if there is any functionality to put a component filter or sheet-filter that we respect only the top X projects of the current selection.

This might be interesting for everyone who wants to have a look/comparison within their top X cases.

Best regards,

David

Page 1 / 1

Hi David,
unfortunately, this is currently not possible. Youre welcome to post this idea as a feature request in the forum

Best regards,
Viana

Hi David,
I think this can be solved with a new PQL function we will release in a few weeks on the IBC. With this function you can index rows based on a value, and then use this index to filter.
If you are on CPM4, Im afraid you will need to wait for the next Release to also have access to the new function.
Best,
David

Hi,
thanks for your feedbacks and as we are on prem, I think we will have to wait a bit then and think about some work arounds

Is there somewhere an update-list about new PQL-Expressions/general functionalities that are added in the IBC?
Best regards,
David

Hi,
Is this feature available in PQL now?
Best Regards
Mukesh

Hi Mukesh,

yes, you can use the INDEX_ORDER function for this. Check out the documentation on your help page for some examples.

Best

David

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN