For the majority of queries, after having upgraded to SP8 (BW701), the ABAP-query coding was (re-)generated each time the query was executed by an (end)user, which caused annoying performance issues. Eventually SAP note 1528921 solved the above issue.

regenerate queries

regenerate queries

If you want to find out if this regeneration issue is occurring in “your” system, you should view the content of the RSRREPDIR table and check the GENTIME field. If the timestamp in GENTIME is not too recent for most entries, “your” system should be fine.

A big thanks goes out to Freek Geldof for his contribution to this topic