Display Drillthrough

The MaxL display drillthrough statement helps you view drill-through URL definitions used to link Essbase to content hosted on Oracle ERP and EPM applications.

Syntax

Description of the illustration display_drillthrough.gif

• DBS-NAME

• FILE-NAME-PREFIX

• URL-NAME

• FILE-NAME

Use display drillthrough to display URL information in the following ways:

Keywords

<dbs-name>

Display all drill-through URL definitions on the database.

The number of drill-through URLs per database is limited to 255.

<dbs-name> to <file-name-prefix>

Display all drill-through URL definitions on the database, writing the URL XML content to file names prefixed with the string given as input for FILE-NAME-PREFIX.

<url-name>

Display the specified drill-through URL definition.

The number of drillable regions in a drill-through URL is limited to 256. The number of characters per drillable region is limited to 65536.

<url-name> to <file-name>

Display the specified drill-through URL definition, writing the URL XML content to the specified file name.

Example

display drillthrough sample.basic;

Displays all drill-through URL definitions on Sample.Basic.

display drillthrough sample.basic to "urlxmls";

Displays all drill-through URL definitions on Sample.Basic, writing the URL XML content to file names prefixed with urlxmls.

display drillthrough sample.basic."Drill through To EPMI";

Displays the drill-through URL definition named Drill through To EPMI.

display drillthrough sample.basic."Drill through To EPMI" to "c:/temp/drillthrough.xml";

Displays the drill-through URL definition named Drill through To EPMI, writing the URL XML content to the file drillthrough.xml.