Next in This Series
In this article, we resumed our exploration of calculated members where we left off in the previous article. We practiced the creation of dynamic calculated members, both on measure and non-measure dimensions, comparing and contrasting the two general types in a way that makes selection and planning for real-world uses straightforward in most respects. 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 our next article, "Building Calculated Members, Part 2," we will 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 concepts with several hands-on exercises that build by steps to meaningful conclusions. Finally, we will draw upon our exposure to member functions in earlier lessons 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.