@CURRMBR

This function returns the member that is currently being calculated in the specified dimension (dimName). This function can be used as a parameter of another function, where that parameter is a single member or a list of members.

Syntax

@CURRMBR (dimName)

Parameters

dimName: A single dimension name.

Notes

You cannot use this function in a FIX statement.
You cannot use this function on the left-hand side of a formula.
The time required for retrieval and calculation may be significantly longer if this function is in a formula attached to a member tagged as Dynamic Calc or Dynamic Calc and Store.

Caution:

If you use this function to return a member name which is then concatenated with other names to get a final member name, it may result in an invalid member name, depending on the current intersection being calculated. For example: @MEMBER(@CONCATENATE(@NAME (@CURRMBR ("Account")),"_Total"))

Example

In the Sample Basic cube,

@CURRMBR(Year);

returns Jan if the current member of Year being calculated is Jan.

As a more complex example, consider the following formula in the context of the Sample Basic database. Assume that the Measures dimension contains an additional member, Average Sales.

"Average Sales"
        (IF(@ISLEV(Product,0))
        Sales;
        ELSE
        @AVGRANGE(SKIPNONE,Sales,@CHILDREN(@CURRMBR(Product)));
        ENDIF;);

This formula populates each upper-level member of the Product dimension (100, 200) at Average Sales. To calculate Average Sales, the Sales values for the level 0 members of Product are averaged and placed in their respective parent members. The Average Sales values for the level 0 Product members are the same as the Sales values, as specified by the IF statement in the calculation script.

This example produces the following report:

          Jan        New York       Actual                
              Sales        Average Sales        
              =====        =============          
100-10          5               5       
100-20         10              10       
100-30         15              15       
  100          30              10       
200-10         20              20       
200-20         25              25       
200-30         30              30       
200-40         35              35       
  200         110              27.5     
  300         #MI             #MI
  400         #MI             #MI       
  Diet         35              11.67    
Product       140              35