SetToStr (MDX)

Returns a string with the members of the set concatenated using their unique name.

Parameters

Name	Type	Cardinality	Default value
	set-expression	one

Return

string

Description

Returns a string with the members of the set concatenated using their unique name.

The set { [Geography].[Geo].[France], [Geography].[Geo].[United States] } is transformed into this string :

"{[Geography].[Geo].[Country].&[FR],[Geography].[Geo].[Country].&[US]}"

Note there is no guarantee how the unique name is going to be generated (e.g. using keys). You can use Generate function to have a better control on how exactly the resulting string should be.

Examples

SetToStr(member-set)

V
{[Geography].[Geo].[Country].&[FR],[Geography].[Geo].[Country].&[US]}

SetToStr(member) - implicit conversion example

V
{[Geography].[Geo].[Country].&[CH]}

Special Examples (errors, null, ...)

SetToStr({}),SetToStr(NULL)

Returns "{}" if applied to NULL entity or an empty set.

Query

WITH
    MEMBER [Measures].[V] AS SetToStr( {} )
SELECT
    [Measures].[V] ON 0
FROM
    [Sales]

Result

V
{}

{}

Assertion : Cell Equals

WITH
    MEMBER [Measures].[V] AS SetToStr(NULL)
SELECT
    [Measures].[V] ON 0
FROM
    [Sales]

Assertion : Cell Equals

WITH
    MEMBER [Measures].[V] AS "{}"
SELECT
    [Measures].[V] ON 0
FROM
    [Sales]

SetToStr(string)

XXX
#ERROR : (OLAP_FUNCTION_ARGUMENT_TYPE_MISMATCH)

XMLA Properties

Find here the value of the XMLA properties when not specified otherwise.