key error messages in analysis services cube processing

Sometimes when processing a cube I will get a roll back error message
stating that a value like '2002' was found in the fact table but no
such value was found in the dimension/level table.

I don't get/understand this error message. In almost all cases, an
examination of the fact and dimension tables will show that the value
resides in each.

What an I missing?

I know I can tell the Cube to process and ignore missing key problems.
Yet, I am troubled about this type of error message.

Many thanks in advance!

Pete

Pete Hohenhaus
Kirkland, WA, East Side, Seattle

This will normally always occur if new data is being added to your
underlying tables while the cube process takes place.
I.E if you process the dimensions
then new data is inserted in your tables
then process the cube

The cube process sees the extra data that was not available at time of
processing the dimensions
You can use ignore missing keys to ignore data that appears after the
beginning of the cube process, then next time you process the dimensions,
then this data will be included

regards
Aaron

"Pete Hohenhaus" <cam_pete (AT) hotmail (DOT) com> wrote