Both in Sql2K as well as Yukon beta the following MDX fails because of
the ' in Coor's Beer.
//============================================
With
Member [Measures].[aMeasure] as
'
// Coor's Beer
1'
Select [Measures].[AllMembers] on 0
From [aCube]
//============================================

John

Guess thats a good catch.

But these work correctly..

With Member [Measures].[aMeasure] as '
// Coor''s Beer
1'
Select [Measures].[AllMembers] on 0
From [aCube]

With Member [Measures].[aMeasure] as
// Coor's Beer
'1'
Select [Measures].[AllMembers] on 0
From [aCube]

Cheers,
Sanka