Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

161

162

163

164

165

166

167

168

169

170

Chapter 11 Using Built-in Functions in Analytic M odels

Pushing Down Parent M ember Data

The following a

re examples of user functions that push down parent member data:

• AT (DIMENSION, Parent(DIMENSION), THISCUBE() * 0.2)

• AT (DIMENSION, Parent(DIMENSION), THISCUBE() / CHILDCOUNT(DIMENSION,

#DIRECT))

ATAN

Syntax

ATAN(Data)

Description

The ATAN function returns the arc-tangent of Data. The result is the angle (in radians) whose tangent equals

Data.

To convert fro

m radians to degrees, multiply by 180 / PI( ). T he PI function returns the value of PI

Returns

The arc-tangent of Data

Example

The following examples employ the ATAN built-in function:

• ATAN(0.5) ret

urns 0.463647609 (angle in radians).

• ATAN(0.5) * 18

0 / PI( ) returns 26.5650511771 (angle in degrees).

• ATAN(1) retur

ns 0.7853981634 (angle in radians).

• ATAN(1) * 180 /

PI( ) returns 45 (angle in degrees).

BREAK

Syntax

BREAK()

Description

The BREAK func tion causes an immediate break out of the current loop.

Example

SET(&Value, 1);

WHILE(&Valu

e < THE_ABSOLUTE_MAXIMUM,

SET(&Value, &Value * 2);

IF(&Value = ENOUGH_ALREADY, BREAK());

INC(&Value)

);

IF(&Value > ENOUGH_ALREADY, "More than enough", "Just right")