Analysis Services
Subset
Returns a subset of tuples from a specified set.
Syntax
Subset(«Set», «Start»[, «Count»])
Remarks
This function returns «Count» tuples from «Set» as a set, starting at position «Start». «Start» is zero-based: 0 corresponds to the first tuple in the set, 1 corresponds to the second, and so on. If «Count» is not specified, all tuples from «Start» to the end of the set are returned.
Example
The following example returns the set {USA, Canada}:
Subset({USA, Canada, France, Germany, Japan, England, Peru}, 0, 2)