Hi Deepak,

I applied the solution to my case. It seems to work. But i have a query
performance problem. Is there a way to optimize the MDX funtion you
provided?

Thanks.

Nilgun


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

Hi Nilgun,

Can you give an idea of the structure and size of the actual Geo
dimension that you are applying this to? If the number of selected
members to iterate over is large, it may be harder to improve
perfromance.

The other thing is to see how much overhead the formula for filtering
the selected members is adding. You can add a constant calculated
measure and compare its performance:

Filter([Store].[Store Name].Members,
ValidMeasure(([Measures].[StoreCount], S.Item(0),
StrToMember("[StoreDup].["
+ [Store].CurrentMember.Name + "]"))) > 0)),
1)

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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