Member Arrangement Patterns Visual Summary

Visual image
A set of members, no root member, no aggregation

A set of members, with aggregation, therefore MUST have root member.

A set of members, with aggregation, also has nested aggregation. Region and country are represented using one characteristic.

A set of members, with aggregation, also has nested aggregation. Region and country are represented using two characteristics. (Note that the meaning of the information did not change, only the representation method.)

A set of members, with aggregation, all characteristics are explicitly provided (rather then implied). Shows intersections between multiple tables where conflicts do NOT exist. (i.e. dimension defaults are not necessary)

A set of members, with aggregation, all characteristics are explicitly provided (rather then implied). Shows intersections between multiple tables where conflicts would exist if dimension defaults are not used.

Creative Commons License
This work is licensed under a Creative Commons License.