Create a Dimension

Introduction:

This procedure describes how a dimension definition is entered into OWB. Before this can be entered, it must be designed. Use this template to create the design, here is an example.

Aim:

Create a Dimension definition in OWB.

Requirements:

Access to an OWB Target Module.

Procedure:

• Log on to OWB.
• Open a project.
• Expand 'Databases'
• Expand 'Oracle'
• Expand the target module.
• Right-click 'Dimensions'
• -Create Dimension-
• Welcome:
• [Next]
• Name:
  
• Name: Paste this from the Definition section of the design.
• Prefix: This is buggy - leave blank.
• Description: Paste this from the Definition section of the design.
• Levels:
• For each Level described in the Definition section of the design:
• Name: Paste this from the Definition section of the design.
• Prefix: Paste this from the Definition section of the design.
• Description: Paste this from the Definition section of the design.
• [Add]
• [Next]
• Level Attributes:
• By default, each Level has the attribute; ID. This cannot - and should not - be removed.
• For each Level described in the Definition section of the design:
• Level: Use drop-down to select the Level to work with.
• For each Level Attribute described in the Definition section of the design:
• Name: Paste this from the Definition section of the design.
• Datatype: Enter the Datatype, Length, Precision & Scale as appropriate from the Definition.
• Description: Paste this from the Definition section of the design.
• [Add]
• [Next]
• Hierarchies:
• For each Hierarchy described in the Definition section of the design:
• Name: Paste this from the Definition section of the design.
• Prefix: Leave blank. OWB does nothing with this.
• Description: Paste this from the Definition section of the design.
• [Add]
• [Next]
• Level Relationships:
• For each Hierarchy described in the Definition section of the design:
• Hierarchy: Use drop-down to select the Hierarchy to work with.
• Select and transfer Levels from the left side to right side as per the Definition.
• [OK]

Testing:

• Right-click the newly created dimension.
• -Validate...-
• This should result in the message; 'Validation completed successfully.'