Set Functions: The .AllMembers Function
User Rating: / 0
PoorBest 
Written by William Pearson   
Friday, 07 December 2007 06:12

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.

Read more...

 

Tags: 2005, article, mdx, set
 

Data Warehouse Explorer