SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 SSAS calculations tab SCOPE
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

grahamb
Starting Member

1 Posts

Posted - 02/14/2013 :  23:21:50  Show Profile  Reply with Quote
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

Vinothkumar
Starting Member

India
8 Posts

Posted - 02/21/2013 :  00:32:28  Show Profile  Reply with Quote
Hi Graham,

JUST YOU TRY THIS

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

Regards
Vinoth Kumar
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000