CurrentMember

Returns the current member in the input dimension.

Syntax

dimension.CurrentMember

OR

CurrentMember ( dimension )

dimension A dimension specification.

Description

The current member is evaluated in the context of query execution mechanics. Used in conjunction with iterative functions such as Filter, at every stage of iteration the member being operated upon is the current member.

Example

The following query selects the quarters during which sales growth is 3% or more compared to the previous month.

SELECT
Filter (
  [Year].Children,  -- outer loop
  Max (
      Except (
        [Year].CurrentMember.Children, -- current in outer loop
        { [Year].[Jan] }
      ),  
      (  [Year].CurrentMember         -- current in Max loop
       /  [Year].CurrentMember.PrevMember)
  ) >= 1.03
)
ON axis(0)
FROM Sample.Basic
WHERE ([Measures].[Sales])

Returns the grid:

Qtr2 Qtr4
101679 98141

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com