Description:
This function is used to return the default member of a hierarchy.
Syntax:
Hierarchy_Expression.DefaultMember
Return Type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Hierarchy_Expression | It is a valid MDX expression that returns a hierarchy. |
Example:
| Code Block | ||
|---|---|---|
| ||
WITH MEMBER Measures.x AS
[Destination Currency].[Destination Currency].DefaultMember.Name
SELECT Measures.x ON 0
FROM [AdventureWorksMF] |