MDX query newbie question please

[locutis]

Hello,

I am just getting into writing these queries and am trying to test with a simple MDX query against a Sales cube that I've been working with through the SQL Server 2000 Analysis Services tutorial:

SELECT Measures.MEMBERS ON COLUMNS, {[Store].[Store
State].[CA], [Store].[Store State].[WA]} ON ROWS
FROM [Sales]

I keep getting this error:

"Unable to open cellset
Formula error - cannot find dimension member ("[Store].[Store
State].[CA]") - in a name binding function"

If someone could show me where I'm going wrong I'd really appreciate it. I copied this sample from the IBM help system site so I assume the syntax is correct.

Prehaps is there something else other than this query that is wrong or I need to check?

Thanks in advance,

Jean Luc

 

[Seelenfieber]

SELECT Measures.MEMBERS ON COLUMNS, {[Store].[Store
State].&[CA], [Store].[Store State].&[WA]} ON ROWS
FROM [Sales]

I think CA and WA are Members of this Dimension.

Insert & and it will work