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.
Note
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. |
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. |
Describes how to define and configure a calculation in an MDX script. |
|
Describes how to define and configure an action. |
|
Describes how to define and configure a partition. |
|
Describes how to define and configure a perspective. |
|
Describes how to work with stored procedures. |
|
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