The Query Designer

Data source types: Oracle Essbase, Oracle Hyperion Financial Management, Oracle Hyperion Planning, Oracle Planning and Budgeting Cloud, Oracle Financial Consolidation and Close Cloud, Oracle Hyperion Enterprise®

The Query Designer is a 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.

Related Topics:

Creating Queries

Editing Queries and Rerunning Reports

Filtering Data

Analyzing Time-Related Data in Query Designer

MDX Queries