MDX Help with prior 4 quarters

• randy.jaye

  SSCommitted

  Points: 1628

  More actions

  April 18, 2011 at 12:03 pm

  #145081

  I have been pulling my hair out over this and would appreciate any suggestions one may have. I have attached a Word document with specifics. I am trying to construct an MDX statement that will return only the 4 prior (complete) quarters. In other words, I don't want the last quarter which is out current quarter (2011 Q2). I would like to get only 2010 Q2 thru 2011 Q1.

  Thanks for any help you can lend.

• seyhunguzel

  SSC Veteran

  Points: 220

  More actions

  April 19, 2011 at 8:59 am

  #1313421

  I think this query should return sales for prior 4 quarters:

  SELECT

  NON EMPTY { [Measures].[Net Sales] } ON COLUMNS,

  NON EMPTY { ([Calendar].[Quarter].currentmember.lag(4):[Calendar].[Quarter].currentmember.lag(1)) } ON ROWS

  FROM [Marketing]