Controls whether the Suppress #Missing Rows option in the spreadsheet interface 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 spreadsheet interface suppresses the display of cells for which a user has no access.
OFF—The Suppress #Missing Rows option in the spreadsheet interface 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 spreadsheet interface suppresses the display of data rows that contain only missing values. SUPNA specifies whether Essbase also suppresses the display of cells for which a user has no access. The spreadsheet interface does not provide an equivalent.
SUPNA ON
Essbase suppresses cells for which a user has no access.
SUPNA OFF
Essbase does not suppress cells for which a user has no access. These cells appear in the spreadsheet as #NoAccess. Rows of missing data are suppressed.