Cubes in Multidimensional Models
A cube is a multidimensional structure that contains information for analytical purposes; the main constituents of a cube are dimensions and measures. Dimensions define the structure of the cube that you use to slice and dice over, and measures provide aggregated numerical values of interest to the end user. As a logical structure, a cube allows a client application to retrieve values, of measures, as if they were contained in cells in the cube; cells are defined for every possible summarized value. A cell, in the cube, is defined by the intersection of dimension members and contains the aggregated values of the measures at that specific intersection.
A cube is composed of:
Element 
Description 

Dimensions 

Measures and Measure Groups 

Partitions 

Perspectives 

Hierarchies 

Actions 

Key Performance Indicators (KPI) 
Key Performance Indicators (KPIs) in Multidimensional Models 
Calculations 

Translations 
Topic 
Description 

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

Describes how to define measure groups. 

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

Describes how to work with stored procedures. 