ContextMember (MDX+)

Returns the context member of a hierarchy including the Subquery content

Parameters

Name	Type	Cardinality	Default value
	hierarchy-expression	zero-one

Return

member

Description

Allows to retrieve information about hierarchy members in the current context. This function is a slight modification from the 'standard' currentMember function.

The context is defined as following:

1) the calculated member's tuple context ( e.g ( [Time].[2010], [Measures].[Year Diff.] ) )
2) the tuple being iterated (e.g., Sum,(), ...). Note Eval() function has no current tuple.
3) the cell tuples from the axes being evaluated.
4) the slicer content.
5) the subSelect content.
6) the default members.

As a difference to the currentMember function, the contextMember will not work across hierarchies and will
use the subQuery definition.

Examples

hierarchy.contextMember - default member

If the hierarchy is not defined in our MDX query, default member is taken as contextMember.

Query

WITH
    MEMBER [Measures].[Year's Name] AS [Time].[Calendar].contextMember.Name
SELECT
    [Measures].[Year's Name] ON 0
FROM
    [Sales]

Result

Year's Name
2010

Year's Name

2010

Assertion : Cell Equals

WITH
    MEMBER [Measures].[Year's Name] AS [Time].[Calendar].DefaultMember.Name
SELECT
    [Measures].[Year's Name] ON 0
FROM
    [Sales]

hierarchy.contextMember - slicer

If the hierarchy is defined in the slicer (aka. where clause), it is taken as contextMember.

In our example, [Time].[Calendar].contextMember is [Time].[Calendar].[Year].[2011]

Query

WITH
    MEMBER [Measures].[Year's Name] AS [Time].[Calendar].contextMember.NAME
SELECT
    [Measures].[Year's Name] ON 0
FROM
    [Sales]
WHERE
    [Time].[Calendar].[Year].[2011]

Result

Year's Name
2011

Year's Name

2011

Assertion : Cell Equals

WITH
    MEMBER [Measures].[Year's Name] AS "2011"
SELECT
    [Measures].[Year's Name] ON 0
FROM
    [Sales]

hierarchy.contextMember - SubQuery

If the hierarchy is defined in the SubQuery (aka. subselect), it is taken as contextMember.

In our example, [Time].[Calendar].contextMember is [Time].[Calendar].[Year].[2010]

Query

WITH
    MEMBER [Measures].[Year's Name] AS [Time].[Calendar].contextMember.NAME
SELECT
    [Measures].[Year's Name] ON 0
FROM
( Select [Time].[Calendar].[Year].[2010] on 0 from [Sales] )

Result

Year's Name
2010

Year's Name

2010

Assertion : Cell Equals

WITH
    MEMBER [Measures].[Year's Name] AS "2010"
SELECT
    [Measures].[Year's Name] ON 0
FROM
    [Sales]

Assertion : Cell Equals

WITH
    MEMBER [Measures].[Year's Name] AS [Time].[Calendar].contextMember.NAME
SELECT
    [Measures].[Year's Name] ON 0
FROM
    [Sales]
FILTERBY [Time].[Calendar].[Year].[2010]

hierarchy.contextMember - auto-exists

ContextMember does not work across hierarchies like currentMember

Query

WITH
    MEMBER economy_unique_name as [Geography].[Economy].contextMember.uniqueName
SELECT
     economy_unique_name on 0,
     Descendants([Geography].[Geo].[Canada])  on 1
FROM [Sales]

Result

	economy_unique_name
Canada	[Geography].[Economy].[ALL]
Quebec	[Geography].[Economy].[ALL]
Toronto	[Geography].[Economy].[ALL]

Assertion : Cell Equals

WITH
    MEMBER economy_unique_name as [Geography].[Economy].defaultMember.uniqueName
SELECT
     economy_unique_name on 0,
     Descendants([Geography].[Geo].[Canada])  on 1
FROM [Sales]

hierarchy.contextMember - axis

If the hierarchy is defined in the axis, it is taken as contextMember.

In our example, [Time].[Calendar].contextMember is [Time].[Calendar].[Year].[2010]

Query

WITH
    MEMBER [Measures].[Q. Name] AS [Time].[Calendar].contextMember.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]

hierarchy.contextMember - iteration

The Generate() iteration is defining the contextMember 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].contextMember.Name, "-" )
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

Result

Names
America-Europe

Names

America-Europe

Assertion : MDX Equals

WITH
    MEMBER [Measures].[Names] AS "America-Europe"
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

(Same Hierarchy Tuple).contextMember - set

When the tuple contains multiple members of the same hierarchy the contextMember function will return a set.

Query

WITH
    MEMBER [MyMeasure] AS SetToStr([Geography].[Geo].contextMember)
SELECT
    [Geography].[Geo].[Continent].[America] on 0,
    [Geography].[Geo].[Continent].[Europe] on 1
FROM [SALES]
WHERE [MyMeasure]

Result

	America
Europe	{[Geography].[Geo].[Continent].&[America],[Geography].[Geo].[Continent].&[Europe]}

Assertion : MDX Equals

WITH
    MEMBER [MyMeasure] AS "{" + [Geography].[Geo].[Continent].[America].uniqueName +  ","+  [Geography].[Geo].[Continent].[Europe].uniqueName + "}"
SELECT
    [Geography].[Geo].[Continent].[America] on 0,
    [Geography].[Geo].[Continent].[Europe] on 1
FROM [SALES]
WHERE [MyMeasure]

(Same Hierarchy Tuple).contextMember(0) - nth member

When the tuple contains multiple members of the same hierarchy the contextMember(n) function will return the Nth member of the set.

Query

WITH
    MEMBER [MyMeasure] AS [Geography].[Geo].contextMember(0).name
SELECT
    [Geography].[Geo].[Continent].[America] on 0,
    [Geography].[Geo].[Continent].[Europe] on 1
FROM [SALES]
WHERE [MyMeasure]

Result

	America
Europe	America

Assertion : MDX Equals

WITH
    MEMBER [MyMeasure] AS [Geography].[Geo].[Continent].[America].name
SELECT
    [Geography].[Geo].[Continent].[America] on 0,
    [Geography].[Geo].[Continent].[Europe] on 1
FROM [SALES]
WHERE [MyMeasure]

as-named-set.contextMember - iteration

contextMember 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.contextMember.Name, "-" )
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

Result

Names
America-Europe

Names

America-Europe

Assertion : MDX Equals

WITH
    MEMBER [Measures].[Names] AS "America-Europe"
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

named-set.contextMember - iteration

contextMember 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.contextMember.Name, "-" )
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

Result

Names
America-Europe

Names

America-Europe

Assertion : MDX Equals

WITH
    MEMBER [Measures].[Names] AS "America-Europe"
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

named-set.contextMember - iteration - tuples

contextMember can be applied to a tuple set (being equivalent to the contextMember() function).

Query

WITH
    SET    [MySet] AS { ( [Geography].[Geo].[New York], [Product].[icCube] ) }
    MEMBER [Measures].[Names] AS Generate( [MySet], TupleToStr( MySet.contextMember ), "-" )
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

Result

Names
([Geography].[Geo].[City].&[New York],[Product].[Prod].[Article].&[icCube])

Names

([Geography].[Geo].[City].&[New York],[Product].[Prod].[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]

as-named-set.contextMember - member

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.contextMember.Name, "-" )
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

Result

Names
America-Europe

Names

America-Europe

Assertion : MDX Equals

WITH
    MEMBER [Measures].[Names] AS "America-Europe"
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

named-set.contextMember - member

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.contextMember.Name, "-" )
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

Result

Names
America-Europe

Names

America-Europe

Assertion : MDX Equals

WITH
    MEMBER [Measures].[Names] AS "America-Europe"
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

named-set.contextMember - tuple

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.contextMember ), "-" )
SELECT
    [Measures].[Names] ON 0
FROM
    [Sales]

Result

Names
([Geography].[Geo].[City].&[New York],[Product].[Prod].[Article].&[icCube])

Names

([Geography].[Geo].[City].&[New York],[Product].[Prod].[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]

Special Examples (errors, null, ...)

hierarchy.contextMember - Error on multiple members

If the context as more than one member for the parameter hierarchy it will return an error.

Query

WITH
    MEMBER [Measures].[Year's Name] AS [Time].[Calendar].contextMember.NAME
SELECT
    [Measures].[Year's Name] ON 0
FROM [Sales]
FILTERBY {[Time].[Calendar].[Year].[2010],[Time].[Calendar].[Year].[2011]}

Result

Year's Name
#ERROR : (OLAP_CONTEXT_MEMBER_MULTIPLE_MEMBERS)

Year's Name

#ERROR : (OLAP_CONTEXT_MEMBER_MULTIPLE_MEMBERS)


Error Code    : OLAP_CONTEXT_MEMBER_MULTIPLE_MEMBERS
Error Message : Context returns multiple members, a single member or none is expected (you can use contextMembers(0) or contextMembers instead)

null.contextMember