Generating Queries issue BW

Due to an issue in one of the latest support packs (in our case SP08), many queries were being generated on each call of an enduser.

This causes major performance issues in reporting in our system. Mainly in generating the variable screen and the (non) usage of cache for these queries.

Wonder if this is happening in your system? Check on table RSRREPDIR and check if the timestamp in field GENTIME is not too recent for your active queries.

Also in the system you will see if you trace the call of the report that tables D010TAB and D010INC are accessed many times.

Implementing note 1528921 helped out on this (Queries regenerated each time during

execution). Please be aware!

Query tables BW

Below tables are relevant with respect to query elements.

RSRREPDIR – Directory of all reports

RSZCOMPDIR – Directory of reporting components

RSZELTDIR – Directory of the reporting component elements

RSZELTTXT – Texts of reporting component elements

RSZELTXREF – Directory of query element references

RSZOPRATXT – Texts of the formula operators

RSZCOMPIC – Assignment reusable component to Info Cube

RSZSELECT – Selection properties of an element

RSZCALC – Definition of a formula element

RSZGLOBV – Global variables in reporting

RSZELTPROP – Element properties (settings)

Analysis on these tables can be done via ANALYZE_RSZ_TABLES program in SE38.

It might be wise to clean up especially in large BW systems to increase performance of generating query elements like variable screen in Bex Web/Analyzer.