Filtering Key Figures in Query Designer

[Former Member]

Hi guys,

I know that it is not possible to filter key figures in Query Designer.

But is there a workaround how to handle this?

Thanks for help !

Regards

Stefanie

[Former Member · Accepted solution]

Hi Stefanie,

Yes, it is not possible to apply filters directly on Key Figures...

Instead, you can create Restricted Key Figure, with which you can restrict the key figures of an InfoProvider for reuse by selecting one of more characteristics, meaning you an see the Key Figure Values only to the selected characteristics ...

Please refer to: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/d0ef2b84-8c84-2e10-2080-f674a8755...

Hope this helps

BR,

Nikhil

[Former Member · Accepted solution]

Hi Nikhil,

thanks for your answer. I have created a restricted key figure but still I am not able to filter.

Here is an example:

Reaction Time:

01:55:14

00:15:44

02:36:56

etc.

Now I want to filter for 00:15:44 ... How an I implement this with restricted key figures?

Thanks for your help.

Best regards

Stefanie

[Former Member · Accepted solution]

I get it thanks for help 🙂

[Former Member]

Hi experts,

now I have a new problem, hope I get help again.

I have created a restricted key figure and for this a conversion routine (InfoObject Reaction Time). I implemented this routine by my own.

But now in the query i am not able to filter the value range.

Anybody an idea why?

Thanks a lot and regards

Stefanie