Set Functions: The AddCalculatedMembers() Function
In this lesson, we will introduce AddCalculatedMembers(), a basic, but highly useful, set function in the MDX toolset. The general purpose of AddCalculatedMembers() is to retrieve the base members of a specified set, together with all sibling calculated members.
AddCalculatedMembers() can be leveraged in a wide range of activities, from the generation of simple lists to the support of sophisticated conditional and other calculations and presentations. We will introduce the function, commenting upon its operation and touching upon creative effects that we can employ it to deliver. As a part of our discussion, we will: