icCube

Documentation

Vector

(MDX+)

Returns a Vector of numerical values.

Parameters

Name Type Cardinality Default value
set  set-expression  one   
value  numeric-expression  one   
limit  numeric-expression  zero-one   
flag  EXCLUDEEMPTY|INCLUDEEMPTY  zero-one  INCLUDEEMPTY 

Return

value

Description

This function creates a vector object of numerical values (double). Different syntax might be used :

- Vector( [Geography].[Country].members, [Measures].[Amount])
- Vector( [Geography].[Country].members, [Measures].[Amount],3) , ensures vector is not larger than 3

Once the vector has been created you might call different methods :

Vector(..)->max(),Vector(..)->min(). See VectorN for examples of available operations.

See Also

VectorA VectorN Matrix

Examples

XMLA Properties

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