Microsoft® SQL Server™ 2000 Analysis Services Step by Step

Start the Lesson

1.	In the Analysis Manager console tree, right-click the server and click Restore Database. Navigate to the folder containing the sample files for this book, select the Chapter10 archive file, and click Open. Click Restore, and then click Close in the Restore Database Progress dialog box.

An OLAP cube is always associated with a fact table from the warehouse database. A fact table usually contains many rows—at least hundreds of thousands and possibly millions or billions. The size of the fact table clearly has a large impact on the amount of time it takes to process a cube. In contrast, most dimension tables are relatively small. It’s a rare dimension table that contains more than ten thousand rows. One would expect dimension ...