on 06-04-2012 7:42 AM
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?
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Guys,
bad news - it's still the same with FP3 - I face the same problem.
Alex
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.