Oracle Transactional Business Intelligence Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Excel template to be generating output in Excel 2007 or Beyond versions

11
Views
1
Comments

Our client had a requirement of a custom BIP report with 99+ columns to be fetched and expected volume of more than 1 Million per execution. Current functionality allows us to handle 99+ columns using an excel template, however the output generated being in Excel 2003, the fetched records get split into multiple tabs to post 65536 rows, due to version limitation. If the product is enhanced to generate output in later versions of Excel, this limit would be further increased to 1 Million+ records and would be highly efficient in catering business requirements.

1
1 votes

Submitted · Last Updated

Comments