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 must contain columns that match the columns used in the Table Dimensions, where the column names and datatypes are exactly the same. As Facts are added from additional datasets, the data displayed from the additional data sections are only the figures...