The Display page controls the use of styles, nested displays, row suppression, the automatic adjustment of columns, automatic sorting order, display of member labels, latest period setting, and the display of aliases. It also enables you to define a label for missing values and for data that you cannot access.
None—Select to specify no member indentation (parents and children appear left-justified in the worksheet column).
Subitems—Select to specify that descendants are indented while ancestors appear left-justified in the worksheet columns.
Totals—Select to specify that ancestors are indented while descendants appear left-justified in the worksheet columns.
#Missing Label—Enables you to define a label for missing values. By default, missing values are labeled #Missing.
#No Access Level—Enables you to specify a label for data you cannot access. This option is available only when Advanced Interpretation mode is selected on the Mode page of the Essbase Options dialog box.
Missing Rows—Select to suppress the return of data rows that contain only missing values
If you select an option in the Formula Preservation group on the Mode page, the #Missing Rows option is not available.
If you clear #Missing Rows, Essbase does not redisplay #Missing data in the spreadsheet. To display #Missing again, clear the option and open another worksheet.
Zero Rows—Select to suppress the return of data rows which contain only zeros.
If you select an option in the Formula Preservation group on the Mode page, the Zero Rows option is not available
If you clear Zero Rows, Essbase does not redisplay data containing zeros in the spreadsheet. To display zero data again, clear the option and open another worksheet.
Underscore Characters—Select to suppress the display of underscore characters in member names.
Use Aliases—Select to display aliases when performing retrievals, rather than database outline member names. Aliases are alternate names for database members. You can create reports that use the database outline member name, which is often a stock number or product code, or an alias name, which can be more descriptive. Each database can contain one or more alias tables. Select the alias table from the Alias list box.
If you select Show Qualified Member Name on Sheet, the qualified name display overrides the display of aliases.
Use Both Member Names and Aliases for Row Dimensions—Select to display the member name and alias name for each row dimension member in the worksheet.
If you select the Show Qualified Member Name on Sheet, the qualified name display overrides the display of aliases
Show Qualified Member Names on Sheet—Select to view the qualified member name of duplicate members on the worksheet.
This option is only available when you are connected to a database that supports duplicate member names.
Show Qualified Member Names as Comments—Select to view the qualified member name of duplicate members when you hover the cursor over the comment indicator in a cell.
This option is only available when you are connected to a database that supports duplicate member names.
Use Styles—Select to display styles defined for members, dimensions, or data cells.
Adjust Columns—Select to automatically adjust the column widths in the spreadsheet to accommodate large member, or alias, names.
Auto Sort Rows—Select to retrieve data into symmetric rows which are sorted according to the order specified in the database outline. This option is only available when Free Form retrieve mode (but not Template Retrieve) is selected.
Repeat Member Labels—Select to repeat all member labels after a retrieve. For large spreadsheets, this may be a useful feature so that you can immediately see the member label associated with the data.
Essbase retains the repeated members in the spreadsheet even if you clear Repeat Member Labels. To suppress the repeated members from displaying in the spreadsheet, perform one action:
Alias—Displays all alias tables contained in the active database.
Use Sheet Options with Query Designer—Select to apply the options selected in the options dialog box to queries created by Query Designer.
Latest Time Period—Select to specify the latest time period for Dynamic Time Series reporting.
Latest Time Period—Displays all level 0 members for a Time dimension.