icCube

Documentation

Eval

(MDX)

Evaluates an expression using a subCube or set.

Parameters

Name Type Cardinality Default value
  subcube|set-expression  one   
  numeric-expression  one   

Return

numeric-value

Description

Evaluates the numeric expression using only the data defined by the subCube or set.

Eval( SubCubeComplement( [Geography].[Switzerland] ), [Measure].[Amount] )

When evaluating the expression, can be a calculated member, all tuples evaluations will be performed
on the defined subCube.

If the second parameter is a set, it will be converted to a SubCubeUnion of the set. Also, the currentMember of the
hierarchy will be reset to the default members (since 6.8). So

Eval( {[Geography].[Switzerland],[Geography].[France]}, [Measure].[Amount] )

it's evaluated as:

Eval( {[Geography].[Switzerland],[Geography].[France]}, ([Geography].defaultMember,[Measure].[Amount]) ) , default is usually the All member

Note, this reset is not done when a SubCube is used in the first parameter.

For dimensions that does not define a many-to-many relation it is equivalent to the Aggregate function. We would advise using this function instead of the standard MDX function as it is more robust and works also on many-to-many relations. On top you can use all the features of the SubCube function family.

SubCubeOthers is not supported.

See Also

Aggregate SubCubeComplement SubCubeIntersect SubCubeMinus SubCubeSymDifference SubCubeUnion

Examples

Since Version

5.1.1

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.