Dimension Documentation - Definition

This section contains the dimension definition and should contain the following:

Table:

Table	Description
Name of the database table that implements the dimension.	A description of the dimension. This should be a plain-English description and, as it will end up in the user-accessible data dictionary, should be aimed at the user's understanding of what they are dealing with.

Levels:

Level	Prefix	Description
Name of the level.	Column prefix of the level. This is appended to the attribute name to create the database column name. A 3-character prefix is common.	A description of the level. This should be a plain-English description and, as it will end up in the user-accessible data dictionary, should be aimed at the user's understanding of what they are dealing with.

Level Attributes:

For each level:

Attribute	Datatype	Description
Name of the Attribute. This must be unique within the level.	Oracle Datatype. e.g. DATE, VARCHAR2(10), NUMBER(7,2), etc.	A description of the attribute. This should be a plain-English description and, as it will end up in the user-accessible data dictionary, should be aimed at the user's understanding of what they are dealing with.

Hierarchies:

Hierarchy	Description
Name of the hierarchy.	A description of the hierarchy. This should be a plain-English description and, as it will end up in the user-accessible data dictionary, should be aimed at the user's understanding of what they are dealing with.

Level Relationships:

Hierarchy	Level
Name of the hierarchy.	A list of levels that are assigned to the hierarchy. These are ordered from the least to most granular.

Next - Sources