Drill Through to a URL

You can drill through to a URL directly from a cell in Smart View.

Note:

You can only drill through to a URL from a single cell. Drilling through to a URL from multiple cells is not supported.

Drill through target URLs can be static or dynamic. An example of a static target URL is https://docs.oracle.com.

Dynamic target URLs use variables. All dynamic target URLs have the following variable structure in common:

$$<dimension-name>-VALUE$$

When a user drills through from a cell, Essbase makes the substitutions necessary to generate the target URL in the context of the selected drill-through intersection.

For example, if the drillable region includes a member from the market dimension, the variable for the value from Market will look like this:

$$Market-VALUE$$

When you select the drill-through cell from an intersection containing a member from the Market dimension, Essbase 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 you select the drill-through cell from an intersection containing a member from the Product dimension, Essbase substitutes the appropriate Product value in the URL syntax; for example:

Cola

Create a Drill Through Report to a URL

First, define a new drill through report on Sample Basic.

1. On the Applications page, expand the application.
2. From the Actions menu, to the right of the cube name, click Inspect.
3. On the cube inspector, select the Scripts tab and then select Drill Through Reports.
4. Click Create, and then select URL from the drop down menu.
5. Give the drill through report a name, such as URL_dt.
6. In the URL field, add the following URL:

   https://docs.oracle.com/search/?q=$$Product-VALUE$$+$$Market-VALUE$$&category=database&product=en/database/other-databases/Essbase

   Note:

   The variable syntax comes right after the ?q=
7. Add a new drillable region:

   @DESCENDANTS(Product),@CHILDREN(Market)

With this drill through report, when you drill through from a cell intersection for any Product generation member in any child of Market dimension, a browser is launched, and Essbase documentation is searched for the parameter represented by VALUE.

Log into the cube from Smart View.

In this example, we’ve selected a blue background for the drillable regions. Drill through on Actual, Colas, East, Qtr1.

The browser is launched and the Essbase documentation is searched using the parameter values 100 and East (recall that Colas is the alias for Product category 100).

Drill through on a different cell to see how the parameter passed to the drill through URL changes depending on cell intersection context in Smart View.

Drill through on Actual, Cream Soda, West, Qtr4:

The Essbase documentation is now searched for 300 and West: