INSUBTREE

Syntax

INSUBTREE (Dimension, Parent Member, {Child Member})

Description

The INSUBTREE function returns a boolean value identifying whether a child member is in a sub-tree that contains a parent member as its root.

Parameters

The INSUBTREE function takes two required arguments and one optional argument. The first and second arguments are required. The third argument is optional.

Parameter	Description
Dimension	The dimension to use.
Parent Member	The parent member to use.
Child Member	This optional argument tests whether the child member lies within a sub-tree that contains the parent member (as supplied in the second argument) as its root.

Example

INSUBTREE(Region, [Region:USA], [Region:Oakland]);