Filter on measure?

• Ognjen Kovacevic

  SSC-Addicted

  Points: 496

  More actions

  October 13, 2012 at 3:34 pm

  #147630

  I have a cube with measures and dimensions. Now, one of reports which I need to create must have filter on measure - for example: show only data where amount (which is measure, of course) is > 1000. Is it possible to achieve?

  Thanks.

  p.s. I would like not to create separate data source view with filter there beacuse this amount is input from customer...

• Mackers

  SSCrazy

  Points: 2935

  More actions

  October 15, 2012 at 3:17 am

  #1549037

  You can use the HAVING function

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

  NON EMPTY { DESCENDANTS( [Date].[Date Hierarchy].[Year].&[2012], [Date].[Date Hierarchy].[Month] ) }

  HAVING [Measures].[Net Revenue] > 100000

  ON ROWS

  FROM [CUBE]

  Mack