When you install SSAS, there are 2 main options the Multidimensional model (that did not change too much from the original version of SQL 2005 and the tabular model which started on SQL Server 2012.
The multidimensional model is a more mature model that is harder to learn for newbies. By the other hand, tabular is simpler, but it is memory-dependent. Microsoft tried to create a powerful Excel in the tabular model. So, Excel users may feel easier to learn and create projects with tabular models.
Posted Date:- 2021-09-27 23:26:26