Skip to Content

WEBI prompt


I have a BW BEx query which is used as a datasource for my WEBI report.

I need to create a prompt over the dimension(0GL_ACCOUNT) and the user will either input list of values or a range of values.

I am unable to achieve this using in a single prompt(both list of values and between), also if I use multiple prompt on the same dimension I am unable to use "OR" between these 2 prompts as the datasource is BEx query(only and is permitted)

Any ideas gurus?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 05, 2017 at 01:56 PM

    Hi ,

    As you know Selection variable is not supported in WebI .

    If it is primary requirement for providing Selection variable feature , then we can use Analysis for OLAP /MS Office .

    or as a work around you can create 2 optional prompts at webi .One for Inlist and other for Between with different texts(totally we will see 3 prompts at run time) and educate user to select any one of them ,. But this may not be good idea as sometimes users may select both prompt values .



    Add comment
    10|10000 characters needed characters exceeded