Microsoft SQL Server Analysis Services Multidimensional Model

The Multidimensional Model uses the already known cube structure to analyze business data across multiple dimensions. It is the default server mode of Analysis Services (SSAS). It runs on a query and calculation engine for OLAP data with MOLAP, ROLAP and HOLAP storage modes. The Analysis Services OLAP engine is an industry leading OLAP server that works well with a broad range of -also 3rd party- BI tools.

Working with the Multidimensional Model provides you with features like:

  • Actions, allowing you to navigate directly to a Reporting Services (SSRS) report, a URL, etc.
  • Translations
  • Perspectives, allowing you to define certain business views on your cube for certain business areas
  • Dimension Usage, allowing you to define different types of relationships with a dimension