|
grahamb
Starting Member
1 Posts |
 Posted - 02/14/2013 : 23:21:50
|
Hi, I'm wondering if anyone can help with some scope syntax in the calculations tab. I'm trying the following:
/* Calculate the entire cube first.*/
CALCULATE;
/* This SCOPE statement defines the current subcube */
SCOPE([Geography theft].[State LGA hierarchy].MEMBERS,
[Measures].[Test], *);
/* This expression sets the value of the Amount measure */
THIS = [Measures].[Test] * 1000;
END SCOPE;
It dies at the semi-colon following the calculate command. What am I doing wrong?
I'm using SQL Server 2008 Standard Edition
Thanks
Graham |
Edited by - grahamb on 02/14/2013 23:25:06
|
|
SSAS calculations tab SCOPE
