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.

Since Version

6.0.3

XMLA Properties

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