Creating attribute tables

You create attribute tables in the Attribute Tables dialog. Each dimension can have three attribute tables and the Attribute Tables dialog has a tab for each one. Each tab shows the details of the attribute table to which it relates or, if no attribute table has yet been created, a Create button.

To create an attribute table:

Click Dimensions in the Database group on the ribbon.
Select the dimension on which to create an attribute table.
Click Attribute Tables.
The Attribute Tables dialog is displayed.
Select a tab which does not relate to an existing attribute table and click Create. The Define Field dialog is displayed.
The Define Field dialog has these fields:

Name

Specify a field name of fewer than ten characters. You will use this name in attribute functions which retrieve or send information to this field.

Description

Specify the name to display as the field heading in the Dimension Browser.

Type

Specify the type of information to store. This can be String, Numerical or Logical.

Numerical values, like date and number formats used as attributes, must comply with your regional settings.

Width

This is enabled if you select String or Numerical as the field type. For strings, enter the maximum number of characters that a string entered in this field can have. In the case of Numerical, enter the maximum number of digits to display plus the number of decimal places to be shown.
When you have defined the first field, press Enter.
The Define Field dialog is displayed. You can now define up to 48 further fields.
When you have defined all the fields of the attribute table, press Esc.
Click Apply and then OK.
The attribute table is created.
Note: Attribute tables are empty when you create them. You can enter data manually or import data to an attribute table through a worksheet.

To work with attribute tables in a formula report you can use the AT.GET function.

SeeAT.GET.