I would like to create a set by filtering a dimension on a property value
being one of a list of possible values. In SQL it would be equivalant to the
IN clause. The pseudo MDX being:
set [f[ as 'filter( [dimention].members, [dimension].currentmember in (
"val1", 'val2", ... )'

Is there any way to do this in MDX? I have tried using the VBA filter and
the Excel Match functions work with no success so far.

This Foodmart queries shows a possible way:

with member [measures].SM as 'store.currentmember.Properties("Store Manager")'
select
{ [unit sales], SM} on columns,
filter(store.[store name].members, store.currentmember.Properties("Store
Manager") ="Jones" or store.currentmember.Properties("Store Manager")
="Smith" ) on rows
from sales
HTH,
--
Brian Altmann
BI Specialist
Huddle Group S.A (www.huddle.com.ar)
www.geocities.com/brianaltmann/olap.html


"MEmerson" wrote: