|Oracle9i OLAP Services Concepts and Administration Guide for Windows
Release 1 (9.0.1) for Windows
Part Number A90371-01
Configuring Your Data Warehouse, 6 of 11
Before you can define any other objects, you must define the dimensions of your data. You can use the Dimension Creation Wizard or supply information directly in the Create Dimension dialog box.
To define a dimension, you provide all the information that will be needed to label and aggregate the measures dimensioned by it, including:
Business analysis is performed on historical data, so fully defined time periods are vital. Special support for time dimensions is built into the metadata to allow for time-dependent analyses, such as comparisons with earlier time periods.
Your time dimension table must have columns for end-date and time-span, as described in "Time dimensions". Typical levels and hierarchies for time dimensions are suggested by the Dimension Wizard, but you do not have to use them.
Follow these steps to create a dimension and its associated levels, hierarchies, and attributes:
The following figure shows the General page of the dimension property sheet for a Time dimension.
Search for the following topics in Oracle Enterprise Manager Help for information about creating dimensions: