SSAS: Unified Dimensional Model

Definition

The Unified Dimensional Model (UDM) is the model for data in a SQL Server Analysis Services (SSAS) database. The UDM is unified because it combines data from multiple relational databases into a single place and a single model. The model describes its data using dimensions, hence it is a dimensional model.

Components

 The UDM comprises these main components:

• [[articles:Analysis Services Data Source|Data Source]]
• [[articles:Data Source View]]
• [[articles:Dimension]]
• [[articles:Measure Group]]
• [[articles:Cube]]
• [[articles:Perspective]]
• [[articles:KPI]]

Community Resources

• "Introduction to the Unified Dimensional Model" (article at MSDN) 

See Also

• SQL Server Analysis Services (SSAS)
  • Unified Dimensional Model
• SQL Server Overview

Other Languages

This article is also available in the following languages:

Brazilian Portuguese (pt-BR)

• Modelo Dimensional Unificado (pt-BR)

German (de-DE)

• Unified Dimensional Model (de-DE)