OBIEE 11g Connection Admin Tool to OBIEE Server Located Remotely

1.  Install Oracle 11 g Client from here- http://www.oracle.com/technetwork/database/enterprise-edition/downloads/112010-win32soft-098987.html
   
   
   
2. Install Admin Tool 
3. Setup System DSN in ODBC Data Source Administrator. Add and configure your server like below.
   
   
   
4. Go to the following location(C:\Oracle Business Intelligence Enterprise Edition Plus Client\oraclebi\orahome\bifoundation\server\bin or as the Admin tool in installed on your machine) and edit bi_init file. In my case, bi_init looks like this
   
   
   
5. Make sure you have tnsnames.ora file and you have the database connection set accordingly like this where eicfdcn49.ebiz.verizon.com is the database server.                                                                                                                                                     QD1=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=eicfdcn49.ebiz.verizon.com)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=QD1)))                                                              
6. Place your tnsnames.ora file in Oracle folder or any appropriate folder and set PATH and TNS_ADMIN variables to its location as below in User Environment variables.
   
   
   
   7. Now try to import a table in the Admin tool like below 
   
   
   
   Where rmi_read is the database user in my case.