Display Drillthrough
View drill-through URL definitions used to link to content hosted on Oracle ERP and EPM applications.
Syntax
Use display drillthrough to display URL information in the following ways:
| Keyword | Description |
|---|---|
<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.
See Also