Extract

The MDX Extract function for Essbase returns a set of tuples with members from the specified dimensions of the input set. This function always removes duplicates. The members in the tuples of the output set are ordered based on the dimension order specified in the input set.

Syntax

Extract ( set [, dimension ... ] )

Parameters

set: The set from which to extract tuples belonging to the specified dimension.
dimension: One or more dimensions from which to extract a set. This 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.

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

The above query returns the following result:

Table 4-63 Output Grid from MDX Example

Qtr1	Qtr2
24703	27107