SSAS

Definition of SSAS concepts and MS OLAP cubes

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

SSAS

Tabular model error occurred while opening

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

SSAS

ROLAP HOLAP and MOLAP differences

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

SSAS

Median value of SSAS members in MDX

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