Question: how to import excel file in obiee 11g?
Answer: Open up your ODBC Data Sources. Select the driver you want to use. Name your ODBC Data Source. Select your workbook. In the Admin tool, go to File -> Import (10g) and select your data source. ...  Import that file/folder. What you'll have in your physical layer is this: