Skip to Content
0
Former Member
Nov 21, 2011 at 11:03 AM

MDX Where clause specification

504 Views

Hello All,

I've a problem with WHERE clause in MDX...

my requirement is to select members from data source using several filters with WHERE clause.

e.g.

Select {Dimension1.member1, Dimension2.member1} on ROWS, {Measures.Measure1} on COLUMNS from DATASOURCE

WHERE (Dimension3.memberX, Dimension3.memberY, Dimension4.memberA ....DimensionN.memberN)

unfortunately this query in ignoring the filter settings, but if I user SINGLE dimension then it's working!!!

Could anybody know the problem behind this?

Thanks and regards

Swamy