Dimension attribute table
The
DEPM_MOD_DIMENSIONATTRIBUTE table represents an attribute of a
dimension.| Name | Definition |
|---|---|
| Name | nvarchar(50) NOT NULL; PK |
| DimensionID | nvarchar(50) NOT NULL; PK |
| Table | int NOT NULL; PK |
| Caption | nvarchar(50) NOL NULL |
| DataType | nchar(1) NOT NULL |
| Width | int NULL |
| Precision | int NULL |
| ElementTableColumnName | nvarchar(50) NULL |
| Order | int NOT NULL; unique key |
DataType indicates one of these data types of the dimension attribute:
- C or S: String
- N: Number
- B or L: Logical
- D: Date
ElementTableColumnName references the name of a column name from which the
dimension elements are loaded. The dimension attribute values are populated by this column.
The table has these references:
| Source columns | Target table | Target columns |
|---|---|---|
| DimensionID | _dimension | ID |