Item (Member) (MDX)

Updated: 17 July 2006

Returns a member from a specified tuple.

Tuple_Expression.Item( Index )


A valid Multidimensional Expressions (MDX) expression that returns a tuple.


A valid numeric expression that specifies the specific member by position within the tuple to be returned.

The Item function returns a member from the specified tuple. The function returns the member found at the zero-based position specified by Index.


The following example returns [1999]:

([1999],Sales, [2000],Sales).Item(0)

The following example returns [1996], if [1996] is the first member in the Year level of the Fiscal hierarchy in the Time dimension:


Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.