SSAS Articles 
Design Multiselect in different clients illustrated
Design Multiselect in different clients illustrated
| Multiselect in different clients illustrated |
| Written by Thomas Ivarsson |
| Monday, 10 December 2007 12:02 |
|
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.
|
Top Rated
- SSAS Implementation Best Practices slides in PDF format
- SSRS Report Against a SSAS Parent Hierarchy
- Using AS Data Mining to Add Forecast Values to a Cube
- Handling inter-dimensional members dependency and reducing cube sparsity using reference dimensions in Analysis Services 2005
- Cube structure optimization for MDX query performance in Analysis Services 2005 SP2: Tips for Parent Child Hierarchies usage
- Handling Multiple Calendars with a M2M Scenario
- Passing MDX parameters in Reporting Services reports
- Using UserName to Control Data Access and Default Member in SSAS 2K5 (Carrie Williams)
