Overview of Query Designer
Query Designer is a component of Spreadsheet Add-in. Query Designer replaces Retrieval Wizard for creating queries for reports. You can also use Query Designer to view attributes in reports.
Note: | Excel query functionality is not supported in Spreadsheet Add-in. Use Query Designer to define database queries. |
Use Query Designer to:
Create and modify worksheet queries.
Specify which dimensions display in rows and columns.
Quickly select members and attributes to view in reports.
Filter members to create more detailed reports.
Analyze data in reports by sorting, ranking, and filtering data.
Topics in this section: