Filter on measure?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Data Warehousing » Analysis Services » Filter on measure?

Filter on measure?

Rate Topic

Display Mode

Topic Options

Author

Message

Ognjen Kovacevic

Posted Saturday, October 13, 2012 3:34 PM

SSC Journeyman

Group: General Forum Members
Last Login: Monday, May 13, 2013 12:28 PM
Points: 91, Visits: 492

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

Post #1372473

Mackers

Posted Monday, October 15, 2012 3:17 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 3:58 AM
Points: 117, Visits: 458

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

Post #1372615

« Prev Topic | Next Topic »

Permissions