LEVEL_NUMBER

LEVEL_NUMBER

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]

 

Copyright Kyvos, Inc. 2026. All rights reserved.