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 ? :?
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.