This content has been marked as final. Show 9 replies
Make sure you follow the steps as in1 person found this helpful
The step# 8 is mandatory that helps you to see column in the rpd.
If helps mark as correct or else let me know updates
Srini ~ Thanks for the reply. I have verified that there are named ranges defined in my spreadsheet however; I am still unable to view the data while in the RPD. Do you know why I would be able to import the metadata but not view the data or update the row counts?
I dont remember we can view data for Excel in rpd. I cant test it in local.
Try to use answers for the same.
If helps mark
It appears that I can view in Excel through the RPD when I am accessing the RPD in offline mode. If I try to access through online mode it just says "Connection Failed".
I also tried viewing the data through Answers but received the following error:
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 16001] ODBC error state: IM006 code: 0 message: [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed. [nQSError: 16001] ODBC error state: S1000 code: -1022 message: [Microsoft][ODBC Excel Driver] Your network access was interrupted. To continue, close the database, and then open it again.. (HY000)
SQL Issued: SELECT 0 s_0, "XLS-GBB"."FACT_F!_FACT"."Measure" s_1 FROM "XLS-GBB"
Does the file have to reside someplace special?
In OBIEE 126.96.36.199.0, if you open the Administration Tool and then the repository in online mode and go to File-Import Metadata, choose for 'Remote Server' the 'Local Machine' option.
Mark if helps
That option is not available to view the data; it is only available to import the metadata.
In Physical layer on the database properties
uncheck "select distinct supported value" in the Features tab -> save.
Open connection pool and uncheck share connection pools -> save.
View data online mode
I'm not seeing the options you have listed. If I click on the database the data source definition is set to "ODBC Advanced". If I do a [Find] for "distinct" on the Features tab I see the following options:
I have deselected each of these options.
Looking at the connection pool properties I see the following on the General tab:
Call interface -> ODBC 3.5
Data source name
Enable connection pooling
Use multithreaded connections
I have deselected "Enable connection pooling".
I've got to be missing something simple because I cant seem to find anyone else that has had this problem. Thank you for you help!