I have a dimension which contains list of countries name.
Dimension Name : Country
Attribute, Short Name : USA
Attribute, Long Name : United States of America
Similarly i have Short Name like INDO, IND etc for which
Long Names are Indonesia and India....

How to filter Dimension, whose short name has "IND" word.
It means if i filter on IND.. then result should have
Indonesia and INDIA also.

Thanks in advance.

"jagan_sv" <jagan_sv (AT) yahoo (DOT) com> wrote

You can use VBA functions for doing string comparissons. I.e.

Filter(Country.MEMBERS, StrCompare(Left(Country.Properties("Short Name"),
3), "IND")))

--
==================================================
Mosha Pasumansky - www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================