Multiselect in different clients illustrated

One of Mosha's most popular posts is about multiselect in AS2000 and SSAS2005. I have nothing to add technically to that only some comments and pictures of what can happen with cubes and clients.

 

Multselect is fully supported in  SSAS2005 and it means that you can have sets in the slicer/where clause when you write and MDX Select.

 

You can have a where clause like this:

 

Where ([Measures].[Internet Sales Amount],[Date].[Calendar Year].&[2001]:[Date].[Calendar Year].&[2004]);

 

It will work fine in ProClarity Professional 6.3 or MDX-studio. You cannot enter a MDX Select in Excel 2007 or earlier.