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 |