Processing of cube failed

Post Reply
Posts: 1
Joined: Thu May 06, 2010 3:25 pm
OLAP Product: MS Analysis Services
Version: 2005
Excel Version: 2005

Processing of cube failed

Post by satyadevi » Thu May 06, 2010 3:30 pm

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.

Posts: 1
Joined: Fri May 06, 2011 8:36 pm
OLAP Product: TM1
Version: PA2.0
Excel Version: 2010

Re: Processing of cube failed

Post by johnpet » Fri May 06, 2011 8:52 pm

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.

Post Reply