cancel
Showing results for 
Search instead for 
Did you mean: 

Poor performance with "select filter value" F4 help on web

Former Member
0 Kudos
197

We've noticed very poor performance when bringing up the "select filter value" box (F4 help) on web reports. For example, when filtering on Profit Center, it will take about 2-3 minutes for the dialog box to appear, even though we only have about 600 profit centers. If a hierarchy is activated, it only takes a couple seconds for the box to appear.

We're running BW 3.0B SP25 on DB/2. We already tried implementing OSS note 808189, but that didn't fix the problem.

Has anyone had this problem before?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Jason -

Check out this post on sapfans.com

http://www.sapfans.com/forums/viewtopic.php?t=184956&highlight=

Former Member
0 Kudos

That post suggests changing the "Query Execution Filter Val Selection" field to "Values in Master Data Table", I will take a look and see if that makes a difference.

Former Member
0 Kudos

The infoobjects are currently set to "Only Posted Values", however, our business requirements require this setting.

Are there any other options for speeding this up? Perhaps on the database level?