Myloud on Wed, 08 May 2013 15:32:43
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:
CALCULATE ; SCOPE([Measures].[Sales Amount]); THIS = 1; END SCOPE;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
Elvis Long on Fri, 10 May 2013 06:54:49
Please switch to "Script View" model, and then use the following MDX script:
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 !!
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
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
See other lastest posts
- What is the best way to automate the update of a web.config file in a webapp resource ?
- Site instability and slow access
- ASP.NET Web API and OAuth with local (Desktop Browser/Cordova/Phonegap) client
- Deploying a NodeJS App to Azure Websites fails on installing NPM packages from pagages.json from deploy.cmd
- IP address 126.96.36.199 is blacklisted
sql server datamining
- Forecasting with Neural Networks
- In a view, I want to add a column that isn't in the table I'm selecting from that I name and has 1 set value for each record in the view
- Importing 300 DBF files in SQL Server
- No suggestions when mining in Business intelligent studio
- run openquery(mdx) through a linked server