Data Options Supported for Financial Management Forms and Ad Hoc

Starting with Smart View 11.1.2.5.500 and Financial Management 11.1.2.4.100, when opening a data form, Smart View honors all row and column suppress options set in the Financial Management web interface, overriding any row and column suppress options that may have already been set in Smart View.

Once a form is launched in Smart View, you may then override the suppress options that were set in the Financial Management interface by selecting or clearing the suppress options you require in the Data Options tab of the Options dialog box.

Note that once you launch a form in Smart View, if you choose to overwrite the form on the sheet with an ad hoc grid, the grid will reuse the suppress options that were already set for the previously-opened form. You may then override the selected suppress options as you require.

Table 28. Data Options Supported for Financial Management Forms and Ad Hoc

OptionFormsAd Hoc
Suppress Rows - No Data / MissingYesYes
Suppress Rows - ZeroYesYes
Suppress Rows - No AccessYesYes
InvalidYesYes
Underscore CharactersYesYes
Repeated MembersNoYes
Suppress Columns - No Data / MissingYesYes
Suppress Columns - ZeroYesYes
Suppress Columns - No AccessYesYes
#NoData/Missing Label - #MissingYesYes
#NoData/Missing Label - #NumericZeroYesYes
#NoAccess Label - #No AccessYesYes
#NoAccess Label - #NumericZeroYesYes
#Invalid/Meaningless -#InvalidYesYes
#Invalid/Meaningless - #NumericZeroYesYes
Submit ZeroNoNo
Display Invalid DataYesYes
Enable Essbase Format StringNoNo
Cell Display - DataYesYes
Cell Display - Calculation StatusYesYes
Cell Display - Process ManagementYesYes
Navigate Without DataYesYes
Suppress Missing blocksNoNo