CalcStatus

CalcStatus returns the calculation status of a cell for a Oracle Hyperion Financial Managementdatabase connection. You can use CalcStatus in report headers, rows, and columns.

Note:

CalcStatus supports the current keyword.

Syntax:

<<CalcStatus("GridName", Row, Col, Page)>>

Argument	Description
GridName	Name of a grid. This value must be enclosed in quotation marks
Row	Numeric value representing the row number of the grid. The first row in a grid has an index of 1, the second row has an index of 2, and so on.
Col	Letter representing the column ID of the grid. The first column ID is A, the second column ID is B, and so on.
Page	Numeric value representing the page dimension index of the grid. The first page dimension in a grid has an index of 1, the second page dimension has an index of 2, and so on.

Oracle Fusion Forecast Management can return these calculation status values:

• OK

• OK - No data

• OK - System Changed

• Needs Subcalculate

• Needs Translation

• Needs Consolidation

• Needs Consolidation No Data

• Locked

Example:

Display the calculation status of the cell that is in row 21, column B on page 1 of Grid1:

<<CalcStatus("Grid1",21,B,1)>>