How To executing a BW Report using TCODE RRMX. RRMX is used to start the Business Explorer Analyzer use for Excel connectivity with BW server. It is use for viewing the Query Output or seeing the Workbook.
Heres step by step how to execute BW Report using RRMX :
Type transaction code RRMX in the
and press Enter. The system will open Excel in another window.
If not there already, drag the BW toolbarupward to the Excel toolbar area
as shown above. This will only need to be done once.
If not already done, click on the
button from the BW toolbar and click on “Suppresswarnings from server”. This will also only need to be done once. Once this setting is made, the “Suppress warnings from server” setting will be indicated with a
next to it .Click
button and select Workbooks (shown below).
Click
next to BW Reports for Departments to display the report directories.
Click on the desired report name (ex: Budget Request) to highlight it. BW queries are indicated with the Excel symbol.
Press
button (highlighted above) to select the report.
Enter your data in any unpopulated fields on the selection screen (ex: Fund, Version, etc.) as
shown above.
Click on the
button to clear any pre-populated field (ex: Fund Center).
Press the
button.
Enter the desired value(s) for the selected field (ex: fund center 3110200000) using the “Single vals” or “Ranges” tab.
Press the
button [shown above]. At this point, if desired a variant can be created to save your report settings.
Press the
button [shown above].
The above screen shows the default settings for the Budget Request report for the entered budgeting fund center.
