CURRENTMEMBER

Description:

This function is used to return a reference to the current member (in calculation or query context) for that dimension.

Syntax:

Hierarchy_Expression.CurrentMember

Return Type:
MEMBER

Parameters:

Parameter	Description

Parameter	Description
Set_Expression	It is a valid MDX expression that returns a set.
Numeric_Expression	A valid numeric expression is typically an MDX expression of cell coordinates that returns a number.

Example:

SELECT 
  [Measures].[Internet Order Quanlity] on 0,
  NONEMPTY(
 [Product].[Product Categories].CurrentMember
 , [Measures].[Average RateM]) ON 1
FROM [AdventureWorksMF]