Home      Functions     Common Solutions      Contact     






MDX Functions:
 
MDX Functions

 
Common Solutions

Common Solutions
 
Resource Links

MDX Books
MDX Related Software
MDX Related Blogs
 
Other Links

Contact Us
 

Return a set based on a range of values.

You can use the Filter function to return a set whose values are between a specified range.

The following query returns the Product members that have a Sales Amount between $20,000 and $30,000 (for all time).

SELECT {[Measures].[Sales Amount]} ON 0,
FILTER([Product].[Product].Members, [Measures].[Sales Amount] > 20000 AND [Measures].[Sales Amount] < 30000) ON 1
FROM [Adventure Works]



 

 
Copyright 2008 by MDXpert.com.
 
Terms of Use                              Privacy Statement
 
Site Powered By - WinHost.Com