Dimensions are lists of unique values that identify and categorize data. They form the edges of a cube, and thus of the measures within the cube.
You can define dimensions either as User or as Time dimensions. Business analysis is performed on historical data, so fully defined time periods are vital. Your time dimension table must have columns for period end dates and time span. These required attributes support time-series analysis, such as comparisons with earlier time periods. If this information is not available, then you can define time as a user dimension, but it will not support time-based analysis.
To create a dimension:
Expand the folder for the analytic workspace.
Right-click Dimensions, then choose Create Dimension from the pop-up menu.
The Create Dimension dialog box is displayed.
Complete all tabs of the dialog box.
Click Help for specific information about these choices.
Click Create.
The new dimension appears as a subfolder under Dimensions.
Create levels for the new dimension.
Note: If the dimension has parent-child relations among its members, but these relationships do not define meaningful levels, then create a hierarchy next.
Copyright © 2003, 2007, Oracle. All rights reserved.