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:
Access the Essbase Model Properties dialog box using the procedure in Accessing the Essbase Model Properties Dialog Box.
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, .
Note: | You can also double-click on a table to move it. |
Click Add all available alias sets to the model, .
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.
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,
Move the selected alias down in the list,
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 model
Note: | You can also double-click on a table to move it. |
Click Remove all alias sets from the model,
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. |