How to integrate OBI content trough HTTP using a simple URL
To incorporate specific Oracle Business Intelligence results into external portals or applications, you can use the Oracle BI Presentation Services GO URL. Post the Go URL as a Form or issue it as a URL; replace all spaces with plus ( + ) signs (eg. to pass “East Region” use “East+Region”).
You can use the GO URL within a OBI Dashboard or a HTML result view with the following characters:
saw.dll?GoOr on a different server by the fully qualified server name or IP address:
http://server_name_or_ip_address/analytics/saw.dll?GoYou can specify a number of optional parameters, if you don’t specify username and password parameters, the system will request you.
| 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 |
| Application Friendly | &Action=Extract | 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. |
| &Action=Scroll | ||
| 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 is XMLor HTML |
For example, to view the “ParameterReport” in the /shared/Test folder and to pass username and password, use the following syntax:
http://server_name_or_ip_address/analytics/saw.dll?Go&Path=/shared/Test/ParameterReport&NQuser=xxx&NQPassword=xxxYou can pass one or more parameters:
http://server_name_or_ip_address/analytics/saw.dll?Go&Path=/shared/Test/ParameterReport&Action=Navigate&P0=2&P1=eq&P2=Periods.Year&P3=1+1999&P4=eq&P5=Customers.State&P6=1+CAThere is al list of operators you can use to define filters:
| Operator | Meaning | Sign |
| eq | Equal to or in | = |
| neq | Not equal to or not in | <>, not in |
| lt | Less than | < |
| gt | Greater than > | |
| ge | Greater than or equal to | >= |
| le | Less than or equal to. | ⇐ |
| bwith | Begins with | Begins with |
| ewith | Ends with | Ends with |
| cany | Contains any (of the values in &P3) | Contain any |
| call | Contains all (of the values in &P3) | Contain all |
| like | You need to type %25 in place of the usual % wildcard. See the examples that follow. | Like |
| top | &P3 contains 1+n, where n is the number of top items to display. | Top n |
| bottom | &P3 contains 1+n, where n is the number of bottom items to display. | Bottom n |
| bet | Between (&P3 must have two values). | Between |
| null | Is null (&P3 must be 0 or omitted) | Is Null |
| nnul | Is not null (&P3 must be 0 or omitted) | Is Not Null |
You can also use a URL to refer a OBI Dashbord:
http://server_name_or_ip_address/analytics/saw.dll?Dashboard&PortalPath=/shared/Demo/_portal/Demo_Dashboard&NQUser=xxx&NQPassword=xxx