Sample Oracle BI EE URL Template

The Sample Oracle BI EE URL Template provides the syntax for a target Oracle BI EE URL based on the intersections you specified in the Context tab of the drill-through report editor.

The syntax and examples assume that the Product and Market hierarchies are selected in the Context tab of the drill-through report editor.

Syntax

After selecting the Product and Market hierarchies in the Context tab of the drill-through report editor:

obi:http://<server-name>:9704/analytics/saw.dll?PortalPages&PortalPath=<portal-path>&Action=Navigate&P0=2&P1=eq&P2=<Product-column>&P3=$$Product-VALUE$$&P4=eq&P5=<Market-column>&P6=$$Market-VALUE$$

Note:

When you are using Spreadsheet Add-in, drill-through target URLs are limited to 256 characters in length. With Smart ViewSmart View, any limitations to URL length depend on the browser being used.

Parameters

<server-name>—The name or IP address of the server to which you want to connect.
<portal-path>—Path to Oracle BI EE Presentation Service Report/Dashboard.
<number-of-parameters>—Number of report parameters.
<Market-column> and <Product–column>—The column in the Oracle BI EE data source to retrieve in the target drill-through report. For example, in the Product dimension, you may specify the column, SKU; in the Market dimension, you may specify the column, Region.
```
obi:http://obiserver:9704/analytics/saw.dll?PortalPages&PortalPath=paint&Action=Navigate&P0=2&P1=eq&P2=SKU&P3=$$Product-VALUE$$&P4=eq&P5=Region&P6=$$Market-VALUE$$
```
Multiple columns may be specified.

Example

After selecting the Product and Market hierarchies in the Context tab of the drill-through report editor, upon executing the drill-through request, the “obi” prefix is removed from the target URL string and the following substitutions are made:

http://obiserver:9704/analytics/saw.dll?PortalPages&PortalPath=paint&Action=Navigate&P0=2&P1=eq&P2=SKU&P3=100–10&P4=eq&P5=Region&P6=East