Jason, Thanks for your previous reply. It solved my main problem. However a new one has come up which I am not exactly sure how to handle. In the OR clause is it possible to put EXCEPT around a set? As I had mentioned in my first post this set ...

Worked great. Thanks a bunch!!!...

Hi Jason, I looked at your post below to while searching for OR clause in MDX http://beyondrelational.com/modules/2/blogs/65/posts/11570/or-operation-in-mdx.aspx This is good but my case is something like this SELECT non empty {[Measures].[Access Fe...

Hi Jason, I looked at your post below to while searching for OR clause in MDX http://beyondrelational.com/modules/2/blogs/65/posts/11570/or-operation-in-mdx.aspx This is good but my case is something like this SELECT non empty {[Measures].[Acc...