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

PARENT_LEVEL

The distance of the member's parent from the root level of the hierarchy. The root level is zero.

Syntax 

Member_Expression.PARENT_LEVEL

Input Parameters

N/A

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.PARENT_LEVEL = 0, NULL, [Measures].[salesamount1])