@CURLEV

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