September 1, 2015 at 2:11 pm
Hi,
I've been working a lot with SSIS and now decided to learn a bit about SSAS. I have a project where it looks like having the data (currently in star schema) in the cube would help users.
I am very new to SSAS so not very clear where to begin.
I started reading up online and the 1st thing many say one needs to decide when building a cube is whether to go with "Multi-Dimensional" or "Tabular". This document compares between the two: https://msdn.microsoft.com/en-us/library/Hh212940(v=sql.110).aspx, but being new to SSAS I am not sure what most of these mean.
Our DBA says that "Multi-Dimensional" model is soon to be deprecated, and so the suggestion is not to use it, but the comparison shows that it has many more features as compared to "Tabular".
What are the suggestions from the folks using SSAS on a regular basis?
Please advise.
Thank you!
September 2, 2015 at 3:15 am
tabular is new and in memory ,but less features
you can find the difference between two,
url is here :https://msdn.microsoft.com/en-us/library/hh212940.aspx
microsoft say they will not Replace each other ,so you can choose one,based on your require
September 3, 2015 at 5:21 pm
In my opinion, your DBA's comments are premature. The two technologies (Multidimensional and Tabular) are very different. In order to make the best decision, it will be important to know what the requirements are from your end users. Things to consider would be: Data Volumes, Relationships and Access Methods.
Multidimensional is definitely not going away.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply