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

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