Excellent answer... a typical challenge when you want to extract results from a dimension is something like (e.g.): return me the sum of sales for all the countries but not this ones (A,B,C). Can this "not" or "except", "exclude" clausule can be implemented on MDX or should I have to go and create a new subset of countries? The answer is ... it depends:
You can create a query using WITH and Except and get that subset, but the recommendation is to create a new hierarchy on the dimension with your needed subset (if you are going to use heavily that set).
|