Manage Unknown Members in Analysis Services 2005, Part I
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.
Tags: design