Extract

Analysis Services

Analysis Services

Extract

Returns a set of tuples from extracted dimension elements.

Syntax

Extract(«Set», «Dimension»[, «Dimension»...])

Remarks

This function returns a set consisting of tuples from the extracted «Dimension» elements. This function always removes the duplicates. The Extract function performs the opposite action of the Crossjoin function.

Example

This example

Extract({([1997], Washington), ([1997], California), ([1998], California)}, Time)

returns the set

{[1997], [1998]}

See Also

Crossjoin