Myloud on Wed, 08 May 2013 15:32:43

Dear gurus,

I am struggling with SSAS as this is the first time I play around with the SCOPE statement.

I am trying to build the following:

But I get:

Error 6 MdxScript(CUBE LNL DM) (9, 5) Parser: The syntax for 'THIS' is incorrect. 0 0

I tried putting the statement in a separate script but I get the same error. I do not understand as all examples of scope on the internet use that structure.

PS: I tried also with:


SCOPE([Measures].[Sales Amount]);
    THIS = 1;
And I get Error 6 MdxScript(CUBE LNL DM) (12, 1) Parser: The syntax for ';' is incorrect. 0 0

I am unable to understand the issue

Any help is appreciated and thank you so much

Miloud Bel.


Elvis Long on Fri, 10 May 2013 06:54:49

Hi Miloud,

Please switch to "Script View" model, and then use the following MDX script:

SCOPE([Measures].[Sales Amount]);

For more information about SCOPE Statement (MDX), please see:


Myloud on Mon, 13 May 2013 07:10:36

thanks for your return ! I got it now !!

Miloud Bel.

Emily Liu(xiaxianglanyu) on Tue, 19 Apr 2016 09:43:07

Hi, guy! How you resolve the problem? I am looking for solution to this issue!

MyLoudWords on Tue, 19 Apr 2016 09:45:25

Hi Emily

Use Elvis's answer, switch to script view and put your code, instead of putting it in the calculation designer it will work just fine when you switch back from script to designer view