OBIEE - How to retrieve data from BI Server in Excel ?


An how-to which show how to use BI Server as a data source in excel


In excel : Menu / Data / Import External Data / New DataBase Query

Choose the ODBC Data Source used to connect to the repository that you want :


And login


And perform you're query and don't care if you don't have any join.


Powered by ComboStrap