1. Configuration Reference for Oracle Essbase
  2. Essbase Configuration Settings
  3. Config Settings List
  4. SUPNA

SUPNA

This Essbase configuration setting enables you to have Smart View or another grid client interface suppress the display of cells for which a user has no access (#NoAccess), in addition to suppressing rows with no data (#Missing).

Syntax

SUPNA ON | OFF

  • ON—The option to suppress #Missing rows also suppresses the display of cells for which a user has no access.

  • OFF—The option to suppress #Missing rows does not suppress the display of cells for which a user has no access. This is the default.

Description

SUPNA is in effect only when the Smart View option to suppress #Missing rows is selected.


Smart View's Data Option to suppress rows that contain only #Missing

You can use SUPNA configuration to have Essbase also suppress the display of #NoAccess cells.

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.