Exploring cube functions in Microsoft Excel
There are currently seven cube functions in Excel. We will take a quick look at five of these functions and then proceed to create examples with each function. We will use the data model we created in our earlier chapter.
Of the seven cube functions, three of them are used often and serve as building blocks for the rest. These are CUBEVALUE, CUBESET, and CUBEMEMBER:
Figure 6.7 – List of cube functions in Microsoft Excel
The remaining are CUBERANKEDMEMBER, CUBESETCOUNT, CUBEMEMBERPROPERTY, and CUBEKPIMEMBER.
To help you understand how these cube functions work, it is important to know that all the functions work in a similar way by retrieving aggregated values or attributes from the data model, which we will refer to here as a cube.
Because of this, all the functions start with the same argument, "ThisWorkbookDataModel":
Figure 6.8 – Exploring the syntax...
