using-tuple-functions.md

title	description	author	ms.author	ms.reviewer	ms.date	ms.service	ms.subservice	ms.topic	ms.custom
Using Tuple Functions	Using Tuple Functions	kfollis	kfollis	kfollis	02/17/2022	sql	analysis-services	reference	mdx

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 [!INCLUDEssASnoversion].

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]

See Also

Functions (MDX Syntax)
Using Member Functions
Using Set Functions