1. Working with Oracle Smart View for Office
  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.

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

Note:

  • 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.