SAP Business Objects Universe Designer Preventing Chasm and Fan Traps - Context & Alias
In this article I would like to talk about Chasm traps and Fan traps . These are problems that we often experience while building universes and reports. When encountering these traps, one may wonder what is going on? How come my sum statements aren't adding up correctly? Or why am I missing some rows? A properly designed universe will help avoid these problems. In addition, a good understanding about measures and contexts from report designers will help as well. Chasm Traps Let’s talk about Chasm traps first. In short, a Chasm trap can be imagined as a bottomless pit where some rows may unknowingly fall in and never come back out. So when viewing a report caught in a Chasm trap, one may ask “Hey where did Record X go??”. Many to one joins from two fact tables converge on a single look-up table. This type of join convergence is called a Chasm trap . Looking at the eFashion Universe (note that this is a modified version of the efashion ...