Home > OLAP Dialog Boxes and Wizards > Create/Edit Cube Dimension:...
![]() Previous |
![]() Next |
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:
Standard: Identifies business items such as products or customers, but not time periods or measures.
Time: Identifies time periods. The dimension must have end date and time span attributes:
End date identifies the last day in each time period.
Time span identifies the number of days in each time period.
If a dimension has time periods for its members but does not have these attributes, then you can define the dimension as a standard dimension. However, you cannot use a standard dimension to perform time-based analysis. Time dimensions must also have at least one level to be usable in time series calculations.
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:
Measure Dimension: A standard dimension that lists the names of the measures in the cube. A measure dimension enables you to generate a specific calculated measure for all the measures in the cube in one step.
None: The class type of all other dimensions, which are not measure dimensions.
Sort Attribute: Identifies a sorting method. All methods sort alphanumerically within the parent.
<Default>: Sorts the dimension members.
LONG_DESCRIPTION: Sorts the long description attributes.
SHORT_DESCRIPTION: Sorts the short description attributes.
Use these options to customize the sort order:
Ascending: Sorts from lowest to highest.
Descending: Sorts from highest to lowest.
Nulls First: Lists nulls first in the sort order. Otherwise, nulls appear last.
Related Topics