Jumping to a Web Address from a BEx query
SAP BI 7.0
This paper gives a clear picture about how to assign a Web Address as a receiver to a sender query in the BI system. Through this document I have tried to explain the steps involved in this process.
Author: Akella Kameswari
Company: Deloitte Consulting
Created on: 25 March 2012
Kameswari Akella currently works at Deloitte Consulting on SAP BI/BW.
The report-report interface allows you the flexibility to call a jump target (receiver) online from a BEx query (sender) within or outside of the BI system. Queries, transactions, reports, and Web addresses can be jump targets. This paper explains the steps involved in assigning a web address as a receiver to a sender query in the BI system.
There is a need to search for information about a product in a query in the Internet. To do so, jump to the product on the Web page of the search engine Googleä using the context menu.
To illustrate this scenario, the query “ZPRODUCT_Q001” is used. The query definition is given in the below section.
Determining Web Address and the Field NameAs our requirement is to jump to the product description on the webpage of Googleä, we have to first determine the web address of the page and the name of the input field. There are 2 options to perform this.
Look at the HTML code of the webpage. The tag form will be followed by the URL that sends the data; the tag input will be followed by the attribute name, which gives the name of the expected parameter.
The query string appears after the question mark. All the parameters name=value are listed here; individual parameters are separated with &.
Hence, we can determine the Web Address that refers to the input field for the search as http://www.google.de/search? And ‘q’ as the field name.
Step 1: Go to RSBBS transaction code and select the above query.
Step 2: Click on ‘Create’ button. Now, choose the ‘Web Address’ as the report type for the receiver.
Step 3: Enter the required Web address for the receiver report using input help. The screenshot is given below:
Click on ‘Apply’ and enter the description as ‘Google’. The screenshot is given below:
Fill in the assignment details. Enter q as field name. This is the name of the input field that we have already determined as described above. The screenshot is given below:
Now the system sets URL Parameter as the processing method (type) and it sets selection type to Parameter.
Step 4: Save the Sender/Receiver Assignment.
Execute the Query. The following screen shows the report output:
Execute the RRI by clicking on ‘Google’ which is the Web address description that we have given in Step 3.
The parameter is passed successfully and the search results are displayed on the Web page. The screenshot is given below: