Applied to a named set (of members) being iterated as declared within a function parameter.
Query
WITH
MEMBER [Measures].[Names] AS Generate( { [Geography].[Geo].[Continent].[America], [Geography].[Geo].[Continent].[Europe] } AS countries, countries.Current.Name, "-" )
SELECT
[Measures].[Names] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Names] AS "America-Europe"
SELECT
[Measures].[Names] ON 0
FROM
[Sales]
Applied to a named set (of members) being iterated.
Query
WITH
SET [Countries] AS { [Geography].[Geo].[Continent].[America], [Geography].[Geo].[Continent].[Europe] }
MEMBER [Measures].[Names] AS Generate( [Countries], countries.Current.Name, "-" )
SELECT
[Measures].[Names] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Names] AS "America-Europe"
SELECT
[Measures].[Names] ON 0
FROM
[Sales]
Applied to a named set (of tuples) being iterated.
Query
WITH
SET [MySet] AS { ( [Geography].[Geo].[New York], [Product].[icCube] ) }
MEMBER [Measures].[Names] AS Generate( [MySet], TupleToStr( MySet.Current ), "-" )
SELECT
[Measures].[Names] ON 0
FROM
[Sales]
Result
| Names |
| ([Geography].[Geo].[City].&[New York],[Product].[Article].&[icCube]) |
Assertion : MDX Equals
WITH
MEMBER [Measures].[Names] AS "(" + [Geography].[Geo].[City].&[New York].uniqueName + "," + [Product].[Prod].[Article].&[icCube].uniqueName + ")"
SELECT
[Measures].[Names] ON 0
FROM
[Sales]