Show TOC

Dimension PropertiesLocate this document in the navigation structure

To view or edit a dimension's properties, double-click its diagram symbol or Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

The General tab contains the following properties:

Property

Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

Stereotype

Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file.

Mapped to Specifies the operational database table or view to which the dimension is mapped. Click the Properties tool to open the source table property sheet. To map a manually-created dimension to its source, open the Mapping Editor and drag and drop the table or view from the Source pane onto the dimension in the Target pane (see Operational to Warehouse Data Mappings).

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

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

The following tabs are also available:

  • Attributes - lists the attributes that qualify the dimension (see Fact and Dimension 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.