Eval (MDX)

Evaluates an expression using a subCube or set.


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




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] )

is evaluated as:

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

the default member is usually the "all" member.

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

For dimensions that do not define a many-to-many relation, Eval 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


Since Version


XMLA Properties

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