List Of Values(LOV) not displayed for a object in the Query Filter

[Former Member]

Hi Experts,

I have created a BICS Connection by Bex Query,

I have built a WebI Report on top of BICS connection, by using Bex as a data source.

When I select the all objects and Run the report, then the report is working fine.

If I select any object and placed it in Query filter than the List of values are not displaying,

It shows as follows

Use search criteria to retrieve values.

The search is case sensitive. Here are examples of search criteria.

Search = a* -> Retrieve all values starting with "a".

Search = *a -> Retrieve all values ending with "a".

Search = a*a -> Retrieve all values starting and ending with "a".

Search = a*a* -> Retrieve all values starting and containing one more "a".

Please find the attached screen shot for reference.

Kindly suggest me regarding this.

Thanks & Regards

----------------------------

Karthik.Morishetty

[Former Member]

Hi Karthik,

This behaviour is bydesign when you build a report from BEx queries, LOV (List of Values) are delegated for characteristics.

This behavior is by default and cannot be configured.You are therefore required to enter search patterns for the values you want to select for any prompt (query filters) on BEx characteristics.

This is an ongoing request in SAP Idea place for enhancement.

For more info please go thru this link..

https://cw.sdn.sap.com/cw/ideas/5097