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