Extract

Returns a set of tuples with members from the specified dimensions of the input set.

Syntax

Extract ( set [, dimension ... ] )

set The set from which to extract tuples belonging to the specified dimension.
dimension One or more dimensions from which to extract a set.

Description

This function always removes duplicates. The dimension argument should specify dimensions present in the input set. It is an error to specify a dimension that is not present in the input set. The members in the tuples of the output set are ordered based on the dimension order specified in the input set.

Example

In the following example, Extract returns a subset of only those tuples belonging to the Year dimension.

SELECT
 Extract(
         {
           ([Year].[Qtr1], [Market].[California]), 
           ([Year].[Qtr1], [Market].[Oregon]), 
           ([Year].[Qtr2], [Market].[Oregon])
         }, Year
 )
ON COLUMNS
FROM Sample.basic
Qtr1 Qtr2
24703 27107

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com