Skip to Content

Report to Report Interface Linking (RRI) Linking in SAP Business Explorer (BEx)

This document explains step by step process on how to link two reports .i.e., opening one report from other report in SAP Business Explorer –> Analyzer.

Step 1 : Go to Business Explorer –> Query Designer

/wp-content/uploads/2013/11/0_322997.jpg

Step 2: Create two BEx queries in the BEx Query Designer,

       Here in this case, I have taken Query Linking as the first query and Query Target Linking as the second Query

       The below screen gives the snapshot of my first query where Plant and Actual Sales are my Dimension and Key Figures.

/wp-content/uploads/2013/11/1_322998.jpg

  The below screen gives the snapshot of the Second query where Plant and Target Sales are my Dimension and Key Figures.

  Note: In this case Plant is my common object in both the queries to link from one report to other

/wp-content/uploads/2013/11/2_322999.jpg

Step 3: Go to SAP Front End –> SAP Logon as shown in below screen

/wp-content/uploads/2013/11/3_323012.jpg

Step 4 : Pass on the Logon Credentials to connect to the BW System

/wp-content/uploads/2013/11/4_323013.jpg

Step 5: Enter the Tcode rsbbs  as shown below and press Enter.

/wp-content/uploads/2013/11/7_323054.jpg

Step 6:  The below screen is the Sender/ Receiver Assignment window where linking of two BEx queries can be done.

            Enter  or select the query from the drop-down list as shown below.

  Note:  Sender:    In this case my first BEx query .i.e.,  Query Linking is the sender as it sends the parameter.

            Receiver: Second Query as it receives parameter from the first query.

/wp-content/uploads/2013/11/8_323055.jpg

Step 7: After selecting the Sender, click on Create as shown below.

/wp-content/uploads/2013/11/9_323065.jpg

 

Step 8: The below screen shows how to assign the Receiver.

            In this case, my Target System is Local and Report Type is BW Query and Receiver is the Second query i.e., Query Target Linking .

                      

          

/wp-content/uploads/2013/11/10_323064.jpg

Step 9: Select Assignment Details tab as shown below.

/wp-content/uploads/2013/11/10_323064.jpg

Step 10: Select Type as InfoObject (as it is InfoObject in the BW) and Field Name as Plant.

The below screens shows the Receiver objects Assignment.

Here I need to link from first query to second query, As the first query links the second query based on selection of the dimension Plant

/wp-content/uploads/2013/11/12_323118.jpg

/wp-content/uploads/2013/11/11_323101.jpg

Step 11: Now Go to Business Explorer –> Analyzer as shown in below screen.

/wp-content/uploads/2013/11/14_1_323123.jpg

Step 12: Go to Add-ins –> Open Query –> select the query. In this case, Query Linking

/wp-content/uploads/2013/11/14_2_323124.jpg

/wp-content/uploads/2013/11/13_323119.jpg

Step 13: Select the Plant as shown below Right click –> Go to –> Receiver object (Query Target Linking)

/wp-content/uploads/2013/11/14_323125.jpg

Step 14: As per the selection of the plant in the first query, it opens the second query report.

            (Plant 5 is the selection in this case)

            Hence I can see my Plant wise Actual Sales in the first report and when I click on  any particular Plant, I can see my Target Sales for the selected Plant.

     /wp-content/uploads/2013/11/15_323135.jpg

Hope this document helps,

Thanks &Regards,

Shivani Yemula.

To report this post you need to login first.

6 Comments

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

Leave a Reply