BEx variable and WEBI

[lakshminarasimhan_n4]

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?

[former_member184594 · Accepted solution]

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.

[lakshminarasimhan_n4 · Accepted solution]

Thanks. its sad that select options are not supported in the WEBI. any other work around?

[former_member188911 · Accepted solution]

I don't know of any actual workarounds for the select options but with FP03 the suppress zeroes + other features will be introduced (BICS only). http://scn.sap.com/docs/DOC-27554

The objective is to gradually expand the supported features but this takes time and testing.

The good news is that FP03 is in Ramp-up and soon should be officially released

Thanks!

Simone

[Former Member]

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

[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

[Former Member]

Hi Guys,

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

Alex