Building a query
A query is built by adding and configuring items in the Request, Filter, and Sort areas of the section. Interactive Reporting provides a significant amount of flexibility for building queries, including the ability to add custom logic into the query. Once the query is configured, the query can be processed and modified as desired.
Request items
The columns of data returned from a query are configured by adding items to the Request line. Items from the model are added to the Request line by the following two methods:
|
Right-click method |
Drag-and-drop method |
|---|---|
|
Highlight the column(s) in the table of interest. |
Highlight the column(s) in the table of interest. |
|
Right-click and select Add Selected Items. |
Drag-and-drop the columns ... |
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.
