SUPNA

Command

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).

Syntax

SUPNA ON | OFF

ONThe Suppress #Missing Rows option in the Hyperion Essbase Spreadsheet Add-in suppresses the display of cells for which a user has no access.
OFFThe 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.

Description

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.

Example

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.