Skip Headers
Previous
Previous
 
Next
Next

Create/Edit Cube Dimension: General

A cube dimension is a first-class database object. It stores a list of values that serves as an index to the data stored in a cube. These values, or dimension members, represent all levels of aggregation.

Schema: The schema in which the cube dimension is created.

Name: A simple name for the cube dimension object that complies with the rules for first-class database object names. Enter underscores where you want spaces in the default labels.

Analytic Workspace: The name of the analytic workspace in which the cube dimension is created.

Dimension Type: Select the type that describes the dimension members:

Advanced: Displays the advanced options on the Create Cube Dimension dialog box, which include Storage, Descriptions, and Map. The advanced options are always displayed on the Edit Cube Dimension dialog box.

Short Label: A short descriptive name for display where space is limited, which can contain mixed case, spaces, and symbols.

Long Label: A long descriptive name for display, which can contain mixed case, spaces, and symbols.

Description: Additional descriptive text, which can contain mixed case, spaces, and symbols.

Dimension Class Type:

Sort Attribute: Identifies a sorting method. All methods sort alphanumerically within the parent.

Use these options to customize the sort order:

Related Topics

"About Cube Dimensions"

"Creating Cube Dimensions"