EssSetSheetOptions([workbookName]sheetName, drillLevel, includeSelection, selectionOnly, onlyMode, indent, suppressMissing, suppressZeros, suppressUnderscores, missingAlias, updateMode, preserveFormulas, adjustColumns, autoSortRows, alternateNames, altNameTable, templateRetrieve, version2x)
Where [workbookName]sheetName is the text name of the workbook and worksheet in which the options occurs.
drillLevel is a number that indicates the zoom level used for reporting. The drillLevel parameters and associated action are shown in Table 35.
includeSelection is a logical value specifying whether to include the item being zoomed in upon in the report.
selectionOnly is a logical value specifying whether a zoom or keep only operation affects every identical member or only the member selected.
onlyMode is a logical value specifying whether to "Remove Unselected Groups." If TRUE, all dimension groups that are not in the selected group are removed. This option is not available if you select the "Retain on Zooms" mode option.
indent is a number that indicates the indentation level used for reporting:
suppressMissing is a logical value specifying whether rows containing only #Missing values should be reported.
suppressZeros is a logical value specifying whether rows containing only zero values should be reported.
suppressUnderscores is a logical value specifying whether underscore characters in member names should be converted to spaces.
missingAlias is a text value which is used in reporting for replacement of #Missing.
updateMode is a logical value specifying whether every retrieval locks the associated blocks at the database.
preserveFormulas is a logical value specifying whether formulas are preserved.
adjustColumns is a logical value specifying whether column widths should be adjusted after a retrieval.
autoSortRows is a logical value specifying whether members in data rows are sorted in database Outline order. The value of templateRetrieve or version2x (or both) must be TRUE for this setting to take effect.
alternateNames is a logical value specifying whether alternate names should be sent back by the server.
altNameTable is a text value specifying which alternate names table to use on the server.
templateRetrieve is a logical value specifying template retrieve mode.
version2x is a logical value specifying whether to report using Version 2.x compatibility mode.
=EssSetSheetOptions("[Sample.xls]Sheet1",2,TRUE,FALSE,FALSE,TRUE,TRUE, TRUE,TRUE,"0",FALSE,TRUE,TRUE,TRUE,"DEFAULT",FALSE,FALSE)
No additional parameters for EssSetSheetOptions are added after Essbase Release 5. Use EssSetSheetOption to set options individually.
The active spreadsheet is used when the sheetName parameter is missing.
When a parameter is missing, the active worksheet value of that parameter is used, and no error is returned.