Multisource SQL Server and Microsoft Access

In this section, we’ll look at an example where dimensional information exists in a Microsoft Access database and sales information exists in a SQL Server database. As shown in the following illustration, the business would like to analyze sales according to new product groupings. The categories of Tennis, Golf, and Ski will be regrouped into Outdoor Recreation.


As shown in Figure 10-6, the data foundation contains only one star schema with the AggSalesCountryProductMonth fact table coming from SQL Server, along with the original dimProduct, dimCustomer, and dimPeriod tables. The dimProductMSACCESS table ...

Get SAP BusinessObjects BI 4.0 The Complete Reference 3/E now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.