SUPNA
This Essbase configuration setting controls
whether the Suppress #Missing Rows option in Smart View or another grid client interface suppresses the display of cells for which a
user has no access (in addition to suppressing #MISSING
rows).
Syntax
SUPNA ON | OFF
-
ON—The Suppress #Missing Rows option suppresses the display of cells for which a user has no access.
-
OFF—The Suppress #Missing Rows option does not suppress the display of cells for which a user has no access. This is the default.
Description
The Suppress #Missing Rows option in Smart View or other grid clients 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.
Example
SUPNA OFF
For all databases on the server, Essbase does not suppress cells for which a user has no access. These cells appear in the grid as #NoAccess. Rows of missing data are suppressed.