Technical data

ManualsBrandsSimplicity ManualsDo-It-Yourself tools4564

141

142

143

144

145

146

147

148

149

150

Creating Rules, Formul as, and User Functions Chapter 10

Predefined Constant Definition

#ALL

Use this predefined c o nstant as the last argument of the CHILDCOUNT or

FORCHILDREN functions to return all of a dimension memb er’s children,

including grandchildren. If you do not specify a dimension m e mber, this constant

returns all of the children and grandchildren of the dime nsio n member th at is

attached to the data cube t hat is currently being calculated.

Note. You can also use the #DETAILS or #DIRECT predefined constants as th e

last argument for the CHILDCOUNT or FORCHILDREN functions.

See C

hapter 11, “Using Built-in Functions in Analytic Models,” CHILDCOUNT,

page 145 andChapter11,“UsingBuilt-inFunctionsinAnalyticModels,”

FORCHILDREN, page 156.

#BLANK

A blank value. Use this constant to test wheth er a value in a data cube is blank or to

return a blank value as a result.

#DETAILS

Use this predefined constant with trees as the last argument of the CHILDCOUNT

or FORCHILDREN functions to return only the dimensio n members that are

details. If you do n ot specify a dim ension member, this constan t returns only th e

details of the d im ension member that is attached to the data cub e that is currently

being calculated.

Note. You can also use the #ALL or #DIRECT predefined constants as the last

argument for the CHILDCOUN T or FORCHILDREN functions.

See C

hapter 11, “Using Built-in Functions in Analytic Models,” CHILDCOUNT,

page 145 andChapter11,“UsingBuilt-inFunctionsinAnalyticModels,”

FORCHILDREN, page 156.

#DEFAULT

Use this predef ined constant as the l ast condition in a CASE function to retu rn a

default result when all other cond itions are false. For exam ple:

CASE(Condition 1 : Result 1, Condition 2 : Result 2,⇒

#DEFAULT : Default Result)

See Chapter 11, “Using Built-in Functions in Analytic Models,” CASE, page 144.

#DIRECT

Use this predefined constant with trees as the last argument of the CHILDCOUNT

or FORCHILDREN fu nctions to return a dimension member’s direct children only.

If you do not specify a dimension m e m ber, this constant returns only the direct

children of the d im ension member that is attached to the data cube that is currently

being calculated.

Note. You can also use the #ALL or #DETAILS predefined constants as the last

argument for the CHILDCOUN T or FORCHILDREN functions.

See C

hapter 11, “Using Built-in Functions in Analytic Models,” CHILDCOUNT,

page 145 andChapter11,“UsingBuilt-inFunctionsinAnalyticModels,”

FORCHILDREN, page 156.

The value o f e (2.7182818285), w hich is the b ase of natural logarithms.

#FALSE

A false value. Use this constant to test whether a data cube is false or to return a

false value as a result.