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

Bi Server Architecture With Client

About

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

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 :

Choose Data Source

And login

Oracle Bi Server Login

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

Query Wizard




Discover More
Bi Server Architecture With Client
OBIEE 10G/11G - Oracle BI ODBC driver

The principal connection to an OBI Server inside the Oracle BI System is made through an Odbc Connection. The BI Presentation Service and the Administration Tool use this connection method to connect...
Bi Server Architecture With Client
OBIEE 10g - Oracle BI Open Intelligence Interface (ODBC and JDBC) client connectivity

Some sites use third-party analytical tools, such as spreadsheets and databases, which require connectivity to the Oracle BI Server (ie the BI Server becomes a data source) The Oracle BI Open Intelligence...



Share this page:
Follow us:
Task Runner