My Oracle Support Banner

OBIEE Not Able To Run Excel ODBC Based Analysis When The Excel Is Stored Over A Network (Doc ID 2131766.1)

Last updated on APRIL 01, 2019

Applies to:

Business Intelligence Server Enterprise Edition - Version and later
Information in this document applies to any platform.


On : version, Analytics

OBIEE is not able to run excel based analysis when the excel is stored over a network.
The excel file is on the network (For Example: associated to a drive letter Y). The machine where the OBIEE is installed has the access to the drive and file. OBIEE administrator is able to open this file from the server box. If  the same file is used from the local machine there is no issue.
But when the excel file is on the network it give an ODBC error.
The same setup was working in

[nQSError: 43113] Message returned from
OBIS. [nQSError: 16001] ODBC error state: IM006 code: 0 message:
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed.
[nQSError: 16001] ODBC error state: S1009 code: -1023 message:
[Microsoft][ODBC Excel Driver]'(unknown)' is not a valid path.

The issue can be reproduced at will with the following steps:
1. Install OBIEE
2. Install Excel 2010 or 2013.
3. create a network drive and store an excel sheet in this drive
3. Create a datasource called test1
ODBC > System DSN
Data Source Name : test1
Workbook: y:\Book1.xlsx
4. Open RPD in offline mode.
5. Add this datasource to the Physical layer of the RPD using Import Metadata option.
6. Right click on the test1 > y:\Book1.xlsx > Sheet1$ in the physical layer of the RPD and select "View Data"
Confirm the data can be seen
7. Upload the RPD to OBIEE server.
8. Run a report based off of this datasource.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.