@CURLEV

The @CURLEV calculation function for Essbase returns the current level number.

This function 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)

Parameters

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.

Example

Given the following time dimension 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