Form grid properties set the general form row and column display.
Watch this video to learn about setting form grid properties in Planning.
In Grid Properties, set general row and column properties using the information in this table:
Table 11. Form Grid Properties
Option | Description |
---|---|
(Rows only) Improves the performance of the Suppress missing data setting when suppressing many rows, for example, 90% or more. The Suppress missing blocks setting can degrade performance if few or no rows are suppressed. Test forms before and after using this setting to determine whether performance is improved. Also test forms whenever you make significant changes to your application. With this setting selected, attributes may not display in forms, certain suppressed blocks may ignore Dynamic Calc members, and row members do not display as indented. | |
Hides rows or columns without data. Clear to display rows or columns with “#MISSING” in cells when data is missing. | |
Suppress invalid data | Hides rows or columns with invalid data. Clear to display rows or columns that contain cells with data that is invalid. Cells with invalid data are read-only. |
| |
| |
Global Assumptions Form | To enable transferring global assumptions from a test to a production environment for a simple form, select Global Assumptions Form. Then update the form to store global assumptions such as a tax rate. See Designing Forms with Global Assumptions. |
Enable Autosave | Selecting this option has these effects in a simple form in the simplified interface:
Note: For optimal Autosave performance, you must have only dense dimensions on rows and columns. However, if you must put a sparse dimension on either a row or a column, for improved Autosave performance on block storage databases, enable hybrid aggregation with the Essbase configuration setting ASODYNAMICAGGINBSO. See also About Autosave. |
Run Form Rules on Autosave | If Enable Autosave is selected, this option becomes available. If Run Form Rules on Autosave is selected, dynamically calculated cells that depend on the changed and saved cell values (for example, a row that has a member formula that calculates a percentage of an aggregated parent value) are also updated and are displayed with a green background . |
Click Save to save your work and continue, or click Finish to save your work and close the form.