Question: how to import excel file into obiee?
Answer: Open Excel, select the Data ribbon, expand From Other Sources, and select From Microsoft Query. ... 
Select the DSN entry created for connecting to OBIEE Server (for example, airlines) and click OK. ... 
Enter your OBIEE Server login credentials and click OK. ... 
Click OK. ... 
Click Options.