Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Issue with the downloading report in excel 2007+ format in OBIEE 11g
Below is the error I get when export a dashboard page or the report itself from the dashboard:
Excel found unreadable content in FILE_NAME.xlsx. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click yes.
If I say Yes, I get another prompt as below :
Removed Records: Named range from /xl/workbook.xml part (Workbook)
but the file opens well.
Looked at Oracle support and found below solution but that does not work for me as there are none of the characters used in either name of dashboard or report itself as mentioned in the below link:
Has anyone seen this issue without the use of special characters? If yes, please provide help.
Answers
-
What version of OBIEE 11g?
0 -
11.1.1.7.160719 (Build 160701.0659 64-bit)
0 -
11.1.1.7.160719 (Build 160701.0659 64-bit)
0 -
I have run into a similar, if not identical issue:
My problem was caused by a date format that Excel didn't recognize: [FMT:DateShort] . When I changed the date format, it downloaded without problems.
0 -
I would recommend upgrading from that build to at least the latest 11.1.1.9.x version. There are updates to export functionality and bug fixes in the .9 release Doc ID 1595671.1
For the current issue, what debugging steps have you performed?
Does the issue occur with all reports? Does it happen in all environments? Does it happen with a different version of MS Office?
0 -
Thank you for the response, I shall try and update as I have at least 10 date fields in the report.
0 -
Thanks for the update Sherry but customer won't agree for upgrade due to issue in one report.
Debugging steps I followed were to delete columns one by one and it would work in some case by deleting column X and then by deleting by column Y and so on. But when remove the culprit column from the main report, it still errors out when downloading.
No, the issue does not happen with other similar reports having multiple and same date fields. Yes, it does happen in all environments. Nope, all users have 2013 and above and it happens for all the users. I am running 2013 and I get the error as well.
0 -
For testing purpose, I removed all the date fields and voila, the error is gone. thanks Jerry. Now I will need to verify which of those 10 date fields is causing the issue. I shall update this thread once I have the problem solved.
0 -
If you get to a point where the problem is wasting too much of your time, you might consider converting the date to a CHAR for download using the CAST function. Your report will "look" correct. Of course, the dates in the column would not be readily available for calculation purposes, but the Excel DATEVALUE() function can be employed to reconstitute the numeric date value from the string representation if you have to go this route.
Just a thought,
Mike
0 -
Late to the party, but:
1.) @Sherry George is spot on. As of 11.1.1.9 there are explicit new config parameter for precisely that. And in any case an upgrade is more than recommendable! Plus it isnt even much effort if your system is sound.
2.) You just have to love @Mike Wentz pragmatic, no-BS approach. Dont overthink. Take a step back and just make it work.
0