News

Even if these dimensions don't contain an explicit hierarchy, a dimension may easily incorporate into a single structure a group of various look-ups sharing a commonality from a single subject area.
The grain of a fact table is derived by the dimensions with which the fact is associated. For example, should a fact have associations with a Day dimension, a Location dimension, a Customer dimension, ...