Alias table import files contain information that associates aliases with outline members. You can create an alias table import file in the following ways:
Export an alias table
Use a text editor to create the file
Use an automated means such as a Perl script to generate the file
Alias table import and export files are text files with the following format:
The first line of the file says, $ALT_NAME. The name of the alias table is included after one or two spaces. Alias table names that contain blank characters must be enclosed in single quotation marks.
The last line of the file must say, $END.
On each of the lines between the first and the last lines, two values must be placed. The first value must be the name of an existing outline member; the second value is the alias for the member. Separate the two values by one or more spaces or tabs.
Note: | Enclose in double quotation marks members or alias names that contain a blank or an underscore. |
The following text represents the example content of a small, alias table import or export file for Sample Basic:
$ALT_NAME 'Long Names'
Qtr1 Quarter1 Jan January Feb February Mar March $END
Note: | Administration Services requires alias table import files to be UTF-8 encoded, with the UTF-8 signature. |
“Creating and Managing Alias Tables” in the Oracle Essbase Database Administrator's Guide