MDX SCOPE function

• Jim Mackenzie

  Hall of Fame

  Points: 3728

  More actions

  August 5, 2013 at 5:26 am

  #297173

  Hi All,

  I've got a measure group "Daily Sales" with a number of measures in (obviously) and I'd like to divide each of the measures in the measure group depending on which attribute I've picked from my utility dimension. In my utility dimension called 'divisor' there are only 2 values "1" and "2". In the "Daily Sales" measure group let's say there are 3 measures (Sales Value, Cost, Taxes).

  Is there a quicker way than doing this:

  SCOPE

  ([Divisor].[Divisor].&[2]);

  [Measures].[Sales Value] = [Measures].[Sales Value] / 2;

  [Measures].[Cost] = [Measures].[Cost] / 2;

  [Measures].[Taxes] = [Measures].[Taxes] / 2;

  END SCOPE;

  Help much appreciated 🙂

  Cheers,

  Jim.

  SQL SERVER Central Forum Etiquette[/url]