As mentioned in Part 1 of this article, there are many times
your customers may want reports that combine data from different sources. In
this article we will concentrate on putting the data together in Business
Objects Business Views.
In Part 1 of this article, we showed how to combine a web
service with some sales data in our SQL Server database. We created a mock web
service and then gave a quick example of how we might then implement a real web
service from our ERP. We also had to modify our database to add a foreign key
that will allow Business Views to join the 2 different data sources.
The report we are working on shows sales data about the
books we have sold. It also includes information on where the book was
"manufactured," even though that information is not in our main
database. The data sources are set, now we just need to connect them and show
that in a report.