ITEM() function - MDX

Written by Amit Gupta on 15 August 2010. Posted in MDX

«Set».ITEM( «String Expression»[, «String Expression»...] | «Index» )

According to Documentation...

The Item function returns a tuple from the specified set. There are three possible ways to call the Item function:

If a single string expression is specified, the Item function returns the specified tuple.
If more than one string expression is specified, the Itemfunction returns the tuple defined by the specified coordinates. The number of strings must match the number of axis, and each string must identify a unique hierarchy.
If an integer is specified, the Item function returns the tuple that is in the zero-based position specified by Index.

Lets understand this by example: