Cube Objects (Analysis Services - Multidimensional Data)

Applies to: SQL Server Analysis Services Azure Analysis Services Fabric/Power BI Premium

Introducing Cube Objects

A simple Cube object is composed of: basic information, dimensions, and measure groups. Basic information includes the name of the cube, the default measure of the cube, the data source, the storage mode, and others.

The Dimensions collection contains the actual set of dimensions used in the cube from the database dimensions colection. All dimensions have to be defined in the dimensions collection of the database before being referenced in the cube. Private dimensions are not available in Microsoft SQL Server SQL Server Analysis Services.

Measure groups are sets of measures in the cube. A measure group is a collection of measures that have a common data source view and a common set of dimensions. A measure group is the unit of process for measures; measure groups can be processed individually and then browsed.

In this section

Topic
Actions (Analysis Services - Multidimensional Data)
Aggregations and Aggregation Designs
Calculations
Cube Cells (Analysis Services - Multidimensional Data)
Cube Properties - Multidimensional Model Programming
Cube Storage (Analysis Services - Multidimensional Data)
Cube Translations
Dimension Relationships
Key Performance Indicators (KPIs) in Multidimensional Models
Measures and Measure Groups
Partitions (Analysis Services - Multidimensional Data)
Perspectives