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 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

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 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

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 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,

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 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

SSAS

Organize SSAS measures in folders with MDX

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