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

TABLE 21.2 ErrorConfiguration Properties
Name

Description

Defines the action that Analysis Services takes if it
doesn't find a key of the attribute in the key store (for
instance, if Analysis Services processes the Customers
attribute in the Customer dimension and cannot find a city
for the current customer in the keys hash table of the
City attribute). You can select one of the values defined
in Table 21.3. The default value to this property is
ReportAndContinue .

KeyNotFound

Defines the action that Analysis Services needs to take if
it finds duplicate attribute keys during attribute process-
ing. You can select one of the values defined in Table
21.3. We recommend setting this property to
ReportAndStop to catch all inconsistencies in the rela-
tional data. The default value of this property is
IgnoreError .

KeyDuplicate

Defines the action that Analysis Services takes if it finds a
null value in the key field and the key is marked as
Error in the value of the attribute's NullProcessing
property. You can select one of the values defined in Table
21.3.

NullKeyNotAllowed

Defines the action that Analysis Services takes if it finds a
null value in the key field and key is marked as
ConvertToUnknown in the value of the attribute's
NullProcessing property. (For more information about
the NullProcessing property, see Chapter 6, “Cubes and
Multidimensional Analysis.”) You can select one of the
values defined in Table 21.3. The default value of this
property is ReportAndContinue .

NullKeyConvertedToUnknown

There are three actions that you can set for KeyNotFound , KeyDuplicate , NullKeyNot
Allowed , and NullKeyConvertedToUnknown . You can see descriptions of those values in
Table 21.3.

TABLE 21.3 Actions on KeyNotFound , KeyDuplicate , NullKeyNotAllowed , and
NullKeyConvertedToUnknown Errors
Value Description

The error is ignored and processing continues.

IgnoreError

The error is counted toward KeyErrorLimit and processing contin-
ues.

ReportAndContinue

The error causes Analysis Services to stop processing.

ReportAndStop