Applying Queries

To display the results of a query in one worksheet:

Select a node in the navigation panel.
To apply a query to the active worksheet, right-click and select Apply Query.
You can view the results of the query in the worksheet.
On the Display page of the Essbase Options dialog box, if you select Use Styles and Use Sheet Options with Query Designer, the styles you selected for dimension members are applied to the initial query results. If you do not select Use Sheet Options with Query Designer, even if you selected Use Styles, they are not applied to the initial query results. To apply styles, select Essbase, and then Retrieve.
Note:
The XLS file that results from applying the query can be saved for possible use as an Essbase data load data file.