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 |
|---|---|
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:
| Code Block | ||
|---|---|---|
| ||
SELECT
[Measures].[Internet Order Quanlity] on 0,
NONEMPTY(
[Product].[Product Categories].CurrentMember
, [Measures].[Average RateM]) ON 1
FROM [AdventureWorksMF] |