i use MSOLAP.2 provider.
and it doesn't support multiple tuples in where statement.

what alternative could there be to achieve the same result as
where crossjoin(Wares, Time.[2003].December.[1]:Time.[2003].December.[20]) ?

More precisely, a tuple cannot contain >1 member from same dim, and the
WHERE clause is a tuple. The solution is something like this...

WITH MEMBER Measures.MyMeas AS
' Aggregate(Crossjoin(Set1, Set2), Measure) '
SELECT
etc...
WHERE (Measures.MyMeas)

public @ the domain below
www.tomchester.net

"Alexander Nenashev" <nenashev (AT) hotbox (DOT) ru> wrote