SSAS Articles 
Design Alternatively Sorting Attribute Members in Analysis Services 2005
Design Alternatively Sorting Attribute Members in Analysis Services 2005
| Alternatively Sorting Attribute Members in Analysis Services 2005 |
| Written by William Pearson |
| Monday, 10 September 2007 06:00 |
| While it is quite common to sort the attribute members of our Analysis Services 2005 cubes based upon either their name or key values (perhaps even a composite member key), many of us encounter situations where we need to accomplish a different sort order – a sort order that is based upon a characteristic lying outside the attribute members themselves. In these cases, an option we have is to order such an attribute on the basis of the name or key of a related secondary attribute. |
Latest Author Articles
- Further Combination of BottomCount() with Other MDX Functions
- Combine BottomCount() with Other MDX Functions to Add Sophistication
- Attribute Member Values in Analysis Services
- Introducing Reporting Services Charts for Analysis Services
- MSSQL Analysis Services - Attribute Member Names
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)
