Summary

This concludes the section on multidimensional models in SQL Server 2019 Analysis Services. The goal has been to get you working with the tools and provide support for your next steps working with cubes. While this is by no means exhaustive, you should have a good understanding of dimensional design, multidimensional models, and MDX. These skills will allow you to create analytic solutions for the business and your users on multidimensional models. The lessons learned with MDX will support more complex calculations and queries that are commonly needed to properly report on business metrics.

The next few chapters will build out a similar model using tabular model techniques with DAX. Multidimensional models are mature and complex. You will likely discover that tabular models are easier to use but have some limitations for which multidimensional models are better suited. In the next chapter, we will dig into tabular models!