How to get the forgot password in OBIEE 11g. Please refer the below link you will get one good Suitable solution.
How to reset the forgot password in OBIEE 10g. Please refer the below link.
How to create Time Hierarchy in OBIEE 11g:
Hope this help's
Satya Ranki Reddy