Returns the current member in the input dimension.
dimension.CurrentMember
OR
CurrentMember ( dimension )
dimension | A dimension specification. |
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.
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 |