Is there any way to use the Instr (Like)

Written by MDX Inquiry. Posted in Comments

Is there any way to use the Instr (Like) together with an IN equivalent? I am trying: with set prec as nonempty (([Yahoo Advertiser].[Advertiser Domain].children)) select [Measures].[Click Count] on 0, (filter(prec, instr(1, [Yahoo Advertiser].[Advertiser Domain].currentmember.name, [Sites].[Site Name].currentmember.name)0)) on 1 from financials Basically, I want to get all the advertiser domain members that resemble site name members. Thanks!