Importing and Exporting Alias Tables

You can import a correctly formatted text file into Essbase as an alias table. Alias table import files have the .alt extension. Alias table import files should have the following structure:

The following is an example of an alias table import file:

$ALT_NAME  'Quarters'
Qtr1  Quarter1
Jan   January
Feb   February
Mar   March
$END

You can also export an alias table from the Essbase outline to a text file. The export file contains aliases and the corresponding member names—qualified member names for duplicate members.

  To import or export alias tables, use a tool:

Tool

Topic

Location

Administration Services

Importing Alias Tables

Exporting Alias Tables

Oracle Essbase Administration Services Online Help

MaxL

alter database

Oracle Essbase Technical Reference

ESSCMD

LOADALIAS

UNLOADALIAS

Oracle Essbase Technical Reference