Do not set error configuration for KeyDuplicate to IgnoreError
Some posts ago I wrote about the error message ‘A duplicate attribute key has been found when processing’. At the end of the post I suggested not to set the error configuration for the KeyDuplicate to IgnoreError (unless you are in a prototyping scenario).
Some people asked me about this (as it seems to be a nice and easy solution, similar to ‘on error resume next’ in VBA which I also wouldn’t recommend).
The main reason for me is that I definitely prefer getting a processing error instead having wrong values in the cube which could be the consequence.
For example, let’s take a look at a date dimension: