Oracle® Business Intelligence Presentation Services Administration Guide > Integrating Oracle BI Presentation Services into Corporate Environments Using HTTP >
Incorporating Oracle Business Intelligence Results into External Portals or Applications Using the Go URL
This section describes how to use the Oracle BI Presentation Services Go URL to incorporate results into external portals or applications. It contains the following topics:
About the Oracle BI Presentation Services GO URL
The Oracle BI Presentation Services Go URL command is for use in incorporating specific Oracle Business Intelligence results into external portals or applications. The Go URL is used when you add a result to your favorites, or add a link to a request to your dashboard or an external Web site. It has a number of forms and optional arguments that can be used to control its behavior. You can post the Go URL as a Form or issue it as a URL. If you are issuing parameters as part of a URL, they need to be escaped properly. You need to replace spaces with plus ( + ) signs, and so on. For example, to pass East Region as a value, type East+Region. When called from within an Oracle BI Presentation Services screen, such as a dashboard or an HTML result view, the URL should begin with the following characters: saw.dll?Go
When called from another screen on the same Web server, the URL should begin with the following characters: /Analytics/saw.dll?Go
When referenced from a screen on a different server (or sent through email, and so on), the URL should begin with the fully qualified server name or IP address: http://server_name_or_ip_address/Analytics/saw.dll?Go
To test these commands, you can enter the fully qualified version into the Address field in Internet Explorer. Structure of the Basic Oracle BI Presentation Services Go URL
The basic Go URL command needs the full Presentation Catalog path to the request to execute. It returns the default result view, which is defined in the request. For example, the following go URL command returns the default result view as defined in the request, where SB2 is the name of the request to execute. saw.dll?Go&Path=/Shared/Test/SB2
Optional Parameters for the Oracle BI Presentation Services Go URL
You can modify the behavior of the Go URL command by adding one or more of the following parameters. If an invalid URL is specified (for example, you type a parameter incorrectly), the browser displays a "The page cannot be found" error with the detailed text of "HTTP 400 - Bad Request." NOTE: In parameter descriptions, SB2 is the name of the request to execute.
- User ID and Password. The user is prompted for user ID and password if this information has been omitted from the request and if the user has not chosen the option to have logon information remembered.
This is the format, where uuu is the user ID and ppp is the password:
&NQUser=uuu&NQPassword=ppp
Example:
saw.dll?Go&Path=/Shared/Test/SB2&NQUser=user1&NQPassword=rock
This logs on as user1 with a password of rock, and executes the request.
- Link Options. The results will include links.
This is the format:
&Options=x
The x can be one or more of the following letters:
|
|
m |
Modify Request |
f |
Printer Friendly |
d |
Download to Excel |
r |
Refresh Results |
Example:
saw.dll?Go&Path=/Shared/Test/SB2&Options=md
This displays results with the links Modify Request and Download.
- Printer Friendly. Results are in a printer-friendly format, without the paging controls, hot links, and so on.
This is the format:
&Action=print
Example:
saw.dll?Go&Path=/Shared/Test/SB2&Action=Print
- Application Friendly. Results are displayed in an application-friendly format, such as for Microsoft Excel, without the paging control, hot links, and so on.
This is the format:
=&Action=Extract
Example:
saw.dll?Go&Path=/Shared/Test/SB2&Action=Extract
The Extract action also acts as a Navigate action (read Passing Filters to the Oracle BI Presentation Services Go URL Through a URL (Navigation)) so you can filter the results that are returned by the call.
- Specific View. This shows an individual result view rather than the default compound view.
This is the format, where xx is the name of the view:
saw.dll?Go&Path=/Shared/Test/SB2&ViewName=xx
Example:
saw.dll?Go&Path=/Shared/Test/SB2&ViewName=Chart
Assuming that the request contains a Chart view named Chart, this displays just the Chart view.
- Specific Style. This shows the results using a specified style. If the style does not exist, the default is used.
This is the format, where xx is the name of the style:
saw.dll?Go&Path=/Shared/Test/SB2&Style=xx
Example:
saw.dll?Go&Path=/Shared/Test/SB2&Style=Lime
This uses the style named Lime to show the results.
- Result Format. This controls the format of the results.
This is the format, where xx is XML or HTML:
saw.dll?Go&Path=/Shared/Test/SB2&Format=xx
Example:
saw.dll?Go&Path=/Shared/Test/SB2&Format=XML
This shows results in XML.
Displaying All Records in a Table
There are two ways to display all the records in the table:
|