You can specify the maximum number of calculation iterations (MaximumCalculationIterations) for all grids and cells to resolve dependencies within references in formulas in the JConsole.exe file. For information on JConsole, see the “Property Information” topic in the Oracle Hyperion Financial Reporting Workspace Administrator's Guide. During the calculation process of a grid, it may be necessary to evaluate a cell multiple times due to reference precedence. This usually occurs in grids with references to other grids. The maximum iteration property indicates the number of times a formula cell can be evaluated before it is marked as unresolved. Setting the maximum iteration property avoids the possibility of cells, with circular referencing, being evaluated an infinite amount of times. Circular referencing occurs when one cell refers to another cell, which then refers to the original cell.
If there are no circular references and calculation cells are returning #Error, you can increase the maximum iteration property value. For more information, see Oracle Hyperion Enterprise Performance Management Workspace Administrator's Guide.