I am not so sure about ur exact reason of problem but I faced similar situation wher some data was misssing, and after doing some resarch I have found there...

you are asking about cube access or the sql server source db access?