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
 

Query data using member properties.

You can use the Properties function to access member properties for dimension members.

The following query returns all Female Customer members who own four cars.

SELECT {} ON 0,
FILTER([Customer].[Customer Geography].[Customer].Members, CINT([Customer].[Customer Geography].CurrentMember.Properties("Number of Cars Owned")) = 4) ON 1
FROM [Adventure Works]
WHERE ([Customer].[Gender].[Female])



 

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