Page 1 of 1

Processing of cube failed

Posted: Thu May 06, 2010 3:30 pm
by satyadevi
Hi,
I am processing a cube. I am using the option 'Stop processing on key failure' to No, so that the cube is processed even when the key is not found. The processing has been successful but in the log file, there are nearly 150 member key values which are failed. I am a newbie. Could you please let me know when this member key violation comes. And how to proceed further to troubleshoot.

Re: Processing of cube failed

Posted: Fri May 06, 2011 8:52 pm
by johnpet
You will get this error messages when there are no keys in the dimension table that correspond to the dimension keys in your fact table. So practically in your fact table you have dimension members keys that do not exist in your dimension tables.
BTW setting 'Stop processing on key failure' to No is not a good practice.