williamweber.net
  • Home
  • About
Follow

Posts tagged Analysis Services

MDX: Scope Statement For All Measures in Multiple Measure Groups

Dec06
2011
Leave a Comment Written by Will

This was irritating me today so I thought I would share. If you need to write a scope statement that will include all the measures in multiple measure groups; perhaps you’re implementing some Time Intelligence calculations and you want to have any new measures dynamically included, then the statement looks a little something like this:

SCOPE({MeasureGroupMeasures("Internet Sales"), MeasureGroupMeasures("Reseller Sales")});

I forgot the {} the first time around and was super confused by an error message when I attempted to deploy the MDX calculation to the cube that said that said “The END SCOPE statement does not match the opening SCOPE statement.” Because my SCOPE and END SCOPE statements looked just fine to me.

  • Share this:
Posted in BI, Scripts - Tagged MDX, Scripts, SSAS

Recent Posts

  • Thoughts on Killzone 3 Multiplayer Going Free-to-Play (or is it Free-to-Pay?)
  • A Game Funding Revolution
  • Named Set Sub-totals in Excel using VisualTotals()
  • New Camera Please. – Mirrorless ILC Goodness
  • Formatting Map Legends in SQL Server 2008 R2 Reporting Services

From Twitter:

  • I thought we were past the whole "justify Apple, vilify Microsoft for the same thing" thing these days. http://t.co/u6jG58uB 5 days ago
  • Benjamin Franklin was awesome. Oh and something about Assassin's Creed 3, but who cares. http://t.co/nsEeye01 2 weeks ago
  • Ever spent an hour figuring out how to add a column of data to your warehouse only to find that it was already there? Consistent naming FTW. 2 weeks ago
  • More updates...

Posting tweet...

Powered by Twitter Tools

Categories

  • BI
  • Gaming
  • Opinion
  • Photography
  • Reporting
  • Scripts
  • Social Games
  • SQL Server
  • XNA

Archives

  • March 2012
  • February 2012
  • January 2012
  • December 2011
  • October 2011
  • September 2011
  • April 2011
  • January 2011
  • December 2009
  • July 2009
  • April 2009
  1. We welcome any feedback, questions or comments

EvoLve theme by Theme4Press  •  Powered by WordPress williamweber.net