Microsoft Office Tutorials and References
In Depth Information
Figure 1-5. A simple 3-dimensional cube
With a cube like the one in Figure 1-5 , you can find out product sales in a given timeframe. This cube uses
Product Sales as facts with the Time dimension.
Facts (also called measures) and dimensions are integral parts of cubes. Data in cubes is accumulated as facts
and aggregated against a dimension. A data cube is multidimensional and thus can deliver information based on any
fact against any dimension in its hierarchy.
Dimensions can be described by their hierarchies, which are essentially parent-child relationships. If dimensions
are key factors of cubes, hierarchies are key factors of dimensions. In the hierarchy of the Time dimension, for
example, you might find Yearly, Half-Yearly, Quarterly, Monthly, Weekly, and Daily levels. These become the facts or
members of the dimension.
In a similar vein, geography might be described like this:
Dimensions, facts (or measures), and hierarchies together form the structure of a cube.
Figure 1-6 shows a multidimensional cube.
Search JabSto ::