Enabling Spreadsheet Options with Query Designer

You can apply the spreadsheet options that you set in the Essbase Options dialog box to the results of a Query Designer query.

  To enable spreadsheet options with Query Designer:

  1. Select Essbase, and then Options.

  2. In Essbase Options, select Display.

  3. Select Use Sheet Options with Query Designer.

  4. Click OK.