I know that this is an old post, but it helped me out today. I never bothered to read up on execute().

This will work. execute (@Query + @Query1 +...

I'd like to guess that because the calculated measure had some kind of problem, the cube browser and excel could handle it by displaying an error value, but openquery could...