Understanding other differences that matter

Besides the strengths and challenges called out previously, in this section, we will see the differences in how a feature is implemented or how a capability is accomplished with each of the models. The differences between the model types may or may not impact your decision on the model you will choose. The importance of these topics is to understand the differences and the effect those differences may have on your model design.

Partitioning

Partitioning is the process of separating a table into sections to improve performance or maintainability. Before we dig into the differences, you can find more about implementing multidimensional model partitions in Chapter 4, Building a Multidimensional Cube in SSAS 2019, and implementing tabular model partitions in Chapter 7, Building a Tabular Model in SSAS 2019.

So, both model types support partitions. In both models, partitioning larger tables can improve the processing time. Partitioning...