DOCUMENTATIONAPI REFERENCEAI-Link
DownloadsSupport
Loading search results...
Working with CubesCreating CubesModeling Cube MeasuresAdd Calculated MeasuresMDX ReferenceLEVEL_NUMBER

LEVEL_NUMBER

The distance of the member from the root of the hierarchy. The root level is ALL level and has a LEVEL_NUMBER of zero.

Syntax 

Member_Expression.LEVEL_NUMBER

Input Parameters

None

Return Value

Integer

Example

Don't display sales amount at the Year level, however, display sales amount at all other levels.

IIF([Order Date Dimension].[Order Retail445].currentMember.LEVEL_NUMBER = 1, NULL, [Measures].[salesamount1])