fbpx

Item (MDX)

Returns a tuple from a set (or a member from a tuple).

Parameters

Name Type Cardinality Default value
  set-expression  one   
  numeric-expression  one   

Return

set

Description

Returns the tuple that is in the zero-based position specified by the numeric-expression. The () operator notation can be used as well : { [Years].[2001] }(0) = Item( { [Years].[2001] }, 0 ). Note that calling item against a tuple expression instead of a set is returning the member at the specified position in the tuple.

Examples

XMLA Properties

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