Oracle® Business Intelligence Server Administration Guide > Creating and Administering the Business Model and Mapping Layer in an Oracle BI Repository > Process of Creating and Administering Dimensions >
After creating a dimension, each dimension can be associated with attributes (columns) from one or more logical dimension tables and level-based measures from logical fact tables. After you associate logical columns with a dimension level, the tables in which these columns exist will appear in the Tables tab of the Dimension dialog box.
To create a dimension
- In the Business Model and Mapping Layer, right-click a business model and select New Object > Dimension.
- In the Dimension dialog box, in the General tab, type a name for the dimension.
- If the dimension is a time dimension, select the Time Dimension check box.
NOTE: The Default root level field will be automatically populated after you associate logical columns with a dimension level.
- (Optional) Type a description of the dimension.
- Click OK.