Book Image

SAP BusinessObjects Reporting Cookbook

By : Yoav Yohav
Book Image

SAP BusinessObjects Reporting Cookbook

By: Yoav Yohav

Overview of this book

Table of Contents (21 chapters)
SAP BusinessObjects Reporting Cookbook
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Merging data from different data sources


Another common and useful scenario is merging data from different sources.

Besides the universe structure and BEx queries, we can find the Excel and text file data sources almost in every information environment.

Using Excel files comes with the job as it is one of the most common and useful data sources for business users' working environments.

Using Excel as the data source in Web Intelligence reports enables the business user to centralize different data sources with their different look and feel in the same table as well as enjoy the preferable drag-and-drop capabilities of Web Intelligence.

The data stored in the Excel files could originate from a filesystem, a daily automatic output, an ERP or a CRM system, or a local file of one of the business users.

Using the merge logic, we will be able to create one table out of several different data sources.

Getting ready

We will use an Excel file containing the estimated quantity sold per line of products....