Technical data

Chapter 11 Using Built-in Functions in Analytic M odels
ISINPUT(Cube with formula) returns False.
The ISINPUT fun
ction provides a n easy way to filter tables so that they show input cells. T he ISINPUT
function take
s a single argument, which must be a cube.
To work well with filter functions, the function maps totals to the first member of the dimension if a first
member exists. Because the row filters are not aware of members in the columns—and vice versa—the
analytic calculation engine usually evaluates totals in formulas. The analytic calculation engine already bends
the total mapping rules for filters for this reason; the behavior of ISINPUT is just an extension of this behavior.
INTERCEPT
Syntax
INTERCEPT(Dimension, Y, X, {Condition})
Description
The INTERCEPT function returns the Y-intercept of the line that has the closest fit to the points represented
by Y and X. (The Y-intercept is the point at which the line crosses the Y axis.) If Condition is omitted, the
function fits the line to all of the members in Dimension.IfCondition is included, the function fits the
line only to those members that meet the condition.
Use the INTER
CEPT function together with the SLOPE function to find the line with the closest fit to a set of
points. You
can u se these functions to analyze a historical trend, and then use the trend to make forecasts. For
interestin
g examples of how to use these functions, see the entry for the SLOPE function.
Returns
The Y-intercept of the line that has the closest fit to the points represented by Y and X. (The Y-intercept is
the point at which the line crosses the Y axis.) If Condition is omitted, the function fits the line to all of
the members in Dimension.IfCondition is included, the function fits the line only to those members that
meet the condition.
See Also
Chapter 11, “Using Bui lt -i n Functions in Analytic Models,” SLOPE, page 189
IRR
Syntax
IRR(Dimension, Cash Flow, {Guess}, {Condition})
Description
The IRR fun
ction returns the Internal Rate of Return for Cash Flow. Gues s can b e omitted (or zero) in m ost
cases. If I
RR is unable to find the Internal Rate of Return, it returns an error value. In such cases, you can use a
nonzero Gu
ess to nudge IRR toward the correct answer.
Note. Some cash flows have no valid Internal Rate of Return, i n which case IRR returns an error value for
any Guess.
If Condition is omitted, the function uses all values of Cash Flow.IfCondition is included, the function uses
only those values of Cash Flow for w hich Condition is True.
Copyright © 1988-2007, Oracl e. All rights reserved. 167