SQL SERVER - What is SSAS Tabular Data Model and Why to Use it
Analysis services in SQL Server 2012 can be either deployed in multi-dimensional mode or tabular mode or power pivot for SharePoint as well. Tabular mode is a new enhancement in SQL Server 2012 analysis service database structure. It is a columnar database capable of incredible performance and compression ratio. At this point, there is a lot of confusion in users on why to use the tabular model when we already have multidimensional model.So, let's discuss these points first before creating a tabular model project.
Read more...Tags: introduction, tabular