Question:
Hi,
We are seeing some very bad performance problems when opening existing query definitions in the Bex Analyzer. When you click on "Change query(Global Definition)" or just simply click on the "change query" button, it takes approx 27 seconds before you the query definition is fully displayed. (which is long)
The steps it seems to be going through are:
1. Lock the query against external changes
2. Reading query definition
3. Reading infoobjects
4. Authorisation check.
Steps 1 and 2 are where it is hanging and taking the most time.
Does anyone know whether these steps correspond to any tables and if so, which tables these are?
Thanks,
Allan
Answer:
What is the size of your BW Box ??
No. of users?
check to see if box is sized correctly.
if all that is fine - when was the last time basis ran br connect on the box
try same query with a test user ( auth - sap_all)
check different locations (different router) - sometimes network could be an issue.