To the Rescue!!!
With differing capacities of Integration and Production servers, most of the times developers miss an important perspective; How would their code scale in the production systems. I had such a situation, where I could bring in drastic improvements in my report retrieval times.
Ever wished, you had a way to override session level information with users selections? If you were one just like me looking forward to tune your reports further, you would just love the request variables in OBIEE 11g.