Current (MDX)

Returns the current tuple or member (synonym of currentMember)

Parameters

Name	Type	Cardinality	Default value
	hierarchy-expression	zero-one

Return

member

Description

Allows to retrieve information about hierarchy members in the current context.

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 default members.

Current member works also across hierarchies of the same dimension. If there is a unique member of the specified hierarchy that 'exists' on the current context.

If applied to a named set it will return the current member or tuple of the set.

Since icCube 4.8, this function returns a set of members if the tuple contains two members of the same hierarchy. This functionality needs the 'dimensionalityCheck' icCube property set to false.

Since version 8.2, current works across attribute hierarchies.

Examples

hierarchy.Current - default member

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].Current.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.Current - slicer

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

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

Query

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

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]

hierarchy.Current - auto-exists

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].current.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]

hierarchy.Current - axis

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

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

Query

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

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].current.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).Current - set

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

Query

WITH
    MEMBER [MyMeasure] AS SetToStr([Geography].[Geo].current)
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).Current(0) - nth member

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

Query

WITH
    MEMBER [MyMeasure] AS [Geography].[Geo].current(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.CurrentMember - iteration

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

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.CurrentMember - iteration

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

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.CurrentMember - iteration - tuples

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].[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.Current - 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.Current.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.Current - 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.Current.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.Current - 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.Current ), "-" )
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]