1532445 - Match patterns with wildcard '* *' is slow to render List of Value in WebIntelligence and Qaaws 3.1 using a Bex query

• 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

• Qaaws
• Business Objects XI 3.1
• BW, Bex query

1. Run a webI report that contains a filter with match patterns
2. 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.

Customer has been advised by SAP support to check KB 1528869 and 1517091

01500202, 1500202 , KBA , BI-RA-WBI , Web Intelligence , Bug Filed