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
• Structure of the Basic Oracle BI Presentation Services Dashboard URL
• Optional Parameters for the Oracle BI Presentation Services Go URL

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:

  Letter	Link
  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:

• Set the Rows per Page property on the Table view to 10,000, and then use the basic Go. This is the easier of the two methods.
• Issue the following URL, assuming the View to control is called Table:

  saw.dll?Go&Path=/Shared/Test/SB2&Action=Scroll&P5=-1&ViewID=go~Table