Skip to Content

BEx variable and WEBI

Hi,

We have used WEBI to display the data to the end users. The source of the WEBI is BEx queries. We face the following issue with the BEx query,

In the BEx query(TST_QRY_MATERIAL), i have used the variable ZMAT_SO_MAN, its a mandatory input variable and is based on "select-

options".

When i execute the query in the WEBI i am not able to use select options i am able to use only interval. I mean i can select only from and to values, i am not able to use select-options, the way we use in our BEx analyzer. Any ideas gurus?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 04, 2012 at 08:33 AM

    When your Bex variable is "Select option" based, BO recognizes this as an interval. That's the reason your are getting that. If you want to select single values in your WebI query then your bex variable has to be either "Single Values" or "Multiple Single Values" based. BO does not support all Bex features. For example it does not support Suppress zeros, Conditions etc.


    Bex_Variable.png (40.0 kB)
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 10, 2012 at 05:51 PM

    Hi Guys,

    bad news - it's still the same with FP3 - I face the same problem.

    Alex

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 11, 2012 at 09:57 AM

    hi Lakshmi,

    This is the way it works. You have to pass same value in from and to both if you wanted to pass a single value.

    Regards:

    jitendra

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      OK for single values this is true - but what should I do if Iwant to chose a sub set out of a set of values (Multiple Single Values in Query Designer does not work in my context).

      Alex