Skip to Content
0

SAP BO Webi report List of Values displays message

Nov 24, 2017 at 07:05 AM

45

avatar image
Former Member

Hi,

I am using BICS connection for my Webi report to get result from BEx query instead of using Universe in Webi report, everything works fine but while refreshing webi report the LOV i.e. list of values for each and every dimension object whether I keep in Prompt or in Query filter shows message in the LOV instead of displaying values in LOV.

The only option is to type * to retrieve all records or else type any character starting or ending with * like we do for Match Pattern operator.

Is there any setting which can remove such messages from LOV and work in normal way of displaying values in LOV instead of displaying such message and user typing * to search.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Nov 24, 2017 at 09:22 AM
0

This is by design. LOV's are not automatically displayed if Prompt is Optional.

If you want to display automatic then you need to either make the prompt mandatory or just go for search option in LOV.

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Amit,

In spite of keeping prompt as mandatory, still it is displaying same message in the LOV.

In below screenshot, OPCO is kept as mandatory, but still it shows message in LOV.

mandatory-lov.jpg (64.7 kB)
0
AMIT KUMAR
Nov 24, 2017 at 11:03 AM
0

Sorry my bad. LOV's are loaded only for hierarchical objects.

Check attache document link to understand the prompt behaviour.

https://archive.sap.com/documents/docs/DOC-63871

Share
10 |10000 characters needed characters left characters exceeded