Skip to Content

When talking about Transient Providers (for more info see What are Transient Providers?   See if you have BW inside your ERP System ) I am often asked, especially by administrators, “but what about performance?”

My usual answer is run a report using transaction SQ01 to test performance.

But after following some of the discussions in the other forums, I finally thought about using transaction RSRT inside your ECC/ERP system, which is the Query Monitor transaction.  This transaction is available in your BW system, and with enhancement package 5 you can activate BW inside your ECC, thus transaction RSRT is available.

1RSRTclassic.jpg

Above shows the RSRT transaction inside your ECC.  The “@” sign indicates it is a transient provider.

/wp-content/uploads/2013/08/2list_267598.jpg

Above is the result of executing the BEx Query against the transient provider.  It is a good way to test performance and then start using your BusinessObjects/BI tools against that query.

I also noticed other features of RSRT inside ECC:

RSRT BICS.jpg

The above shows running RSRT with the ABAP BICS feature selected.

BEx Analyzer.jpg

Above is the BEx Analyzer option.

/wp-content/uploads/2013/08/5infobroadcasting_267604.jpg

You can even run the report as a BEx Broadcasting and distribute it out that way.

So before using your ECC BEx Query against the BI tools such as SAP BusinessObjects Analysis, edition for Microsoft Office or SAP BusinessObjects Web Intelligence test the performance of your query with RSRT.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply