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

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

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


3 - Steps

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.