Create offline cube files (.cub) with OlapCube. Download Now!

table of contents


Returns a subset of tuples from a specified set.


Subset(«Set», «Start»[, «Count»])


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.


The following example returns the set {USA, Canada}:

Subset({USA, Canada, France, Germany, Japan, Iceland, Peru}, 0, 2)