icCube

Documentation

ElementValue

(MDX+)

Returns the value of an element of a VectorA or MatrixA.

Parameters

Name Type Cardinality Default value
matrix/vector  expression  one   
tuple  tuple-expression  zero-one   

Return

numeric-value

Description

This function returns the value of an element of a MatrixA or VectorA. The function can work
with index values for a Matrix or Vector or with a tuple value.

MatrixA().ElementValue() -> returns the element value using the current tuple to find for a matching element
MatrixA().ElementValue( ([United Kingdom], [2010]) ) -> returns the element value matching both members, null if no matching is found

VectorA().ElementValue() -> returns the element value using the current tuple to find for a matching element ( get current member of the [Geography] hierarchy)
VectorA().ElementValue( [United Kingdom]) -> returns the element value matching the specified member, null if no matching is found

See Also

MatrixA VectorA SetAxes

Examples

Since Version

4.8

XMLA Properties

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