Use the Sample URL Template to help you define a URL as a drill-through report target. You can specify static HTTP URLs as drill-through targets, as well as dynamic URLs that take into account the drill-through intersections specified in the Context tab of the drill-through report editor.
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. |
You may provide a static HTTP URL; for example:
http://www.oracle.com
For a URL to a dynamic target, Essbase Studio Console provides a sample that uses Google. The number of values to search on depends on the number of drill-through intersections specified in the Context tab of the drill-through report editor. The following is the syntax when drill-through intersections were specified on two hierarchies, Product and Market:
http://www.google.com/search?hl=en&q=$$Product-VALUE$$+$$Market-VALUE$$
Essbase Studio makes the appropriate substitutions to the URL, depending on the drill-through intersection context, when the spreadsheet user executes the drill-through report.
The example uses the sample URL template from the Essbase Studio drill-through report editor and assumes that the Product and Market hierarchies were selected in the Context tab of the drill-through report editor.
When the user clicks on a drill-through cell in a Product and Market intersection, Essbase Studio makes substitutions for the variables $$Product-VALUE$$ and $$Market-VALUE$$, and generates the following URL string:
http://www.google.com/search?hl=en&q=Cola+East