Export metadata, either from the active database outline or an input outline file, to a specified XML file. Permission required: database manager.
Syntax
You can export metadata information from a database in the following ways using export outline.
Keyword | Description |
---|---|
DBS-NAME | Specify the database name instead of the outline file path. |
FILE-NAME | Specify the outline file path instead of the database name. |
all dimensions | Export information about all dimensions in the database. |
list dimensions | Export information about only the listed dimensions. Specify each dimension name within curly braces, and separated by commas. |
tree | Export only the member names in the hierarchy, omitting full metadata details. |
with alias_table | Export using only the member names indicated in the specified alias table. |
to xml_file | Specify the full path to the output XML file. |
Notes
This statement requires the database 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
Has relational descendants
IsHAEnabled (Hybrid Analysis enabled)?
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)
Example
export outline sample.basic all dimensions to xml_file "c:/temp/basic.xml";
Exports all outline information from Sample Basic to the specified XML file, basic.xml.
export outline sample.basic list dimensions {"Product", "Market"} tree to xml_file "c:/temp/basic.xml";
Exports information about Sample Basic dimensions Product and Market from to the XML file.
Export outline "c:/temp/basic.otl" all dimensions with alias_table "Default" to xml_file "c:/temp/basic.xml";
Exports information about all dimensions in Sample Basic from the specified outline file to the XML file, using only default alias names.