Oracle® Business Intelligence Presentation Services Administration Guide > Integrating Oracle BI Presentation Services into Corporate Environments Using HTTP > Using the Oracle BI Presentation Services Go URL to Issue SQL and Pass Filters >

Issuing SQL Using the Oracle BI Presentation Services Go URL


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.

Oracle® Business Intelligence Presentation Services Administration Guide Copyright © 2007, Oracle. All rights reserved.