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