One of the key and core functionalities in Web Intelligence is the ability to create several queries in the same report and then merge their data into one common table, crosstab, or chart.
The requirement to view different aspects of the data as well as compare different datasets enables us to analyze the data in a completely new way compared to analyzing different data levels of granularity and aggregation.
Merging data is used to address and solve many common and generic data challenges, such as:
Creating several queries that involve different sets of conditions that can't be met in the same query (for example, comparing different time frames).
Comparing and combining datasets that originated in different universes. For example, let's say we would like to analyze the sales data of our customers based on the Sales universe as well as their billing data based on the Billing universe. By performing such cross-universe reports, we will be able to analyze the billing and sales data...