Cube Properties

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

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 cube.

Stereotype

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

Fact

Specifies the fact used by the cube. Use the tools to the right of the list to create, browse for, or view the properties of the currently selected fact.

The following tabs are also available:

  • Fact Measures - lists the Measures linked to the fact used by the cube (see Measures (PDM)).

  • Queries - displays the SQL statement required to generate the cube data text file that is used to populate the OLAP cube.