BI Report is built with Excel Layout Template where the Excel version is of 97-2003 version and atta
BI Report is built with Excel Layout Template where the Excel version is of 97-2003 version and attached the layout to the report.
When the report is run for 3 Months report is completed with below error.
==========================================
oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException: oracle.xdo.XDORuntimeException: Your data is more than 65531 rows in a sheet, that exceeds Microsoft Excel (.xls) limitation. Stop processing. Suggest to turn on Excel Template Scalable Mode to true from Runtime Properties.
==========================================
Please advice on this ASAP.