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