About the Query Designer

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

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.