LEVEL_NUMBER
This documentation is for Kyvos 2026.5.x. To view documentation for other Kyvos versions, click here. |
|---|
Description:
This function returns the number of level the given member belongs to.
Syntax:
Member_Expresion.level_number OR Member_Expresion.PROPERTIES(level_number)
Return Type:
SCALAR
Example:
WITH MEMBER [Measures].[Result] AS LEVEL_NUMBER([Dimensions].[Hierarchy].CURRENTMEMBER.level_number) SELECT [Measures].[Result] ON 0 FROM [CubeName]