This section describes the rules that are applied.
Base rules:
- A dimension must refer to at least one table.
- A dimension must refer to at least one attribute.
- Exactly one join can be defined between any two tables within
the dimension.
- Joins that are referenced by a dimension must refer to the attributes
of the dimension.
- Levels that are referenced by a dimension must refer to the attributes
of the dimension.
- Hierarchies that are referenced by a dimension must refer to the
levels of the dimension.
Optimization rule:
- A dimension must have one primary table to which joins attach
with a 1:1 or Many:1 cardinality.