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


table of contents

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, Iceland, Peru}, 0, 2)