Using Tuple Functions
A tuple function retrieves a tuple from a set or retrieves a tuple by resolving the string representation of a tuple.
Tuple functions, like member functions and set functions, are essential to negotiating the multidimensional structures found in Analysis Services.
There are three tuple functions in MDX, Current (MDX), Item (Tuple) (MDX) and StrToTuple (MDX). The following example query shows how to use of each of them:
WITH
//Creates a set of tuples consisting of Years and Countries
SET MyTuples AS [Date].[Calendar Year].[Calendar Year].MEMBERS * [Customer].[Country].[Country].MEMBERS
//Returns a string representation of that set using the Current and Generate functions
MEMBER MEASURES.CURRENTDEMO AS GENERATE(MyTuples, TUPLETOSTR(MyTuples.CURRENT), ", ")
//Retrieves the fourth tuple from that set and displays it as a string
MEMBER MEASURES.ITEMDEMO AS TUPLETOSTR(MyTuples.ITEM(3))
//Creates a tuple consisting of the measure Internet Sales Amount and the country Australia from a string
MEMBER MEASURES.STRTOTUPLEDEMO AS STRTOTUPLE("([Measures].[Internet Sales Amount]" + ", [Customer].[Country].&[Australia])")
SELECT{MEASURES.CURRENTDEMO,MEASURES.ITEMDEMO,MEASURES.STRTOTUPLEDEMO} ON COLUMNS
FROM [Adventure Works]