
Chapter 3. Building a cube model in DB2 77
Attribute relationships are mainly used within the context of a hierarchy. Attributes
that are directly related to attributes in a hierarchy can become part of the query.
For example, you can include
CityPopulation
in a query that retrieves
CityID
.
Figure 3-12 provides a graphical representation of attributes, attribute
relationships, and hierarchies within the context of a dimension.
Figure 3-12 Dimension, attributes, hierarchies, and attribute-relationships
3.2.6 Joins
DB2 Cube Views stores metadata objects called joins, representing joins in the
star schema (see Figure 3-13).
In the case of a star s ...