Start the Lesson

1.
Start Analysis Manager. Right-click the server, and click Restore Database.
2.
Navigate to the folder containing the sample files for this book, select Chapter 6, and click Open. Click Restore, and then close the Restore Database Progress dialog box. The archived Chapter 6 OLAP database contains a Sales cube identical to the one you created in Chapter 3, “Dimension and Cube Editors,” but without calculated and derived measures.

A spreadsheet is an effective tool for analyzing numbers, allowing you to create extremely flexible formulas. A spreadsheet gets very cumbersome, however, when you’re dealing with large masses of data or when you need to organize the values differently.

A database is an effective tool for storing ...

Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step 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.