Following is a general tutorial for connecting from Microsoft Excel to OBIEE Reports using BI Connector Desktop Edition.
Launch Microsoft Excel from your Windows machine.
Navigate to the Data tab on the top menu. Click on Get Data -> From Other Sources -> From ODBC.
The Data Source selection box pops up, choose the Report DSN from the list, which you want to work with, and click OK.
Under the Database section, enter the OBIEE User name and the Password. Click Connect.
Click on the Database name to connect to the required database.
- On Successful Connection, a Report will be displayed if you provide a path of a particular report or a list of Reports will be displayed if you provide a path of the folder. You can Select the Report from the list also.
- The list of Reports will be displayed just like a Table. Select a report and click on load.
Now your OBIEE Report data is extracted to Excel, as shown in the screenshot below, and ready for analysis.
If you have any questions or issues creating a report, contact us at firstname.lastname@example.org or file a ticket at our support portal. We are just a click away.