Filter data source according to user input of Max and Min value for measure

[former_member354226]

Is there any way to have user input boxes of Max and Min value in sap design stdio application and based on user input of max and min value, the data source will get filtered ?

[Former Member · Accepted solution]

Pan, is your data source a BW query?

If so, you could use a variable in your BW query's condition and then write JavaScript for your input box to pass the value of the input box to the BW variable and refresh data source.

Edit: you would actually need two conditions in you BW query, with two variables (Max and Min).

[former_member354226 · Accepted solution]

Thanks Agata... 🙂

[TammyPowlas]

There are extensions that do this - see the SAP Analytics extension directory: https://analytics-extensions.enter.sap/

Something close to a range slider here: http://cdn.visualbi.com/wp-content/uploads/visualbi-extensions-for-sap-businessobjects-design-studio...

[former_member354226]

Hi Tammy,

Thanks for the reply.

Is there any way to implement this scenario using components that are available in Design Studio by default?

[TammyPowlas]

Personally I don't know how to do that; I wouldn't reinvent the wheel. I recommend a cost-benefit analysis - the time it will take for you to do yourself versus someone else who has already done it (including testing, etc.) - it may be worth getting a trial