This blog concentrates on how to use the Report to Report interface within the Design Studio. The Report to Report Interface (RRI) feature allows to call a jump from source application to the target application. In order to use the RRI feature, first it needs to be configured in the backend system. In this blog we will try to use the RRI feature with BEx queries in Design Studio .
Following steps gives a brief overview of how to configure the RRI from one BW query to another BW query in Design studio local mode:
- Create two Applications in the Design Studio – RRI_Source_test and RRI_Target_test. One Application for source query and second application for target query.
- In both the Applications, create a Data Source by connecting to BW system and use two different BW queries for each application.
- Assign the Data Source to the crosstabs in the Applications
- In the RRI_Source_Test Application, specify the target jump Application under the Preferences.
- Run the RRI_Source_test Application
- On the context menu of crosstab in the RRI_Source_test select the jump query.
Before I go into detailed steps , I want to thank my colleague Ravin Angara for his help and guidance on this topic.
Login into the Design Studio Client and create a basic Application (RRI_Source_Test) with crosstab component in it. Create the Data Source by connecting to a BW query. Drag and drop the required fields into Rows and Columns by editing the Data Source / Query in the Edit initial query option. Once done assign the Data Source or query to the Crosstab.
Similarly create one more Application (RRI_Target_Test) with crosstab by connecting to a different BW query.
Go back to the RRI_Source_Test Application, select Tools from menu – > Preferences and on the left side select the Application Design. In the same window on the right side the Application Design options will appear. At the bottom you will see the Report to Report Interface option, select the RRI_Target_Test from the drop down as the Jump to Application. Basically here we are selecting the Application to which the query jump will happen when we select a value from the source application. The selection parameter will be passed from source query to the target query and the necessary filters will be applied based on the parameter selection.
Now login into the BW system with the valid credentials and go to the Transaction code “RSBBS”. This is where we will configure the source query and target query.
Give the name of the query used in the RRI_Source_Test Application in the Sender Text box and click on the “Create” button. Maintain the Sender Query and Receiver Query names correctly.
Select the BW Query Radio button under the Report Type option and under the Report Option, give the query name used in the RRI_Target_Test Application. Once the source query and target query info is maintained click on the Apply button.
Once the assignment info is maintained you will see all the available BW receiver query information. To crosscheck your assignment simply select the sender query and click on Display or change to edit.
Go back to Design Studio client and if the RRI_Source_Test is already open, simply execute the Application.
In the runtime once the Application displays data in the crosstab, on the context menu of the crosstab you will see the “Jump to” option. Click on the arrow on this option to see the available receiver queries. Select the target Query from the list of available queries.
On the context menu remember what field or cell you are selecting as it will only display those fields in the target query application for e.g. if you are selecting EMEA region then the target query application will display values for all the regions located in the EMEA as shown in the figure.
We have successfully used the RRI feature within Design Studio in local mode by creating two application which are using two different BW queries and finally jumping from source application query to the target application query. This concludes the blog.