Filter on measure?

  • 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...

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply