Creating a Dimension

  To create a dimension:

1. On the Object Browser View menu, select Dimensions.

2. Click Actions and select Add.

3. In the Dimension Wizard, enter dimension Properties.

   • Name

   • Description

   • Type—Dense, Sparse, or Time

     See Dimensions.

4. Enter dimension Hierarchies information.

   Enter a dimension hierarchy Name, select a Hierarchy Type, and enter hierarchy details.

   • For Static hierarchies, enter the following information:

     • Root Member—Name and Display Name for the top member of the hierarchy

     • Levels—Number of levels in the hierarchy

       Select Associate Styles to Levels to define styles for the levels in the hierarchy

   • For Dynamic hierarchies, enter the following information:

     • Class—Java class that defines the hierarchy

   • For Row Source Based hierarchies, enter the following information:

     • Row Source Name

     • Parent Name

     • Parent Display Name

     • Parent Description

     • Parent Attributes

     • Child Name

     • Child Display Name

     • Child Description

     • Child Attributes

     In a row source-based hierarchy, parent and child members can have many relationships. An example of a row source based hierarchy is a Bill of Materials.

5. Enter dimension Attributes .

   Click Create or Edit, and enter attribute details. Attributes define information about a member in the dimension. Attributes are used for filtering and searching.

   The maximum number of dimension attributes a model can have is 20. This information is stored in the IS_DIMENSION_ATTRIBUTES table in the Integrated Operational Planning database.

6. Click Save to create the dimension.

   The dimension is saved in the Object Browser.

   Note:

   See Understanding Cubes, Dimensions, and Measures Data Types and Data Flow and Mapping for additional information on dimensions and how data is staged and loaded into the Integrated Operational Planning database.