Share via

Defining and Configuring Cubes and Cube Properties

A cube is a multidimensional structure that contains dimensions and measures. Dimensions define the structure of the cube, and measures provide the numerical values of interest to the end user. As a logical structure, a cube allows a client application to retrieve values as if cells in the cube defined every possible summarized value. Cell positions in the cube are defined by the intersection of dimension members. Dimension hierarchies provide aggregation paths within a cube. Measure values are aggregated at non-leaf levels to provide member values in the dimension hierarchies.


For more information about performance issues related to cube design, see the SQL Server 2005 Analysis Services Performance Guide.

The following table describes the topics in this section.

Topic Description

Using the Cube Wizard to Define a Cube, Dimensions, Hierarchies and Attributes

Describes how to use the Cube Wizard to define a cube, dimensions, dimension attributes, and user-defined hierarchies.

Configuring a Cube

Describes how to configure a cube and cube properties.

Defining and Configuring Dimension Usage and Dimension Relationships

Describes how to define and configure cube dimension - measure group relationships.

Defining and Configuring a Calculation

Describes how to define and configure a calculation in an MDX script.

Defining and Configuring an Action

Describes how to define and configure an action.

Defining and Configuring a Partition

Describes how to define and configure a partition.

Defining and Configuring a Perspective

Describes how to define and configure a perspective.

Working with Stored Procedures (Analysis Services)

Describes how to work with stored procedures.

Browsing Cube Data

Describes how to browse cube data using Cube Designer.

See Also

Other Resources

Working with Cubes and Cube Properties How-to Topics
Modifying Measures
Lesson 5: Defining Relationships Between Dimensions and Measure Groups
Lesson 6: Defining Calculations
Lesson 7: Defining Key Performance Indicators (KPIs)
Lesson 8: Defining Actions
Lesson 9: Defining Perspectives and Translations

Help and Information

Getting SQL Server 2005 Assistance