OBIEE Initialization Block

Initialization Block is powerful in setting one time per session.

http://www.rittmanmead.com/2008/09/03/obiee-repository-variables-filtering-and-conditional-formatting/

Ragged Hierarchies and OBIEE

This is the best article on implementing ragged hierarchies in OBIEE which does work - http://www.rittmanmead.com/2007/06/21/obiee-data-modeling-tips-3-ragged-hierarchies/

OBIEE Variables

Good link discussing OBIEE variables http://shivabizint.wordpress.com/2008/10/02/oracle-bi-ee-variables-overview/