Export (0) Print
Expand All
Collapse the table of content
Expand the table of content
Expand Minimize

Item (Member) (MDX)

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:


Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft