1. User's Guide
  2. Dimensions and Members
  3. Working with Aliases and Alias Tables

Working with Aliases and Alias Tables

Aliases are alternate names for database member names.

Cloud data source types: Oracle Essbase, Planning, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Narrative Reporting, Tax Reporting

On-premises data source types: Oracle Essbase, Oracle Hyperion Planning, Oracle Hyperion Financial Management

Note:

  • In Financial Management, aliases are called "descriptions."
  • Database member names are often stock numbers or product codes; their aliases can be more descriptive. For example, in the Sample Basic database, the alias name for the database member 100 is Colas. Aliases are stored in alias tables as part of a database. Dimensions can be associated with multiple alias tables.
  • You can select an alias table for the current worksheet or for a connection.
  • For Essbase, the special characters of Equal To sign (=) and Single Quote sign (') are supported in member names and aliases in Oracle Smart View for Office. For example, =units, 'price.