MDX Essentials: Basic Set Functions: Subset Functions: The
Subset() Function - Page 2 July 12, 2004 The Subset() Function
According to the Analysis Services Books Online, the Subset()
function "returns «Count» tuples from «Set» as a set, starting
at position «Start». Once we recover from the seemingly
redundant explanation that is, in fact, a pretty clear
representation of the operation of the Subset() function, we can
see that Subset() works a little like the substring
functionality that appears in various programming environments,
query languages and other places. We are focusing on tuples and
their positions relative to each other, as opposed to
characters, but the similarities in concept are perhaps easy to
recognize. As we shall see, the order of the set elements
remains intact within the operation of the function. We control
the "range" of the function by providing a count, similar to the
way we control the "reach" we obtain in other MDX functions -
and similar to the way we use the numeric expression i