Issue with export to excel
We just recently upgraded from OBIEE 10g to 11g version 11.1.1.5.0 and we are having problem with the export to excel functionality. The files when opened come across as gibberish. I know this worked fine for us in 10g.
We are a mac shop, but have trying opening the files Windows Office version running on Parrallels and that has not worked. We've tried opening the files in Mac Excel, Windows Excel (on parrallels), NeoOffice, Open Office, and numbers, and all can't read the file correctly.
When opening in Open Office the program wants to do a text import.
I can open the file in a text editor and it looks like this:
MIME-Version: 1.0
Content-Type: Multipart/Related;
type="text/html";
boundary="saw_part_boundary_0"
--saw_part_boundary_0
Content-Type: text/html; charset=windows-1252
Content-Transfer-Encoding: base64
PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDQuMC8vRU4iPg0KPGh0bWwg
ZGlyPSJsdHIiIHhtbG5zOm89InVybjpzY2hlbWFzLW1pY3Jvc29mdC1jb206b2ZmaWNlOm9mZmlj
ZSIgeG1sbnM6eGxzPSJ1cm46c2NoZW1hcy1taWNyb3NvZnQtY29tOm9mZmljZTpleGNlbCI+PGhl
YWQ+PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNo
YXJzZXQ9d2luZG93cy0xMjUyIj48bWV0YSBodHRwLWVxdWl2PSJDb250ZW50LUxhbmd1YWdlIiBj
b250ZW50PSJlbiI+PHRpdGxlPk9yYWNsZSBCSSBBbnN3ZXJzPC90aXRsZT48c3R5bGUgdHlwZT0i
dGV4dC9jc3MiPg0KSFJ7Y29sb3I6IzMzOTtoZ....
And so on.
I've googled around but can't seem to find anyone else having this issue. Any ideas? Let me know if you need more info. Thanks!