SSAS calculations tab SCOPE - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Analysis Server and Reporting Services (2008)

SSAS calculations tab SCOPE

Author

Topic

grahamb
Starting Member

1 Post

Posted - 2013-02-14 : 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

Vinothkumar
Starting Member

8 Posts

Posted - 2013-02-21 : 00:32:28

Hi Graham,

JUST YOU TRY THIS

SCOPE([Measures].[Test], *);
THIS = [Measures].[Test] * 1000;

Regards
Vinoth Kumar

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources