Ignoring relational consistency problem

In order to ignore key consistency errors we must change the settings of the cube processing.

When we have chosen to ignore the key errors, we will see that the cube processing is now able to complete. However, with a number of warnings – but that is ok at this time.

The 7112 problems reported are probably all key consistency errors. However, since we chose to ignore these errors, the cube processing has now completed.

With a successful processing of the cube, we are now ready to start browsing the full cube in the Cube designer’s Browser tab.

Notice: In this lesson, and for a few more lessons ahead, every single time you need to re-process your cube it is necessary to change the error handling settings to ignore key consistency errors. In a later lesson, we will take actions to correct the referential integrity problem and thereby eliminating the necessity to ignore key errors.