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 7, and click Open. The archived Chapter 7 OLAP database is identical to the one used in Chapter 6, “MDX Values.” Click Restore, and then close the Restore Database Progress dialog box.
3.
Open the Chapter 7 HTML file included with the sample files for this book. This HTML file contains a Microsoft Office PivotTable list that retrieves values from the Sales cube of the Chapter 7 OLAP database.

Have you ever noticed that no matter how many times you travel to a location as a passenger, the route seems entirely different the first time you have to navigate—especially ...

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.