Technical data

Using Built-in Functio ns in Analytic Models Chapter 11
When a formula uses the INPUT function, the analytic calculation engine evaluates the formula for a particular
cell to determine whether it should be an input cell. As long as the input condition in the formula refers to
input cubes and member re f erences, no recalculation is necessary to ensure that the correct cells are treated as
input cells.
The INPUT func
tion works a lot like the RETURN function; it causes the analytic calculation engine to stop
evaluating th
e formula and to immediately return a value, which in this c ase is the current value of the cell.
The INPUT fun
ction works like RETURN(SELF( )), and additionally makes the cell editable.
See Also
Chapter 5, “Creating Data Cubes,” Input Data Cubes, page 32 and Chapter 11, “Using Built-in Functions in
Analytic Models,” ISINPUT, page 166.
INSUBTREE
Syntax
INSUBTREE(Dimension, Parent Member,{Child Member})
Description
The INSUBTREE function returns a boolean value identifying whether a child member is in a subtree that
contains a parent member as its root.
Parameters
The INSUBTRE
E function takes two required arguments and one optional argument. The first and second
arguments a
re 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 mem ber lies within a subtree that
contains the parent mem ber (as supplied in the second argument) as its root.
Example
INSUBTREE(Region, [Region:USA], [Region:Oakland]);
ISINPUT
Syntax
ISINPUT(Cube)
Description
The ISIN
PUT function returns True if the user has entered the current value of the cube.
Example
ISINPUT(Cube with no formula) returns True.
166 Copyright © 1988-2007, Oracl e. All rights reserved.