Q
Problem solve Get help with specific problems with your technologies, process and projects.

Measuring performance of queries/workbooks

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?

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.


This was last published in March 2002

Dig Deeper on SAP business warehouse

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchHRSoftware

Close