SSAS

SSAS or SQL Server Analysis Services is the multidimensional database of the Microsoft SQL Server Business Intelligence suite. It allows users to create and deploy multidimensional OLAP cubes with dimensions and measures.

This section is also about Microsoft SSAS errors, like OLAP errors or Tabular Model ones. It provides descriptions and solutions.

A tabular Model is an in-memory database to query the data in a timely manner. Mainly because the model pre-calculates the data and preload it from the database.

Indeed, the Microsoft Cubes have two different options and the latest and most used is the Tabular model. The Microsoft OLAP database allow connections from the Power BI software.

Indeed, Analysis Services instance allows the multidimensional or Tabular option, but not both.

Scroll to Top