Oracle Analytics Publisher Idea Lab

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

Update Excel BI Publisher Template to XLSX (Current Excel Versions)

2
Views
0
Comments
Brian Burns
Brian Burns Rank 3 - Community Apprentice

Description

I would really like Oracle to do whatever they can to update the Excel BI publisher Template to be compatible with the current excel (XLSX).


I think the BI Publisher Excel template is a really powerful tool for accounting users. 90% of the time reports are created, run, and then exported to Excel to be used in a Pivot Table.


I've been able to save users time by creating Excel Template reports. This way the pivot tables and calculations dynamically update upon running the report. I haven't found any other way to have some of the more complex pivot table functionality. I don't have the same options with OTBI or even creating an RTF and trying to add in a pivot table.


In my opinion, reporting can be enhanced a great deal with full Excel compatibility.

Use Case and Business Need

I would really like Oracle to do whatever they can to update the Excel BI publisher Template to be compatible with the current excel (XLSX).


I think the BI Publisher Excel template is a really powerful tool for accounting users. 90% of the time reports are created, run, and then exported to Excel to be used in a Pivot Table.


I've been able to save users time by creating Excel Template reports. This way the pivot tables and calculations dynamically update upon running the report. I haven't found any other way to have some of the more complex pivot table functionality. I don't have the same options with OTBI or even creating an RTF and trying to add in a pivot table.


In my opinion, reporting can be enhanced a great deal with full Excel compatibility.


Original Idea Number: c8543c6c2d

1
1 votes

Submitted · Last Updated