Skip to Content
0

Enable Filter causing performance issue in report using query as filter

Jan 11 at 09:02 AM

31

avatar image

capture1.pngcapture2.png

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.

Regards,

Kunwar

capture1.png (15.9 kB)
capture2.png (37.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Tammy Powlas
Jan 11 at 10:28 AM
0

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

Also see this SAP Note: https://apps.support.sap.com/sap/support/knowledge/preview/en/2435721 https://launchpad.support.sap.com/#/notes/0002435721

Share
10 |10000 characters needed characters left characters exceeded