1. Using Oracle Essbase
  2. Create and Manage Cube Outlines Using the Web Interface
  3. View and Edit Outline Properties for a Newly Created Cube
  4. Understand and Create Alias Tables

Understand and Create Alias Tables

Aliases are stored in one or more tables as part of a database outline. An alias table maps a specific, named set of alias names to member names.

To create an alias table:

  1. On the Applications page, open the application and then open the database (cube).
  2. Click Launch Outline.
  3. If the outline is locked, and you are an administrator, click Unlock outline Image of the Unlock outline icon in Redwood..

    Before you forcefully unlock a locked outline, make sure that no one else is working with it.

  4. Click Edit outline Image of the redwood edit outline icon in the outline editor..
  5. Click Outline properties Image of the outline properties icon in the redwood outline editor..
  6. Click the Aliases tab.
  7. Enter the name of the alias table you want to create and click Add.

    You can have a maximum of 56 alias tables.

  8. Click Apply and Close.
  1. On the Applications page, expand the application.
  2. Click the Actions menu to the right of the cube name and click Outline.
  3. Click Edit.
  4. Click Outline Properties.
  5. Select the Aliases tab.
  6. Enter the name of the alias table you want to create and click Add.

    You can have a maximum of 56 alias tables.

  7. Click Apply and Close.

See Create Aliases and Setting Aliases.

You cannot delete or rename the default alias table.