icCube

Documentation

VectorK

(MDX+)

Returns a Vector of numerical values, using member key value for the vector position.

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) using the member key value
to define the position in the vector (member key has to be an integer).

- VectorK( [Geography].[Country].members, [Measures].[Amount])

If for example,

[Geography].[Country].[Switzerland] , key = 0, Amount = 20
[Geography].[Country].[Spain] , key = 2, Amount = 120
[Geography].[Country].[France] , key = 3, Amount = 200

VectorK( {[Switzerland], [Spain], [France]} , [Amount] ) will return a Vector

( 20.0, 0.0, 120.0, 200.0 )

Hint : ensure the keys values are compact and ideally start on 0.

See Also

SumOn Vector VectorA VectorN

Since Version

6.0.3

XMLA Properties

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