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 >

Creating 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

1. In the Business Model and Mapping Layer, right-click a business model and select New Object > Dimension.
2. In the Dimension dialog box, in the General tab, type a name for the dimension.
3. 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.

4. (Optional) Type a description of the dimension.
5. Click OK.