ISLEVEL

ISLEVEL

This documentation is for Kyvos 2026.3.x. To view documentation for other Kyvos versions, click here.

This documentation is for Kyvos 2026.3.x. To view documentation for other Kyvos versions, click here.

Description:

The MDX IsLevel function returns TRUE if the member is in a specified level.

Syntax:

IsLevel ( Member_Expression, Numeric_Expression )

Return Type:

LOGICAL

Parameters:

Parameter

Description

Parameter

Description

Numeric_Expression

The MDX member to apply the function to.

Member_Expression

The MDX member to apply the function to.

Example:

WITH MEMBER [Measures].[Result] AS ISLEVEL([Dimensions].[Hierarchy].CURRENTMEMBER, 2) SELECT [Measures].[Result] ON 0 FROM [CubeName]

 

Copyright Kyvos, Inc. 2026. All rights reserved.