Showing results for 
Search instead for 
Did you mean: 

Enable Filter causing performance issue in report using query as filter

0 Kudos


Hi Team,

I have a query which is using another query in variable of type replacement path.(capture 1). Now the issue with this query is when we enable the 'Query filters' is goes to long run time and finally result in 'TIMEOUT' . Alternatively if we click on the Information tab it goes to error stating 'BICS_PROV_GET_EFFECTIVE_SELECT' takes lot of time and going to dump.



Accepted Solutions (0)

Answers (1)

Answers (1)

Active Contributor
0 Kudos

Hi - you have tagged this 2.4, which SP? Which version/SP of BW are you using?

Also see this SAP Note: