BusinessObjects Board

Chasm trap

In my universe, I have 10 dimension tables such that one of them has many-to-one relationship with the remaining 9 tables. I believe this has resulted in chasm traps. Would that create any issue when it’ll come to reporting? If it would, then what is the way to resolve the chasm trap. Would I have to create 9 aliases of the table having many-to-one relationship ? :?


spark_saaar (BOB member since 2006-09-09)

From the Designer FAQ at the top of this forum: What is a chasm trap, why is it a problem, how do I resolve it?


Anita Craig :us: (BOB member since 2002-06-17)

Hi Please check your universe Parameter option
In that make sure that the option Multiple SQL queries for each measure object.If the above one is selected then you wont encounter chasm traps.

Please refer to the following thread
https://bobj-board.org/t/77439
I have tried with the same scenario without creating the contexts but still i got the correct count.this is due to the reason the option is selected default. and hence no job for you to create the aliases / contexts.

Thanks,
KK


karlak :india: (BOB member since 2006-11-01)