The author provides her favorite methods for getting good results with BEx queries, including specifying a variable offset and using a customer exit as a variable.
Variables are very useful for manipulating a BEx query to get a specific result. Not only do variables allow you to enter your selection criteria for a query, they also allow you to re-use that input for another query (via the report/report interface). What follows are five of my favorite tips for using variables in BEx queries. They apply to both BW 2.x and 3.x unless otherwise noted.