Query options
Multiple query options can be set in a Query section to modify the results returned from a query. The Query Properties window, as shown in the following screenshot, is opened by double-clicking the word Request in the Request line, or by clicking on the Query menu and selecting Query Options:
The commonly used features of this window are the Process options contained in the Process box. The following is a breakdown of each Process property:
- The Return Unique Rows option is used to pull back a distinct list of values for the defined query.
- The Return First property limits the results returned from a query to a subset of rows. This feature ...
Get The Business Analyst's Guide to Oracle Hyperion Interactive Reporting 11 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
