Selecting Tables as Alias Sets

Select tables to use as alias sets on 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 tables as alias sets for an Essbase model:

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

  2. Select the Alias tab.

  3. Select the name of a table in Available Tables or in Selected Tables.

  4. Use the direction buttons to move the table from Available Tables to Selected Tables or from Selected Tables to Available Tables.

    Note:

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

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