We run BW 2.0B on AIX/ORACLE. As part of implementing global usage of one of our BW systems, we're using standard SAP monitoring tools to measure performance of Queries / Workbooks etc. We are measuring how much time is spent in BW as opposed to the ITS, Bex, network etc.
One of the problems we have is determining the relationship between the Query name (as viewed from BeX - the 'real' name and the technical name), the SAP generated name for the query - something like 3HHOPT... - and the name of the generated program - similarly, a SAP generated name.
Have a look under the Technical Info button on transaction RSRT for a view of various different names. Any time I change (via BeX or Transport) a Query or Workbook, one or more of these names change.
What is the relationship between the Bex Query Name (as in RSRT) and the name of the generated program, and does anyone know what tables I need to examine to go from one to the other?
The intent is to write an ABAP (or just SE16 if its simple enough) to provide a lookup.
Monitoring and measuring complete end-to-end, query execution statistics is quite a challenge. There is not one single place that does the trick. Take a look at the table, RSRREPDIR that lists Query Name and ID (as seen by RSRT transaction) as well as the name of generated program that actually do the work.
Dig Deeper on SAP Business Warehouse
Related Q&A from Naeem Hashmi
Where could I find something like "best practices for update rules"? Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.