1. Administrator's Guide
  2. Managing Forms
  3. Creating Simple Forms
  4. Setting Form Layout
  5. Setting Form Grid Properties

Setting Form Grid Properties

Form grid properties set the general form row and column display.

To set form grid properties:

  1. Open the form, and then click Layout.
  2. In Grid Properties, set general row and column properties using the information in this table:

    Table 6-3 Form Grid Properties

    Option Description

    Suppress missing blocks

    (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.

    Suppress missing data

    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.

    Default row height

    • Medium

    • Size-to-Fit: Force all rows to fit in the displayed space

    • Custom: Select a custom size in pixels for the row height

    Default column width

    • Small: Display seven decimal places

    • Medium: Display 10 decimal places

    • Large: Display 13 decimal places

    • Size-to-Fit: Force all columns to fit in the displayed space based on the top data cell value.

    • Custom: Select a custom size to display more than 13 decimal places, up to 999 places

    Enable Autosave

    Selecting this option has these effects in a simple form:

    • When planners move out of a cell, their changes are automatically saved, with no prompt or message. Cell values are aggregated to their parents, and the affected cells are displayed with a green background.

    • Planners can successively undo actions with Ctrl+Z.

    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 Oracle Essbase configuration setting ASODYNAMICAGGINBSO.

    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.
  3. Click Save to save your work and continue, or click Finish to save your work and close the form.