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