Essbase Studio expands your options for drill-through reports by providing the capability of specifying a URL as a drill-through target. When you specify a URL in the Report Contents tab of the drill-through report editor, users are able to drill through directly to a URL from a drill-through intersection in a spreadsheet.
Use the URL report type and then define the target URL. You can specify static URLs as drill-through targets, as well as dynamic URLs to targets such as FDM and Oracle BI EE Web pages.
The URL syntax must be consistent with the requirements of the target URL. However, to express dimensions, columns, and values, all URLs have the following variable structure in common:
$$<dimension-name>-VALUE$$
When a user clicks on a drill-through cell, Essbase Studio makes the substitutions necessary to generate the target URL in the context of the selected drill-through intersection.
For example, if the Market dimension is in the point-of-view (POV) of a drill-through target URL, the variable for the value from Market will look like this:
$$Market-VALUE$$
When the spreadsheet user selects the drill-through cell from an intersection containing a member from the Market dimension, Essbase Studio substitutes the appropriate Market value into the URL syntax; for example:
East
In the following example, the variable for the value from the Product dimension will look like this:
$$Product-VALUE$$
When the spreadsheet user selects the drill-through cell from an intersection containing a member from the Product dimension, Essbase Studio substitutes the appropriate Product value in the URL syntax; for example:
Cola
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. |
To define a URL report type and specify the URL to drill-through to:
In the Context tab of the drill-through report editor, from Drill-through Report Type, select URL.
In the URL text box, enter the target URL for the drill-through report.
Alternatively, you may create the URL by editing the syntax generated by Essbase Studio when you click one of the following buttons:
Sample URL Template—Provides the syntax for a target URL based on the intersections you specified in the Context tab.
See Sample URL Template for more information.
FDM URL Template—Provides the syntax for a target FDM URL based on the intersections you specified in the Context tab.
See Sample FDM URL Template for more information.
OBI URL Template—Provides the syntax for a target Oracle BI EE URL based on the intersections you specified in the Context tab.
See Sample Oracle BI EE URL Template for more information.
Click Save, and then Close to close the drill-through report editor; or select the Associations tab and perform the tasks in Associating Drill-through Reports with Essbase Models.