Understand the Cube.Settings Worksheet: Alias Tables

This section of the Cube Settings worksheet lists alias tables that need to be created for the cube.

It must contain at least the Default row.

Property or Field Valid Values Description
Default Default

Every cube has a table named Default. You can create additional alias tables in the rows following the Default row.

Rows following the default row. These new rows can be created manually, or using the Designer Panel.

Naming conventions for member names apply. See Naming Conventions for Dimensions, Members, and Aliases.

You can set multiple aliases for a member using multiple alias tables.

To define alias tables, add their names on the Cube.Settings worksheet, in the Alias Tables (Alternate Member Names) section. For example, in the workbook for Sample Basic, six alias tables are defined.

Application workbook for Sample Basic cube, with Cube.Settings sheet active. Image focuses on Alias Tables (Alternate Member Names) section. The listed alias tables are Default, Long Names, ChineseNames, JapaneseNames, RussianNames, and GermanNames.

An alias table applies to all members in the outline, although you don't have to provide an alias name for every member unless you need it. You may use up to 56 alias tables if you require more than one name for any members in the outline.

When you create a new alias table, it is empty. To make a new set of aliases available to users, you need to populate the alias table with aliases for some of the members.

To define the contents of the alias tables, you must do it per dimension, by adding columns of aliases to the Members section of the dimension worksheets.

Application workbook for Sample Basic cube, with Dim.Product sheet active. Image focuses on columns PARENT, CHILD, ALIAS.Default, ALIAS.ChineseNames, ALIAS.JapaneseNames, ALIAS.RussianNames, ALIAS.GermanNames, in the Members section of the worksheet.

The columns must be named in the format ALIAS.<AliasTableName>.

Notice that there is no ALIAS.Long Names column. Though the Cube.Settings worksheet indicates that an alias table named Long Names will be built, this alias table will be empty if no aliases are defined for it on any dimension worksheets.

See also Setting Aliases.