Share via

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

  • Article

 

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)

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

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

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

 

Thanks

 

Kagan

Comments

  • Anonymous
    November 20, 2013
    Thanks for providing no pertinent information

  • Anonymous
    May 28, 2014
    Just wanted to up vote what KS stated.

  • Anonymous
    August 28, 2014
    KS, you summed up that article well. I am surprised that the article does reference www.microsoft.com or even www.google.com as sources of information.