Should you use tabular or multi-dimensional SSAS mode? Here's the answer!
Part one of a seven-part series of blogs

If you're building a data warehouse, you'll want to know whether you should be creating cubes using the legacy multi-dimensional Analysis Services server mode, or creating data models in the new tabular mode. This blog gives Wise Owl's take on the subject.

  1. Analysis Services - Tabular or Multi-Dimensional Model? (this blog)
  2. What the two SSAS Server modes have in common
  3. Creating a tabular model
  4. Creating and using a multi-dimensional model cube
  5. Comparing tabular model DAX with multi-dimensional MDX
  6. Other differences between multi-dimensional and tabular
  7. Conclusions and a recommendation

This blog is part of our online SSAS Tabular tutorial; we also offer lots of other Analysis Services training resources.

Posted by Andy Brown on 07 November 2015

You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.

Analysis Services - Tabular or Multi-Dimensional Model?

Up until the release of SQL Server 2012, SQL Server Analysis Services was straightforward: there was only one installation mode.  But then along came tabular ...

Installing SSAS

The choice you have to make when installing Analysis Services in SQL Server 2012 or later.  You don't get a second bite at this cherry!

This blog accordingly tries to answer the question: which server mode should you choose?

For those who want a quick answer, my recommendation is that you should use tabular if you possibly can (although if you have legacy cubes to support you may not have the luxury of choice).  However, you should read through this blog carefully to see if you agree with its arguments!

This blog has 0 threads Add post