I am getting an error when I am trying to create a set on member Properties -

I have Case Dimension and "Total Indemnity" is a member property of the Case
Dimension.

Please refer to the following statement -

SET [TotalIndemnity_Set] AS
'{Val([Case].CurrentMember.Properties("Total Indemnity")) >= 5000} '


--
Thanks,
Bipin Patil

Typically, you would use Filter() to apply a filter condition to members
of an unfiltered set, like:

'Filter([Case].[Case].Members,
Val([Case].CurrentMember.Properties("Total Indemnity")) >= 5000)'

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***