Selecting Alias Sets for an Essbase Model

Select alias sets to use in the model in the Alias tab of the Essbase Model Properties dialog box.

For information on aliases, see Aliases Overview.

For information on models, see Essbase Models Overview.

Note:

If you plan to optimize data loads (see Optimizing Data Loads), one alias table is required by Essbase to hold the aliases that will be used in data load alias optimization. You can select 31 other tables as alias sets for a total of 32. If you select more than 31 tables, some of the tables will be dropped during data loads.

  To select alias sets to use in an Essbase model:

  1. Access the Essbase Model Properties dialog box using the procedure in Accessing the Essbase Model Properties Dialog Box.

  2. With focus on the Essbase model name, select the Alias tab.

  3. To move tables from the Available Tables list to the Selected Tables list, perform an action:

    • Select one or more alias sets, and click Add the selected alias sets to the model, This button is named Add the selected alias sets to the model..

      Note:

      You can also double-click on a table to move it.

    • Click Add all available alias sets to the model, This button is named Add all available alias sets to the model.

  4. If you have selected alias sets with duplicate names in the Name in Cube column, a message prompts you to rename those alias sets in the Metadata Navigator.

    Because alias sets can have the same name under different folders, providing a new (and different) name for the alias set makes all alias table names unique inside a cube.

  5. Optional: Rearrange the order of the alias sets in the Selected Tables box by selecting a table and then clicking one of the following buttons:

    • Move the selected alias up in the list, An arrow pointing upward

    • Move the selected alias down in the list, An arrow pointing downward

  6. To move tables from the Selected Tables list to the Available Tables list, perform an action:

    • Select one or more alias sets, and click Remove the selected alias sets from the modelThis button is named Remove the selected alias sets from the model

      Note:

      You can also double-click on a table to move it.

    • Click Remove all alias sets from the model, This button is named Remove all alias sets from the model

  7. Click Apply.

    Note:

    To restore the settings on this tab to their previously saved values, click Restore. To restore the settings to their original system default values, click Default.