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.

Definition of SSAS concepts and MS OLAP cubes

24 November 2022

Definition and basic concepts of SSAS technology, short for SQL Server Analysis Services. The definition of the basic SSAS concepts allows for a better understanding of the functioning of MS OLAP cubes, i.e. multidimensional databases. Indeed, the Analysis Services module has been at the heart of Microsoft’s Business Intelligence suite for years. Firstly, SSAS stands for SQL Server Analysis Services. It is the part …

Tabular model error occurred while opening

12 July 2022

Visual studio error : Error occurred while opening tabular model, it occurs when opening the SSAS model on the workspace. Then Visual Studio crashes because the network connection was lost. The exact error message is something like : An error occurred while opening the model on the workspace database. For example, the local tabular model development environment lose connectivity to the repository for a …

ROLAP HOLAP and MOLAP differences

6 July 2022

What are the differences between OLAP, ROLAP, MOLAP and HOLAP SSAS cubes? They allow the implementation of data analysis systems. Also known as multidimensional databases, they allow a different approach to that of so-called relational or OLTP databases. These decision support systems provide an in-depth, aggregated and rapid view of the data. Difference between a ROLAP, MOLAP and HOLAP SSAS cubes But in practice, …

Median value of SSAS members in MDX

5 July 2022

How to calculate the median value of SSAS members in MDX in a Microsoft SSAS cube? The median function, with the MEDIAN syntax, is the only SSAS function to use. The AVG function, for example, is used to calculate member averages. Rather than inventing a calculated member that will count the distinct number of members in order to average them. Indeed, with the MDX …

Organize SSAS measures in folders with MDX

5 July 2022

How to hide and organize SSAS measures in folders with MDX code ? And allow the possibility to group them for Analysis Services end-users? Indeed, browsing an SSAS cube from Microsoft Excel or Power BI for Ad-Hoc Reporting is very convenient. However, if the list of measures calculated in MDX is several tens or hundreds of items, they must be classified. Ideally, they should …