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.
Syntax
@CURLEV (dimName)| Parameter | Description |
|---|---|
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. |
Notes
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 0.
For further discussion on levels, please refer to the Oracle Essbase Database Administrator's Guide.
Example
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
See Also