Extract

Return to: Calculated Member Builder Function List

Returns a set of tuples from extracted dimension elements. The opposite of Crossjoin.

Syntax

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

Remarks

Returns a set consisting of tuples from the extracted «Dimension» elements. This function always removes the duplicates. This function is the opposite of the Crossjoin function.

Example

Extract({([1997], WA), ([1997], CA), ([1998], CA)}, Time)

returns the set

{[1997], [1998]}