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

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.