Combining data from multiple queries
Report tables provide the ability to combine and calculate data across multiple datasets. In the Table object, fact data from multiple queries can be displayed as well as integrated through calculated items. The Report functionality allows for the integration of two or more datasets from different queries, where each dataset can contain a different level of detail.
The integration of data behaves similar to building a query with outer joins. When a table is built, the Table Dimensions may be built from only one dataset in the document. The Table Dimensions serve as a key or set of criteria for the additional data sections to follow. When adding an additional dataset fact to the document, the additional dataset ...
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.
