WITH Member [Measures].[P_Type_Dim Name] as
'[P_Type_Dim].currentmember.properties("Pr Id")'
SELECT {
([Measures].[P_Type_Dim Name], [Scenario_Dim].[Actual])
} ON COLUMNS,
filter( { [P_Type_Dim].Members}, ([Measures].[P_Type_Dim Name],
[Scenario_Dim].[Actual]) <> 104 ) ON ROWS
FROM P_cube


([Measures].[P_Type_Dim Name], [Scenario_Dim].[Actual]) gives me list like
101, 102, 103......

I want to filter such a way that not to display 104. I added a filter as
above. I got an error
Formula error - Property name is not valid: "pr Id"

But if I remove the filter condition it works fine.

Once this resolved I have to do conditional filter. Help me!

Thanks,
Sam

A couple of things to check:

- If [P_Type_Dim] has multiple levels, is the "Pr Id" property defined
at all levels (since [P_Type_Dim].Members returns members from all
levels)?

- Member Properties are strings, so compare to "104"


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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