Export outline files must be written to a location on the Essbase Server or client machine on which the export outline MaxL statement is run.

The minimum application permission required to export the outline is Database Manager.

Syntax

• DBS-NAME

• FILE-NAME

• DIM-NAME

• ALT-NAME-SINGLE

Keywords

You can export metadata information from a cube in the following ways using MaxL export outline.

export outline DBS-NAME ...

Export the outline for the specified cube name.

export outline FILE-NAME ...

Export the outline with the specified .otl file name.

export outline … all dimensions …

Export information about all dimensions in the cube.

export outline … list dimensions …

Export information about only the listed dimensions. Specify each dimension name within curly braces, and separated by commas.

export outline … tree …

Export only the member names in the hierarchy, omitting full metadata details.

export outline … with alias_table ALT-NAME-SINGLE ...

Export using only the member names indicated in the specified alias table.

export outline … to xml_file FILE-NAME

Specify the absolute path to the output XML file, including the file name.

Notes

• This statement requires the cube to be started.

• The following general outline information is included in the XML export:

  • Case sensitiveness

  • Outline Type

  • Duplicate Member Names allowed

  • Typed Measures Enabled

  • Date Format

  • Varying Attributes Enabled

  • Alias Table count and list

  • Active Alias Table

  • Attribute information

  • Auto configure

  • Text list definitions

  • Universal member comments

  • Locale, if it exists

  • Query hint list (if aggregate storage)

  • Get Implied Shared Setting

• The following dimension information is included in the XML export:

  • Name

  • Two pass calc

  • Type

  • Text list, if text typed

  • Formula

  • Format String

  • Comment

  • Extended member comment

  • Dimension category

  • Attribute type

  • Data Storage

  • Dimension Storage

  • Alias Names, if any

  • UDAs, if any

  • Consolidation

  • Attribute dimension associated

  • Independent dimensions, if any

  • Time balance

  • Skip options

  • Variance reporting

  • Currency conversion

  • Currency conversion member

  • Dynamic Time Series enabled list

  • Attachment level, if linked attribute dimension

  • Dimension solve order

  • Is Non Unique dimension?

  • Hierarchy type

  • Level usage for aggregation (for aggregate storage hierarchies)

  • Is Compression dimension? (if aggregate storage)

  • Storage category

• The following member information is included in the XML export:

  • Name

  • Two pass calc

  • Type

  • Text list, if text typed

  • Is shared?

  • Shared member name, if shared

  • Formula

  • Format string

  • Comment

  • Extended member comment

  • Attribute type

  • Data storage

  • Dimension storage

  • Alias names, if any

  • UDAs, if any

  • Consolidation

  • Attribute member associated

  • Validity sets, if any

  • Time balance

  • Skip options

  • Variance reporting

  • Currency conversion

  • Currency conversion member

  • Member solve order (if aggregate storage)

  • Level usage for aggregation (for aggregate storage hierarchy members)

Examples

Linux Example 1

export outline sample.basic all dimensions to xml_file '/scratch/myexports/basic.xml';

Exports all outline information from Sample.Basic to the specified XML file, basic.xml.

Linux Example 2

export outline sample.basic list dimensions {"Product", "Market"} tree to xml_file '/scratch/myexports/basic.xml';

Exports information about Product and Market dimensions from Sample.Basic to the XML file.

Windows Example

export outline sample.basic all dimensions with alias_table "Default" to xml_file 'C:\\myexports\\basic.xml';

Exports information about all dimensions in Sample.Basic, using only default alias names.