Summary
In this chapter, we explored a flexible option to bring or retrieve your measures from your data model using cube formulas. You know that cube formulas are a flexible way to create summary reports for your dashboards when PivotTables do not give you the flexibility you want.
In this chapter, we learned about the key differences between regular PivotTables and data model PivotTables and understood how an MDX query works to retrieve information from our data model.
We explored definitions and examples of five cube functions: CUBEVALUE, CUBEMEMBER, CUBESET, CUBESETCOUNT, and CUBERANKEDMEMBER, and how we can use them in our dashboards. You know now that it is possible to add dynamic array functions to cube functions to make your formula output more dynamic.
We will put all these together to create an interactive dashboard in the next chapter.
