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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
