Setting Essbase Options

Before you begin the tutorial, ensure that the spreadsheet options are set to the initial settings described in the following procedure. If your option settings differ, the illustrations presented in this chapter may not match the spreadsheet view.

  To set Essbase options:

  1. From the Excel menu, select Essbase, and then Options.

  2. In Essbase Options, select Display, and then select only these options:

    • Indentation—Totals

    • Cells—Adjust Columns

    • Replacement—#Missing Label: N/A

    • Aliases

      • Use Aliases

      • Aliases—Default

    • Query Designer—Use Sheet Options with Query Designer

    • Dynamic Time Series—Latest Time Period: May

    Clear all other Display options.

  3. Select Zoom, and then select only these options:

    • Zoom In—Next Level

    • Member Retention—Include Selection

    • Sampling Percentage—100

    Clear all other Zoom options.

  4. Select Mode, and select only the Advanced Interpretation options.

    Clear all other Mode options.

  5. Select Style and make sure that no options are selected.

  6. Select Global, and then select only these options:

    • Mouse Actions—Select all mouse action options

    • Memory—Enable Flashback

    • Display Messages

      • Warnings

      • Display Unknown Members

    • Log Files—Select all log file options

  7. Click OK.