Skip to Content

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

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 ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Mar 30, 2017 at 10:45 AM

    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).

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 30, 2017 at 09:18 AM

    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-vbx-user-guide.pdf

    Add comment
    10|10000 characters needed characters exceeded

    • 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