_AttributeFields
The _AttributeFields table describes the attributes of each dimension and their relational sources.
This table describes _AttributeFields:
| Column | Type | Description |
|---|---|---|
| DimensionName | String(50) | The name of the dimension. |
| TableId | Integer | The attribute table identifier. There are up to three allowable tables of attributes for a dimension. These are identified by a number 1, 2, or 3. |
| RelationalField | String(50) | The name of the relational column from which the attribute field is loaded. |
| FieldName | String(50) | The name of the attribute field in the OLAP database to be loaded with data. This column is used by old style source tables. The column can be empty if the only source table is a combined table. |
| FieldDescription | String(150) | The description of the field. |
| FieldType | String(1) | Enumerator
indicating the field type. The values are:
|
| FieldWidth | Integer | The width of the field. |
| FieldDecimalPlaces | Integer | The number of decimal places of a numeric field. For non-numeric fields this value must be NULL. |
| FieldOrderPosition | Integer | The order in which to load the attributes (within an attribute table). This number indicates the order position of an attribute (within its attribute table). A NULL value is assumed to be zero. |
| Comment | Text | User defined comment. |
General information
The DimensionName column is linked to the DimensionName column in the _Dimensions table.
The attributes are loaded when a dimension is loaded (_Jobs.JobType = 1) or when the attributes are loaded for an existing (already loaded) dimension (_Jobs.JobType = 6). If more than the maximum number of attribute fields is attempted to be loaded, then the OLAP dimension is created but loaded without any attribute tables.