FIRSTMEMBER
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
Description:
The function is used to return the first member of the specified level.
Syntax:
Level_Expression.FirstMember
Return Type:
MEMBER
Parameters:
Parameter | Description |
|---|---|
Level_Expression | It is a valid MDX expression that returns a level. |
Example:
SELECT
[Measures].[Internet Sales Amount] ON COLUMNS,
[Date].[Calendar].[Calendar Year].FirstMember ON ROWS
FROM [AdventureWorksMF_ValueBased]