Add a dimension field

A dimension can have a maximum of 190 dimension fields. You must provide at least one dimension key field per dimension. A dimension key is a field that uniquely identities each record in the dimension. You can provide a maximum of eight keys fields per dimension. When a dimension key contains more than one field, it is called a composite key.

Add a dimension field

1. Open the AVEVA BI Gateway Model Builder.

2. Under the Dimensions column, click the dimension to which you want to add a dimension field.

3. In the Dimension editor in the right pane, click the Edit icon next to Fields. The Fields editor appears.

   

4. Click the Add icon. A new row is added in the grid.

5. Under the Key column, slide to enable the dimension key for the corresponding dimension field. You must provide at least one dimension key. You can include a maximum of eight fields for the dimension key.

6. Under the Field Name column, type a name for the dimension field.

   The dimension field name must comply with the following conventions:

   • The dimension field name is case insensitive and the maximum length is 100 characters.

   • The dimension field name must be unique and can contain characters that are valid in Microsoft SQL Server for regular column identifiers except that the first character of the name must be a letter as defined by the latest Unicode Standard, or an underscore (_). The subsequent characters can be letters or numbers as defined by the latest Unicode Standard, underscore (_), dollar ($), blank space, and hash (#) characters.

   • You cannot use the word "TimeStamp" for the dimension field name.

7. Under the Field Type column, click a data type for the corresponding dimension field. The default data type is Boolean. For more information about the data type conversions, see Data type mapping.

8. Click Save.