A structure, often composed of one or more hierarchies, that categorizes data. Commonly used dimensions are Customer, Product, and Time.
In the Oracle Database, there are two kinds of dimensions:
A relational dimension is a database object that defines hierarchical (parent-child) relationships between pairs of column sets.
An OLAP dimension is an analytic workspace object that consists of a list of members.