Skip to content

xpms.dim_unit_alias

TableRow level security on

Unit bases used by canon (the Item Catalog unit_basis values, and hour and week, which owner decision 39 adds with the time dimension). A unit without a dimension refuses arithmetic rather than guessing.

Primary key: alias

Columns of xpms.dim_unit_alias
ColumnTypeNullableDescription
aliasxpms.canon_textNoUnit basis as written in canon.
unit_codexpms.canon_textNoCanonical unit the alias resolves to.
dimension_codexpms.canon_codeYesDimension of the unit, once ratified.References xpms.dim_unit_dimension.dimension_code