About Alias Tables

You can assign alternate names, or aliases, to Oracle Hyperion Planning Account, Currency, Entity, Scenario, Period, Version, Years, and user-defined dimension members. Planning allows up to 10 aliases per dimension member, including the default alias.

When creating a Planning application, Oracle Essbase creates an empty default alias table in the database outline. If you do not create other alias tables, all aliases are stored in this default table. You cannot delete the default table.

You can create up to nine alias tables in Essbase. If you add or change aliases or alias tables, you must refresh the application. Changes are not in effect until the database is updated. To view the database outline, open Administration Services Console, select Outline, then Aliases, then Set Table, and select an alias table. You can use only alias tables created from within Planning. Alias tables created outside Planning are deleted during application refresh.

Multiple alias tables support, for example, these language combinations:

• English, French, German, Spanish, and Italian

• Japanese and English

• Korean and English

• Turkish and English

Note:

Alias table support is not restricted to these language combinations.

You can set alias tables to display members in an application. Planners can set alias tables in preferences.