Your SQL has been broken across the two contexts. BOBJ synchronizes the two blocks on the desk top, so you will need to change the unlinked dimensions to details (which are associated to the linked dimension). Go here for more detail:
or
http://www.noscentia.com/reference/
SteveBickerton 
(BOB member since 2002-08-15)