SQL Server Analysis Services - Dual Mode

SQL Server Analysis Services (SSAS) provides two options: MultiDimensional instance and Tabular instance. How to get both options available?

12/13/20231 min read

SQL Server Analysis Services - Dual Mode

During the installation of SQL Server Analysis Services you have to choose between a MultiDimensional instance or a Tabular instance. If you want to make use of both options, then you need to execute a second installation of SSAS to get a Named Analysis Services Instance in the chosen (missing) mode.