Cubes in Multidimensional Models

 

Applies To: SQL Server 2016

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 provides a single place where all related data, for analysis, is stored.

A cube is composed of:

ElementDescription
DimensionsDimensions in Multidimensional Models
Measures and Measure GroupsCreate Measures and Measure Groups in Multidimensional Models
PartitionsPartitions in Multidimensional Models
PerspectivesPerspectives in Multidimensional Models
HierarchiesCreate User-Defined Hierarchies
ActionsActions in Multidimensional Models
Key Performance Indicators (KPI)Key Performance Indicators (KPIs) in Multidimensional Models
CalculationsCalculations in Multidimensional Models
TranslationsTranslations in Multidimensional Models (Analysis Services)
TopicDescription
Create a Cube Using the Cube WizardDescribes how to use the Cube Wizard to define a cube, dimensions, dimension attributes, and user-defined hierarchies.
Create Measures and Measure Groups in Multidimensional ModelsDescribes how to define measure groups.
Calculations in Multidimensional ModelsDescribes how to define and configure a calculation in an MDX script.
Actions in Multidimensional ModelsDescribes how to define and configure an action.
Perspectives in Multidimensional ModelsDescribes how to define and configure a perspective.
Defining Stored ProceduresDescribes how to work with stored procedures.

Community Additions

ADD
Show: