what's wrong in this code mdx?

Question

I wonder what's wrong in this code?

with 
member [CA Espagne] As
((select        [Measures].[CA], [[Site].[Pays - Site].[Pays].&[ES]))
select      {[Measures].[CA], [CA Espagne]} on 0, 
            [Temps].[Année - Mois - Jour].[Année].&[20100101].children on 1
from        [DistrisysOLAP_Global];

Answer 1

Better to tell us the error you're getting... but I guess you should simply define your calculated member as :

with member [CA Espagne] As ( [Measures].[CA], [[Site].[Pays - Site].[Pays].&[ES] )

then the remaining of the statement looks ok (remove the trailing ; ). Otherwise, here is a page explaining the syntax of the calculated members.