If the hierarchy is not defined in our MDX query, default member is taken as currentMember.
Query
WITH
MEMBER [Measures].[Year's Name] AS [Time].[Calendar].CurrentMember.Name
SELECT
[Measures].[Year's Name] ON 0
FROM
[Sales]
Result
Assertion : Cell Equals
WITH
MEMBER [Measures].[Year's Name] AS [Time].[Calendar].DefaultMember.Name
SELECT
[Measures].[Year's Name] ON 0
FROM
[Sales]
If the hierarchy is defined in the slicer (aka. where clause), it is taken as currentMember.
In our example, [Time].[Calendar].CurrentMember is [Time].[Calendar].[Year].[2010]
Query
WITH
MEMBER [Measures].[Year's Name] AS [Time].[Calendar].CurrentMember.NAME
SELECT
[Measures].[Year's Name] ON 0
FROM
[Sales]
WHERE
[Time].[Calendar].[Year].[2010]
Result
Assertion : Cell Equals
WITH
MEMBER [Measures].[Year's Name] AS "2010"
SELECT
[Measures].[Year's Name] ON 0
FROM
[Sales]
CurrentMember can also be used across hierarchies of the same dimension.
In our example, all descendants of [Geo].[Canada] result in a [Economy].[Canada] currentMember. Remember [Economy] hierarchy ends at [Country] level.
Note: MSAS 2008 matches auto-exists only on attributes hierarchies (aka. one level no base hierarchy).
Query
WITH
MEMBER economy_unique_name as [Geography].[Economy].currentMember.uniqueName
SELECT
economy_unique_name on 0,
Descendants([Geography].[Geo].[Canada]) on 1
FROM [Sales]
Result
|
economy_unique_name |
| Canada |
[Geography].[Economy].[Country].&[CA] |
| Quebec |
[Geography].[Economy].[Country].&[CA] |
| Toronto |
[Geography].[Economy].[Country].&[CA] |
Assertion : Cell Equals
WITH
MEMBER economy_unique_name as [Geography].[Economy].[Canada].uniqueName
SELECT
economy_unique_name on 0,
Descendants([Geography].[Geo].[Canada]) on 1
FROM [Sales]
If the hierarchy is defined in the axis, it is taken as currentMember.
In our example, [Time].[Calendar].CurrentMember is [Time].[Calendar].[Year].[2010]
Query
WITH
MEMBER [Measures].[Q. Name] AS [Time].[Calendar].CurrentMember.Name
SELECT
subset([Time].[Calendar].[2010].Children,0,2) ON 0
FROM
[Sales]
WHERE
[Measures].[Q. Name]
Result
| Q1 2010 |
Q2 2010 |
| Q1 2010 |
Q2 2010 |
Assertion : Cell Equals
WITH
MEMBER [Measures].[Q1] AS [Time].[Calendar].[Q1 2010].Name
MEMBER [Measures].[Q2] AS [Time].[Calendar].[Q2 2010].Name
SELECT
{[Measures].[Q1],[Measures].[Q2]} ON 0
FROM
[Sales]
The Generate() iteration is defining the current member for the [Geography].[Geo] hierarchy.
Query
WITH
MEMBER [Measures].[Names] AS Generate( { [Geography].[Geo].[Continent].[America], [Geography].[Geo].[Continent].[Europe] } AS countries, [Geography].[Geo].CurrentMember.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]
CurrentMember can be applied to a named set 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.CurrentMember.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]
CurrentMember can be applied to a named set being iterated.
Query
WITH
SET [Countries] AS { [Geography].[Geo].[Continent].[America], [Geography].[Geo].[Continent].[Europe] }
MEMBER [Measures].[Names] AS Generate( [Countries], countries.CurrentMember.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]
CurrentMember can be applied to a tuple set (being equivalent to the Current() function).
Query
WITH
SET [MySet] AS { ( [Geography].[Geo].[New York], [Product].[icCube] ) }
MEMBER [Measures].[Names] AS Generate( [MySet], TupleToStr( MySet.CurrentMember ), "-" )
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]