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

SAP Knowledge Base Article - Public

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

Symptom

  • 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

Environment

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

Reproducing the Issue

  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

Cause

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.

Resolution

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

Keywords

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

Product

Crystal Reports 2008 V0