Applied to a named set (of members) being iterated as declared within a function parameter.
Query
WITH
MEMBER [Measures].[Ordinals] AS Generate( { [Geography].[Geo].[Continent].[America], [Geography].[Geo].[Continent].[Europe] } AS countries, countries.CurrentOrdinal, "-" )
SELECT
[Measures].[Ordinals] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Ordinals] AS "1-2"
SELECT
[Measures].[Ordinals] 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].[Ordinals] AS Generate( [Countries], countries.CurrentOrdinal, "-" )
SELECT
[Measures].[Ordinals] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Ordinals] AS "1-2"
SELECT
[Measures].[Ordinals] 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].[Ordinals] AS Generate( [MySet], MySet.CurrentOrdinal, "-" )
SELECT
[Measures].[Ordinals] ON 0
FROM
[Sales]
Result
Assertion : MDX Equals
WITH
MEMBER [Measures].[Ordinals] AS "1"
SELECT
[Measures].[Ordinals] ON 0
FROM
[Sales]