A structure that categorizes data. Among the most common dimensions for sales-oriented data are Time, Geography, and Product. Most dimensions have hierarchies and levels.
In a cube, a dimension is a list of values at all levels of aggregation. It is an index for identifying the values of a measure. For example, if Sales data has a separate sales figure for each month, then the data has a month dimension; that is, the data is organized by month.
In a relational table, a dimension is a type of object that defines hierarchical (parent/child) relationships between pairs of column sets.
Copyright © 2003, 2007, Oracle. All rights reserved.