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

PRO+

Content

Find more PRO+ content and other member only offers, here.

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.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.

-ADS BY GOOGLE

SearchManufacturingERP

SearchOracle

SearchDataManagement

SearchAWS

SearchBusinessAnalytics

SearchCRM

SearchContentManagement

SearchFinancialApplications

Close