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 or not Analytic Services also suppresses the display of cells for which a user has no access. The spreadsheet interface does not provide an equivalent for the SUPNA option.
SUPNA ON
Analytic Services suppresses cells for which a user has no access, in addition to suppressing rows that contain only missing data.
SUPNA OFF
Analytic Services 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.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |