Using rules files and data sources, you can define (add and rename) aliases. Data sources used to define aliases must, at minimum, include the member names associated with the aliases and the tables that contain the alias names. Alias assignment can be combined with other dimension building rules.
You can also define aliases by manually editing an outline or by importing an alias table source file.
Member name naming rules also apply to alias names.
Note: | If you are using a level reference build, you cannot create alias names that duplicate member names. |
To use rules files to define aliases:
Select Options, and then Dimension Build Settings to open the Dimension Build Settings dialog box.
On the Global Settings tab, click Update Alias Table to display a list of existing alias tables.
Select an alias table, and click OK.
In the rules file, select the field column for the alias names.
Select Field, then Properties, and select the Dimension Build Properties tab from the Field Properties dialog box.
Under the Field definition node, select the Alias field type.
Click OK.
“Setting Aliases” in the Oracle Essbase Database Administrator's Guide