cancel
Showing results for 
Search instead for 
Did you mean: 

Query Definition Filter Value Selection

Former Member
0 Kudos

Hi BW Experts,

This is regarding a navigation attribute restriction while defining a query.

When we are defining a query on multiprovider / basic infocube and trying to put a restriction from the context menu on a navigation attribute,the screen is hanging and the fixed values for restriction are appearing after 5 to 6 minutes.

While it should not take so much time, it should ideally display it in few seconds.

This is happening for all the navigation attributes.

Please share if anybody has faced this problem before or any suggestions regarding any settings at Infoobject, Basic cube or Multiprovider level.

Any relevant input would be highly appreciated and appropriate points would be awarded.

Best Regards

Praval Trivedi

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

See if this thread could help you out in some way.

Former Member
0 Kudos

Hello Praval,

it is BW3.5 or BI7.0?

Webreports or Excel?

If Webreports check the command "Read Mode" in WAD -> NAVIGATIONBLOCK

-> Master Data Table = fast

-> Dimension Table = medium

-> Posted Values = slow

Check the InfoObjects

-> Business Explorer

-> Query Def. Filter Value Selection

-> Query Execution Filter Val. Selectn

regards Sven