where clause evaluation in mdx

Question

Hi All,

I want to know about order of evaluation of MDX Query.Specifically if i have multiple conditions in where clause.How it is evaluated(i.e from right to left or left to right)

Answer 1

As per MDX Solutions book, Following are the order MDX execution stages. But I am not sure the order of Where clause.

 Resolving the FROM clause (if any—it is optional in Essbase)
2. Resolving the WHERE clause, if any
3. Resolving named sets in the WITH clause
4. Resolving the tuples on each axis
5. Calculating the cells brought back in the axis intersections
    a.    Resolving NON EMPTY intersections
     b. (AS2005) Resolving the HAVING clause on each axis

 

Thanks,
Ashok

Answer 2

Hi,

What kind of query do you have in mind where the order of evaluation within the WHERE clause matters?

Frank

Answer 3

The only case that I can think of using multiple members of a dimension and some of those members are custom member formulas or calculated members.

Ramu,

Can you send out your case of this situation?

Thanks,
Ashok