1222
Part IX: Business Intelligence
Error Configuration
For data integrity errors as described and several others, the ErrorConfiguration
property specifi es how errors will be handled. Initially, the setting for this property is
(default), but choose the (custom) setting from the list and eight properties appear. The
ErrorConfiguration properties are available on several objects but are primarily set for
dimensions and measure groups.Some properties to take note of are:■ (^) KeyDuplicate: Triggered when a duplicate key is seen while building the dimen-
sion. The default is IgnoreError; other settings are ReportAndContinue and
ReportAndStop. IgnoreError causes all the attribute values to incorporate into
the dimension, but Analysis Services randomly chooses which values to associate
with the key
■ (^) KeyErrorAction: Triggered when a KeyNotFound error is encountered. This occurs
when a key value cannot be located in its associated table. For measure groups, this
happens when the fact table contains a dimension key not found in the dimension
table.
■ (^) KeyNotFound:Determines how KeyNotFound errors interact with the
KeyErrorLimit, such as reporting the error and stopping processing. There are
other properties available to go deeper with error handling during processing as
well. You can set these same properties as server properties to establish different
defaults. You can also set them for a particular processing run to provide special
handling for certain data.
Summary
Analysis Services provides the capability to build fast, consistent, and relevant repositories
of data suitable for both end-user and application use. You easily can resolve simple prob-
lems by using default behaviors, and more complex problems with the fl exibility provided
by the breadth of this server and its design environment.c53.indd 1222c53.indd 1222 7/31/2012 10:30:26 AM7/31/2012 10:30:26 AM
http://www.it-ebooks.info