- It takes longer to get the data return when entering the prompt Match patterns with Wildcard such as *smith*
- Performance returning data in Qaaws and WebIntelligence report with wildcard
- Business Objects XI 3.1
- BW, Bex query
Reproducing the Issue
- Run a webI report that contains a filter with match patterns
- Enter value using a wildcard such as *xxx*
-> it takes a longer time to get the data back
Even if search delegate is selected the data is not returned quickly
This has been logged as problem report : #ADAPT01500202
When development did check the bug they discovered that there was a bottleneck is in the BW BAPI layer. The logs show that our code is delegating the *xxx* search to the BW BAPI layer as expected. The log includes a query to retrieve all members with names and captions matching *xxx*. Our code makes two calls to the BW BAPI MDDataProvider.GetMember function -one to retrieve all members with matching names and one to retrieve all members with matching captions. EachMDDataProvider.GetMember call is taking around 20 seconds to return.
Therefore this was escalated to SAP support.
01500202, 1500202 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed