After talking with several customers, I have got this question asked several times? Since Analysis Services has different modes, customers seems confused about when to use which mode. I will give short answer and guideline for initial start and I will discuss this topic in later posts.

When should I use Analysis Services Tabular Mode or Multi Dimensional Mode?

First of all, You should keep in mind that ,there is no one option here. It is not like black or white. In most of cases, you can use both of them. I just wanted to share following documents to give you good initial guideline when to consider which mode. If you have any questions, feel free to ask.

 

Comparing Tabular and Multidimensional Solutions (SSAS)

http://msdn.microsoft.com/en-us/library/hh212940.aspx

Choosing a Tabular or Multidimensional Modeling Experience in SQL Server 2012 Analysis Services

http://msdn.microsoft.com/en-us/library/hh994774.aspx

 

Thanks

 

Kagan