Chapter 8. Merging Data

In this chapter, we will cover the following recipes:

  • Merging data from several queries
  • Understanding the merge logic
  • Merging data from different universes
  • Merging data from different data sources
  • Filtering matched values
  • Troubleshooting aggregation problems
  • Extending the data synchronization

Introduction

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 ...

Get SAP BusinessObjects Reporting Cookbook 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.