SUPNA specifies whether the Suppress #Missing Rows option in the Hyperion Essbase Spreadsheet Add-in suppresses the display of cells for which a user has no access (in addition to suppressing #MISSING
rows).
SUPNA ON | OFF
ON | The Suppress #Missing Rows option in the Hyperion Essbase Spreadsheet Add-in suppresses the display of cells for which a user has no access. |
OFF | The Suppress #Missing Rows option in the Hyperion Essbase Spreadsheet Add-in does not suppress the display of cells for which a user has no access. The default is OFF. |
The Suppress #Missing Rows option in the Hyperion Essbase Spreadsheet Add-in (Essbase Options dialog box, Display page) suppresses the display of data rows that contain only missing values. SUPNA specifies whether or not Hyperion Essbase also suppresses the display of cells for which a user has no access. The Spreadsheet Add-in does not provide an equivalent for the SUPNA option.
SUPNA ON
Hyperion Essbase suppresses cells for which a user has no access, in addition to suppressing rows that contain only missing data.
SUPNA OFF
Hyperion Essbase does not suppress cells for which a user has no access. These cells appear in the spreadsheet as #NoAccess. Only rows that contain missing data are suppressed.
Copyright (c)1991-2000 Hyperion Solutions Corporation. All rights reserved.