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
Parameter | Description |
---|---|
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:
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";