DEFAULTMEMBERS
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
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:
WITH MEMBER Measures.x AS
[Destination Currency].[Destination Currency].DefaultMember.Name
SELECT Measures.x ON 0
FROM [AdventureWorksMF]