Don’t be confused when ever you face this clueless error while processing your cubes in SSAS 2008. I spent hours searching the internet and found no appropriate answer to over come this problem…. until I scroll my huge list of processing errors and found a ‘warning’ that my dimension does not have the Date_SK that is being processed in my fact.
I simply incremental update my time dimension and here it goes. This error is a really fuss for the Olap developers as its clueless and on the internet we have a lot of stories and myths on this issue.
Well this is no myth for me, it worked for me.