Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Filter on measure? Expand / Collapse
Author
Message
Posted Saturday, October 13, 2012 3:34 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, August 11, 2014 4:32 AM
Points: 91, Visits: 549
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
Posted Monday, October 15, 2012 3:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, January 13, 2014 7:34 AM
Points: 117, Visits: 499
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 »

Add to briefcase

Permissions Expand / Collapse