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.
@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. |
Inventory
Opening Inventory (+)
Additions (~)
Ending Inventory (~)
The value of Inventory results only from the value of Opening Inventory. 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
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |