Database Reference
In-Depth Information
We can control what happens for each Analysis Services object when there is a
processing error using its ErrorConfiguration property. The default setting is for
processing to fail whenever an error occurs, but we can override this for different types
of error and either ignore the error completely, ignore anything up to a given number
of errors and then fail processing, or log the error to a text file and continue processing.
We also have two options that govern what happens when we ignore an error: we
can either ignore the problem row in the fact table completely or assign the values
from them to a special, automatically generated member called UnknownMember on a
hierarchy. The existence of Unknown Members is controlled by the UnknownMember
property of a dimension: it can either be set to None , Visible , or Hidden .
We can also set these properties for each processing operation by clicking on the
Change Settings button in the Process dialog, and then going to the Dimension
key errors tab.
 
Search WWH ::




Custom Search