O'Reilly logo

SAP BusinessObjects Reporting Cookbook by Yoav Yahav

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Merging data from several queries

In this recipe, we will learn and explain in depth how to merge data as well as about the dimension merging capabilities and behavior. Creating several queries from the same universe can help us resolve many data issues that can't be answered by using a single query:

  • If the queries contain contradicting sets of conditions that require separation.
  • Different time frames.
  • Requirement to perform the union of two sets of data without the limitations of combined queries.
  • Using different granularity data that can't be combined in a single query (monthly aggregative data and daily data).
  • Using the outer join logic—depending on the database, the data warehouse design, and the universe structure, for some business questions, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required