Returns the level number of the current member combination for the specified
dimension. This number represents the number of members that separates the
current member from its bottom-most descendant.
|dimName||Single dimension name specification. dimName must
be the name of the top-most member of the dimension. It cannot be another
member name from within the dimension.
- If the current member of the specified dimension is an implied
share member, the member level returned is the same level as the stored member.
For example, in Sample Basic, Inventory, a member of the Measures dimension,
is an implied share member:
Inventory Opening Inventory (+) Additions (~) Ending Inventory (~)
The value of Inventory results only from the value of Opening Inventory.
When Inventory is the current member @CURLEV (Measures) returns level
- For further discussion on levels, please refer to the Oracle Essbase Database Administrator’s Guide.
Given the following database structure:
Year Qtr1 Jan, Feb, Mar Qtr2 Apr, May, Jun Qtr3 Jul, Aug, Sep Qtr4 Oct, Nov, Dec
@CURLEV provides the following results for the members shown:
Formula Current Member Value Position = @CURLEV(Year); Year 2 Position = @CURLEV(Year); Qtr3 1 Position = @CURLEV(Year); Aug 0