I am facing the problem in chasm trap. I have tried to resolve chasm trap by context but I cant use the variable in report. I have tried one more option through alias but showing the wrong output (Cartesian product)
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:
(BOB member since 2002-08-15)