I found the example code for "Professional SQL Server Analysis Services 2005 with MDX", chapter 3 (Introduction to MDX) completely useless. I am doing something stupid, or the authors are somewhat careless. An example, the first MDX query in chapter 3:
SELECT Measures.[Internet Sales Amount] on COLUMNS
FROM [Adventure Works]
WHERE ( [Date].[Calendar].[Calendar Quarter].&[2004]&[1],
    [Product].[Product Line].[Mountain],
    [Customer].[Country].[Australia])
There is no cube [Adventure Works] (it should be [Adventure Works DW]), there is not measure [Internet Sales Amount] (it should be [Sales Amount]), and none of the hierarchy- or levelnames seem to be correct.

This is too much to be corrected. What am I doing wrong?

Leendert.

I am reading this book too.
You might need to 'deploy' this project "Adventure Works" to formulate the same name cube, then it starts to make sense to you.

NewBee.

Leendert,

Could you please open the sample Adventure Works DW project provided with the product and deploy it on to the Analysis Services? Then this query should work. Chapter 3 requests you to deploy the project.

Some of the MDX queries in this chapter are provided as examples to illustrate the fundamental topics. Some query results might have changed from SQL Server RTM version to Service Pack 2 due to the changes in the Adventure Works DW relational database.

Regards
Siva