Displaying InfoProvider Contents using Tcode RSRT
The common method to display contents of an InfoProvider, is to right-click the Infoprovider in the EDW workbench (RSA1 screen) and choose ‘Display Data’. This technique is a bit tedious as one needs to search and select the necessary characteristics from the set of characteristics which make up the Infoprovider. This weblog is to provide information on a quicker way to view Infoprovider contents.
A faster way to view Infoprovider data without choosing characteristics is by using transaction code RSRT. The quick turn around time of this method in turn helps in reducing Unit testing time, in a typical BI implementation.
The below steps demonstrate this feature step-by-step:
1. Log-in to BI system and goto transaction code RSRT. In the selection for ‘Query’, enter the name of the InfoProvider in exactly the following format
2. Choose Query Display as ‘HTML’ and click on Execute.
3. The Infoprovider data (all key figures) is summarized in a single row and is displayed as a regular BEx Query output, in the next screen.
Now use the required ‘Free characteristics’ (these are all characteristics present in the MultiProvider/ Infocube/ DSO) to analyse the InfoProvider data.
Since we have chosen the Query display to be in HTML, it is a much faster way to view InfoProvider data as compared to right click and choosing ‘Display Data’.
Alternately, one could also use the BEx Query Designer to display the InfoProvider data in Excel. This is a standard feature of BI 7.0. In the Create Query Dialog box, choose name of the InfoProvider for which you would like to display data. This method will agian have limitations of viewing BI data in excel format.