- Administering Financial Consolidation and Close
- Managing Forms
- Creating Simple Forms
- Setting Form Grid Properties
Setting Form Grid Properties
To set form grid properties:
- Open the form, and then click Layout.
-
In Grid Properties, set row and column properties as
follows:
Table 17-3 Form Grid Properties
Option Description Suppress missing blocks On multiple rows: Greatly improves the efficiency of Suppress missing data. This option can degrade performance if no or few rows are suppressed. Test forms before and after using this setting to determine if performance is improved. Note that if you use this option:
-
Some suppressed blocks may ignore Dynamic Calc members
-
Row members may not indent
Suppress missing data Hide rows or columns without data. Clear to display rows or columns with "#MISSING" in cells when data is missing. Suppress invalid data Hide 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
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. Suppress invalid Scenario/Time Periods Hide invalid Scenario/Time Periods. Suppress Missing also Suppresses Zero When this option is selected along with the Suppress missing data option for forms, all rows or columns containing both #Missing and zeroes are suppressed.
When selected, this setting overrides the runtime suppression selections made for suppressing missing data or zeroes in Oracle Smart View for Office
Remove Form Suppressions in Ad Hoc
Select to allow Smart View users to perform ad hoc analysis on a form that has other suppression options specified. If there is missing data on the form, the base dimension members for the columns or rows are displayed on the ad hoc grid in Smart View. This allows users to continue ad hoc analysis on the form, even though suppression options were enabled in form design.
Note:
Selecting this option does not override any suppression options users may have set in the Smart View Options dialog, Data Options tab. If the Remove Form Suppressions in Ad Hoc option is enabled for the form, and users see an error when performing ad hoc analysis on the form, then they should clear the suppression options in Smart View.
Enable Calc On the Fly When you select this option, in Forms 2.0, when you hover over a cell with a member formula attached, you see the member formula associated with the cell and you can perform calc on the fly. Calc on the fly allows you to perform calculations without having to submit your changes. -
- Click Save to save your work and continue, or click Finish to save your work and close the form.