OBIEE 10G/11G - The Go URL

1 - About

The Go URL is a part of the saw Url and is used to :

  • add an answer in your favorites,
  • link an answer to an other answer
  • issue sql
  • pass filters
  • integrate an answers into an external Web site
  • generate the result data as XML

The Go Url has a focus on the answers while the dashboard url has a focus on the dashboards.

3 - The Basic Go URL

How to reference the Go Url :

From References
Oracle BI Presentation Services page saw.dll?Go From the actions, you need to set up an alias.
From another page on the same Web server /Analytics/saw.dll?Go From the actions, you need to set up an alias.
From a different server or sent through email, and so on http://server_name_or_ip_address/Analytics/saw.dll?Go

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.

To find the catalog path : Answers > Manage Catalog > Item Properties

Path of an OBI Presentation Service Object

For example, the following go URL command returns the default result view as defined in the request, where “/users/gerardn/Test” is the catalog path. saw.dll?Go&Path=/users/gerardn/Test

4 - URL Parameters

You can modify the behavior of the Dashboard URL command by adding parameters to the URL.

Parameters Format Definition
NQUser &NQUser=x User ID
NQPassword &NQPassword=x Password
Path &Path=x Path of the answer to execute. You can find it in the properties page (Answers/Manage Catalog/ and click on the properties icon (a little hand) of the object that you want. See picture above
Link Options &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
Printer Friendly &Action=print Results are in a printer-friendly format, without the paging controls, hot links, and so on.
Passing Filters &Action=Navigate To apply filters to the answer (OBIEE 10G/11G - Passing Filters through the Go and Dashboard URL)
Application Friendly &Action=Extract
&Action=Scroll
Results are displayed in an application-friendly format, such as for Microsoft Excel, without the paging control, hot links, and so on. 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 &ViewName=x This shows an individual result view rather than the default compound view
Specific View &ViewID=go~x This shows an individual result view rather than the default compound view where x is the name of the view
Specific Style &Style=x This shows the results using a specified style. If the style does not exist, the default is used.
Result Format &Format=x This controls the format of the results. This is the format, where x can be xml, html, txt (tab separator), csv (comma separator)
File Extension &Extension=.csv This controls the file extension of the download file
Language &Lang=fr This controls the language of the report. The value permitted are the values of weblanguage
PostRequest &PostRequest Command to pass a post request

for the parameter &ViewName=x, you cannot use the standard names of the views, you have to use the view names from the XML of your report :

  • for charts: staticchart!# (where # stands for the number of your view)
  • for tables: tableView!#
  • for narrative views: narrativeView!#
  • for compound views: compoundView!#

5 - Example

URL Description
saw.dll?Go&Path=/users/gerardn/Test&NQUser=user1&NQPassword=rock This logs on as user1 with a password of rock, and displays the answers Test
saw.dll?Go&Path=/Shared/Test/SB2 This displays the dashboard DB2
saw.dll?Go&Path=/Shared/Test/SB2&Options=md This displays results with the links Modify Request and Download
saw.dll?Go&Path=/Shared/Test/SB2&Action=Print Results are in a printer-friendly format, without the paging controls, hot links, and so on.
saw.dll?Go&Path=/Shared/Test/SB2&Action=Extract Results are displayed in an application-friendly format, such as for Microsoft Excel, without the paging control, hot links, and so on.
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.
saw.dll?Go&Path=/Shared/Test/SB2&Style=Lime This uses the style named Lime to show the results.
saw.dll?Go&Path=/Shared/Test/SB2&Format=XML This shows results in XML.
saw.dll?Go&Path=/Shared/Test/SB2&Action=Scroll&P5=-1&ViewID=go~Table Displaying All Records in a Table assuming the View to control is called Table

6 - Issuing SQL

You can also issue SQL.

The Go URL command can be used to issue Oracle Business Intelligence SQL. These forms of the Go URL return tabular results. The basic options from &Style= and &Options= can be used here as well.

To issue Oracle Business Intelligence's simplified SQL, include the escaped SQL as a parameter to the Go URL. For example:

saw.dll?Go&SQL=select+Region,Dollars+from+SupplierSales

where the FROM clause is the name of the Subject Area to query.

Alternatively, the command IssueRawSQL can be used to bypass the Web processing and issue SQL directly against the Oracle BI Server.

7 - Passing Filters

8 - Support

If an invalid URL is specified (for example, you type a parameter incorrectly), the browser returns the “The page cannot be found” error with detailed text of “HTTP 400 - Bad Request.”

9 - Reference

dat/obiee/obips/go_url.txt · Last modified: 2017/04/25 17:13 by gerardnico