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

Question

Selecting top X cases

Forum|Forum|6 years ago
July 9, 2019
5 replies
16 views

+1

david.werner
Level 7

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

V

viana.kalve11
Level 0
Forum|Forum|6 years ago
July 11, 2019

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

Best regards, Viana

Like

D

+2

david.beche12
Level 1
Forum|Forum|6 years ago
July 11, 2019

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