Skip to Content

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.

Step-By-Step
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
Infoprovider/! Infoprovider.

image

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.

image

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.

To report this post you need to login first.

3 Comments

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

  1. Witalij Rudnicki
    Infoprovider/!Infoprovider is a special query generated for usage in BEx WebAnalyzer for ad-hoc quering.

    Therefore instead of using RSRT you just use BEx WebAnalyzer for exactly the same InfoCube content browsing. Obviously the advantage of RSRT is all the tracing you can do for query execution.

    Cheers,
    -Vitaliy

    (0) 

Leave a Reply