DEFAULTMEMBERS

Description:

This function is used to return the default member of a hierarchy.

Syntax:

Hierarchy_Expression.DefaultMember

Return Type:
MEMBER

Parameters:

Parameter	Description

Parameter	Description
Hierarchy_Expression	It is a valid MDX expression that returns a hierarchy.

Example:

WITH MEMBER Measures.x AS   
   [Destination Currency].[Destination Currency].DefaultMember.Name  
SELECT Measures.x ON 0  
FROM [AdventureWorksMF]