Item (Member) (MDX)

Item (Member)

Switch on low bandwidth view

Community Content

In this section

Statistics Annotations (0)

Click here to expand

Collapse All

Language Filter

Other versions are also available for the following:

SQL Server 2005

SQL Server 2008 Books Online (June 2009)

Item (Member) (MDX)

Returns a member from a specified tuple.

Syntax

Tuple_Expression.Item( Index )

Arguments

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

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

Remarks

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

Example

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:

Time.Fiscal.Year.Members.Item(0)

Reference

MDX Function Reference (MDX)

Help and Information

Getting SQL Server 2008 Assistance