Simple MDX query

• Mackers

  SSCrazy

  Points: 2965

  More actions

  February 3, 2013 at 3:04 pm

  #1583753

  Try something along the lines of

  With Member [Measures].[Thing Count YTD] As

  Sum(YTD([Effective Date].[Year-Week].CurrentMember)

  , [Measures].[Thing Count] )

  SELECT

  [Measures].[Thing Count YTD] ON 0,

  [Effective Date].[Year-Week].[Week].[2013 Week 6] ON 1

  FROM

  [Cube]

  Mack

• s_osborne2

  SSCertifiable

  Points: 6726

  More actions

  February 4, 2013 at 1:55 am

  #1583841

  That's great thanks!

  ---

  
  MCSE: Data Platform
  MCSE: Business Intelligence
  Follow me on Twitter: @WazzTheBadger
  LinkedIn Profile: Simon Osborne

• MMartin1

  One Orange Chip

  Points: 27862

  More actions

  April 18, 2013 at 10:42 am

  #1607874

  Try this also...

  With Member [Measures].[Thing Count YTD] As

  AGGREGATE(YTD([Effective Date].[Year-Week].CurrentMember)

  , [Measures].[Thing Count] )

  SELECT

  [Measures].[Thing Count YTD] ON 0,

  [Effective Date].[Year-Week].[Week].[2013 Week 6] ON 1

  FROM

  [Cube]

  This keeps whatever it is you are counting from being double counted.

  ----------------------------------------------------