Databases Reference
In-Depth Information
Figure 12-10
You might encounter errors while processing your Analysis Services objects
due to incorrect design or referential integrity problems in the relational data
source. For example, if you have a fact record that contains a dimension id
that is not available in the dimension table, you will see a "Key not found" er-
ror while processing the cube. By default, when an error is encountered dur-
ing processing the processing operation fails. You can change the settings in
the processing dialog to take appropriate action other than failing the pro-
cessing operation. The Change Settings dialog helps in changing the error
configuration settings for all the objects selected for processing. Whenever
you encounter Key errors you can either convert the values to unknown or
discard the erroneous records. You can run into key errors while processing
the facts or the dimensions. If you encounter a key error while processing a
cube, that means Analysis Services was unable to find a corresponding key
in the dimension. You can assign the fact value to the member called
Unknown member for that specific dimension. You can encounter key errors
while processing a snowflake dimension when an attribute defined as a for-
eign key does not exist in the foreign table or when there are duplicate
entries. The two most common types of key errors that you might encounter
during dimension processing are key not found and duplicate key errors.
Search WWH ::
Custom Search