LOADALIAS

Loads an alias table to the currently selected database.

Note:

See the Oracle Essbase Database Administrator's Guide for more information about alias tables in a database.

Syntax

LOADALIAS aliasName fileName
ParameterDescription

aliasName

Name of the alias table to load.

fileName

Name of the data source file that loads into the table. The source file must be located on the on the Essbase Server computer, not a client computer. Specify the file name in either of the following ways:

  • Full path to source file on the Essbase Server computer; for example,

    C:\Hyperion\products\Essbase\EssbaseServer\app\Sample\Basic\seasonal.txt

  • Relative path to the app\db directory on the Essbase Server computer; for example, 

       sample\basic\seasonal.txt

The data in the file must be formatted correctly. See the Oracle Essbase Database Administrator's Guide for details.

Example

Assume that seasonal.txt is a file with the following contents:

$ALT_NAME
"400-10"        Guava
"400-20"        Tangerine
"400-30"        Mango
$END

To load the contents of the seasonal.txt data source file into the alias table called special_flavors, use the following command:

LOADALIAS "special_flavors" "C:\Hyperion\products\Essbase\EssbaseServer\app\Sample\Basic\seasonal.txt";