Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Update Excel BI Publisher Template to XLSX (Current Excel Versions)
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