Applying Worksheet Options to Query Designer Results

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

  To enable Query Designer to use the previously set worksheet options:

  1. Select Essbase, and then Options.

  2. In Essbase Options, select Display.

  3. Select Use Sheet Options with Query Designer, and select OK.

  4. Select Essbase, and then Retrieve.

    Essbase displays the results of the query that you created in Query Designer and implements the previously set worksheet options. Aliases, instead of the numeric codes, are now displayed for the Product dimension.

    Query results with options applied.

  5. Select File, and then Close.

    Do not save the worksheet.