Set Functions: The .AllMembers Function
In this lesson, we will introduce a basic, but highly useful, set function in the MDX toolset, the .AllMembers function. The general purpose of .AllMembers is to return a set composed of all members within a specified dimensional level or hierarchy. The set returned includes all calculated members contained within the specified level or hierarchy. .AllMembers 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.