Returns the current member in the input dimension.
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.
Syntax
dimension.CurrentMember
CurrentMember ( dimension )
Parameter | Description |
---|---|
dimension | A dimension specification. |
Notes
This function returns the child of an implied shared member instead of the member itself. To avoid this behavior when using CurrentMember in MDX formulas and calculated members, tag the parent with the "Never Share" property.
An implied share occurs when a parent has only one child, or only one child that consolidates. For more information, see "Understanding Shared Members" in the Oracle Essbase Database Administrator's Guide.
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 |