Technical data

Chapter 11 Using Built-in Functions in Analytic M odels

Note. The third and fourth arguments are optional.

Description

The FORCHILDREN function loops through all child members of a dimension’s parent member, unless you

interrupt the FORCHILDREN function with a BREAK function.

Parameters

The FORCHILDREN function takes two required a rguments and two optional arguments. The first and second

arguments are required. The third and fourth arguments are optional.

Parameter Description

Dimension The dimension to use.

Expression The expression to evaluate for each iteration.

#DIRECT, #A LL, #DETAILS This argument is optional. Select from one of these predefined constants.

Note. #DIRECT is the default constant.

Parent Member This argument is optional. If you do not use this a rgument, th e function applies to the

member that is currently being evaluated.

Example

FORCHILDREN(Region,

IF(Sales > & MaxSales,

&MaxSales := Sales;

&Region:= Member;

#DIRECT,

[Region:USA]

);

&Region;