Optimizing the tabular model for performance
As covered in Chapter 8, Using Aggregations to Performance Optimize a Cube, performance is of the uttermost importance when it comes to a BI system. Users do not want to wait for the query results. Fortunately, the tabular model is built for performance; however, there is still a need for optimizing the tabular model. This includes optimizing the model for both queries and processing. This section will cover the most important tasks of optimizing the tabular model.
The tabular model is, as described earlier, an in-memory model; this means that all data is stored in RAM on the server and that it does not work with aggregates. The key to ensuring good performance on tabular mode is to ensure that only data that you query or data that is used in calculations is loaded into the model.
If you examine the model that you have created, you can see that there are several columns that are not used in calculations or that will not be used in queries. If you...