Exporting to Excel 2007 crashes Bi Pub and OBI
Hello,
We have been working with a Bi Publisher report that returns about 100K rows. When we export the report to Excel 2007 after a short time Bi Pub and OBIEE become VERY slow and eventually crash. Exporting to Excel 2007 seems to work OK for up to 20K rows. Above 20K we see the behavior mentioned. We are able to export the same report to CSV but our business partners require an export to Excel.
Is this a problem anyone has seen or addressed?
Thanks in advance,
Jon