Dimension and Partition Processing - Microsoft SQL Server 2008 Analysis Services - page 400

Figure 21.6 demonstrates how Analysis Services treats errors occurring during the process-
ing operations, depending on the settings in the ErrorConfiguration object.

Processing error condition detected

Null in the key
column and
NullProcessing
set to
ConvertToKnow

Null in the key
column and
NullProcessing
set to Error

Duplicate
attribute key

Related attribute
key is not found

Report
And Stop

Report
And Stop

Report
And Stop

Report
And Stop

NullKey
NotAllowed

NullKeyConverted
ToUnknown

KeyDuplicate KeyNotFound

Report
And
Continue

Report
And
Continue

Report
And
Continue

Report
And
Continue

Stop Stop Stop Stop

IgnoreError IgnoreError IgnoreError IgnoreError

No. Yes.

IgnoreError

KeyErrorLimit

Stop
Logging

KeyError
LimitAction

Stop
Processing

Stop

KeyErrorAction

Discard
Record

Convert to
Unknown

Action

FIGURE 21.6

A scheme of how processing errors are handled.