icCube

Documentation

SumOn

(MDX)

Returns the sum of each value of the first vector defined by the second vector positions.

Parameters

Name Type Cardinality Default value
  vector-expression  one   
  vector-expression  one   

Return

value

Description

Returns the sum of each value of the first vector defined by the second vector positions.

SumOn ( V1, V2 ) = ForEach( V2i -> V2 ; sum += V1( V2i ) )

A standard scenario for this function is defining V1 as a static function that contains the values we want to
aggregate and V2 as a measure with a vector unique aggregation type.

See Also

VectorK

Examples

Special Examples (errors, null, ...)

Since Version

6.0.3

XMLA Properties

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