Creating a Date Dimension in a Tabular Model
In my previous article, I explained how to create a date dimension in the SSAS multidimensional model. In this article, you will see how to create a date dimension in a tabular model. The tabular model uses an approach more similar to Excel to build the model, so most users will feel more at home with the Analytics Service (SSAS) tabular model than with the SSAS multidimensional model although there are a few limitations with the tabular model. Tabular projects and multidimensional projects have several differences as I’ll be demonstrating in this article, I will call your attention for them.