ISINPUT

Syntax

ISINPUT (Cube)

Description

The ISINPUT function returns True if the user has entered the current value of the cube.

Example

ISINPUT(Cube with no formula) returns True.

ISINPUT(Cube with formula) returns False.

The ISINPUT function provides an easy way to filter tables so that they show input cells. The ISINPUT function takes 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.