Microsoft® SQL Server™ 2000 Analysis Services Step by Step

The Structure of a Data Warehouse

Analysis Services makes it easy for a client application to create reports that use multiple dimensions, but the values displayed in the report ultimately come from a relational data warehouse. Because Analysis Services assumes that you already have a relational data warehouse, this book does not deal with the often agonizing issues involved in gathering clean data into a relational warehouse but simply includes sample relational data warehouses to work from. Whether you create your own relational warehouse, get a corporate database administrator to build one for you, or use one that already exists, at some point you will need to link Analysis Services to the relational warehouse. So, to use Analysis Services ...