SSAS Articles 
Design Manage Unknown Members in Analysis Services 2005, Part I
Design Manage Unknown Members in Analysis Services 2005, Part I
| Manage Unknown Members in Analysis Services 2005, Part I |
| Written by William Pearson |
| Thursday, 15 November 2007 05:37 |
| In this two-part article, we will consider the management of the Unknown Member within Analysis Services. The Unknown Member settings offer us capabilities for handling scenarios involving unmatched dimension keys. The capabilities afforded by the Unknown Member options allow us to override the processing failure that would occur in these cases of mismatch, as well is to assign a name other than Unknown to the Unknown Member within each dimension, to control visibility of the Unknown Member, and more. In this, Part I of our two-part article, we will gain an introduction and some hands-on exposure to managing Unknown Members within a sample cube. |
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)
