First Look at Analysis Services 2005 - Professional SQL Server Analysis Services 2005 with MDX - page 51

Adventure Works DW contains sales information on a bicycle company. Fig-
ure 2-13 shows the structure of the data warehouse you build in this chapter,
which consists of two fact tables and eight dimension tables. The fact table is
highlighted at the top in the color yellow, and the dimension tables are high-
lighted in the color blue. The FactInternetSales and FactResellerSales are the
fact tables. They contain several measures and foreign keys to the dimension
tables. Both fact tables contain three dimension keys, ShipDateKey, Order-
DateKey, and DueDateKey, that are joined to the dimension table DimTime.
The FactInternetSales and the FactResellerSales fact tables join to the ap-
propriate dimension tables by a single key as shown in Figure 2-13 . The Par-
entEmployeeKey in the Employee table is joined with EmployeeKey in the
same table which is modeled as a parent-child hierarchy. You learn parent-
child hierarchies in Chapter 5 .
Figure 2-13
Create a Data Source
Cubes and dimensions of an Analysis Services database must retrieve their
data values from tables in a relational data store. This data store, typically
part of a data warehouse, must be defined as a data source. An OLE DB data
provider or .NET data provider is used to retrieve the data from the data
source. OLE DB and .NET data providers are industry standard technologies
for retrieving data from relational databases. If your relational database pro-
vider does not provide a specific OLE DB data provider or a .NET data pro-