@CURLEV

The @CURLEV() 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)

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

For further discussion on levels, please refer to the 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

@CURGEN
@LEV