About the Query Designer

Cloud data source types: Oracle Analytics Cloud - Essbase, Planning, Financial Consolidation and Close

On-premises data source types: Oracle Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning

The Query Designer is an Oracle Smart View for Office tool from which you can design the layout of a report by selecting dimensions, members, and attributes for rows, columns, and the POV from one interface. You can use the Query Designer to create a query from a blank connected worksheet, which uses the default report as a starting point, or extract a query from a saved report. The Query Designer is available only for ad hoc worksheets.