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