In Article 5, "Building Calculated Members, Part 1," we resumed our exploration of calculated members. We practiced the creation of dynamic calculated members, both on measure and non-measure dimensions; and compared and contrasted the two general types in a way that makes the selection and planning for real-world uses straightforward. We discussed ways of handling the creation of calculated members with MDX and practiced adding multiple members in a single MDX query. We exposed a means of controlling the order in which calculated members are solved, as well as discussing why precedence of calculation might be critical to generating expected results
In this second part of our lesson, we move into the realm of aggregation functions, practicing with cumulative totals and other uses. We will practice the creation and manipulation of queries based upon these (and many previously covered) concepts, with several hands-on exercises that build by steps to meaningful conclusions. Finally, we drew upon our exposure to member functions in earlier articles to calculate values based upon the retrieval of member properties with our calculated members, completing practice examples that demonstrate the potential value of this capability.
In this part of our lesson, we will do the following:
Review and practice handling the creation of calculated members with MDX
Create aggregate members and practice their uses, focusing on their interaction with the SUM function and various other considerations
Undertake an overview of cumulative totals, discussing their nature and uses, prior to practicing their deployment in our MDX queries
Use MDX queries to select member properties, with examples that demonstrate the potential value of this capability
Overview numerous MDX functions and characteristics, introducing new concepts as well as reviewing concepts discussed in earlier articles, where appropriate