LOADALIAS

Loads an alias table to the currently selected database.

Syntax

LOADALIAS aliasName fileName

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 Analytic Server computer, not a client computer. Specify the file name in either of the following ways:
  • Full path to source file on the Analytic Server computer; for example,
    c:\hyperion\essbase\app\sample\basic\seasonal.txt
  • Relative path to the app\db directory on the Analytic Server computer; for example,
    sample\basic\seasonal.txt
The data in the file must be formatted correctly. See the 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\essbase\app\sample\basic\seasonal.txt";

See Also

The Database Administrator's Guide for more information about alias tables in a database.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com