Setting Smart View Form Options

Specify options for form display in Oracle Smart View for Office.

To set Smart View form options:

  1. Open the form, and then click Layout.
  2. Select Smart View Options, and then settings such as:

    Table 24-18 Smart View Options

    Option Description

    Disable spreading

    Disables spreading options in Smart View, including default spreading, spreading data for time periods, spreading using grid spread, and spreading using mass allocations.

    Disable formatting

    When selected, the formatting definition for a form is not included when the form is opened in Smart View.

    Repeat member labels

    Allows repeated member labels in forms.

    If this setting is cleared, you may override it in Smart View to allow repeated members in forms by selecting Repeat Member Labels in the Smart View Options dialog, Formatting tab.

    For forms with Enable drop-down for dimensions selected (Segment property), the form layout will automatically behave as if the Repeat member labels option is selected, regardless of whether or not it is selected.

    For flex forms (see Enable flex form for rows and Enable flex form for columns below), the Repeat member labels option is automatically enabled and cannot be cleared.

    Disable sheet protection

    Disables protection on data cells in forms in Smart View.

    Allows users to enter or paste data into cells, but does not allow users to submit the changed data.

    By default, this option is cleared.

    Enable flex form for rows

    Enables the form as a flex form on rows in Smart View.

    When this option is enabled, the Repeat member labels option is automatically enabled, and cannot be cleared.

    See Designing Flex Forms.

    Enable flex form for columns

    Enables the form as a flex form on columns in Smart View.

    When this option is enabled, the Repeat member labels option is automatically enabled, and cannot be cleared.

    See Designing Flex Forms.

    Show invalid members for flex form

    Retains invalid members on the flex form sheet after a refresh in Smart View.

    Invalid members can be the result of:

    • Mistyping or misspelling a member name

    • Errors when copying and pasting member names from one sheet to another, or within the same sheet

    • Entering a member name that is beyond the form definition

    When this check box is enabled, invalid members are retained on the sheet upon Refresh and highlighted, making them easy to find and correct.

    See Designing Flex Forms.

  3. Click Save to continue, or Finish to save and close the form.