Dimension Properties

You can modify an object's properties from its property sheet. To open a dimension property sheet, double-click its diagram symbol or its Browser entry in the Dimensions folder. The following sections detail the property sheet tabs that contain the properties most commonly entered for dimensions.

The General tab contains the following properties:

Property

Description

Name

Specifies the name of the item, which should be clear and meaningful, and should convey the item's purpose to non-technical users

Code

Specifies the technical name of the object, which is used for generating code or scripts, which may be abbreviated, and should not generally include spaces

Comment

Specifies a descriptive label for the dimension

Stereotype

Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined

Default Hierarchy

Specifies the dimension hierarchy used by default for a cube to perform its consolidation calculations. The hierarchy used by the cube is defined on the cube dimension association

The following tabs are also available:


  • Attributes - lists the attributes that qualify the dimension (see Attributes (PDM)).

  • Hierarchies - lists the hierarchies used to organize the dimension attributes (see Hierarchies (PDM)).

  • Mapping - defines the mapping between the current dimension and a table or a view in a data source.