Hi,

I begin with Analysis Services and I'd like to know if it is possible to
include a condition on a property member in the where clause...
I don't really have the choice, the only parameter I know to request the
cube is a property member and not a member, the environment is SQL Server
2000.

Thanks for your help !

Julien wrote:
I have used the filter function on rows or columns to do what I think
you are after.

Here is a foodmart example that displays the 1997 sales for all
California customers who are Female:

SELECT
{ [Time].DEFAULTMEMBER } ON COLUMNS ,
{ Filter(DESCENDANTS( [Customers].[State Province].&[CA],
[Customers].[Name] ),
[Customers].CurrentMember.Properties("Gender")="F") } ON ROWS
FROM [Sales]
WHERE ( [Measures].[Unit Sales] )