Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Page Breaks or New Tab Breaks in Excel Exports from Oracle OBIEE Reporting
Description
Page breaks show in PDF and PowerPoint exports, but not Excel Exports from OBIEE Reporting. This makes the formatting very hard to manage if the requirement is for an Excel report.
Use Case and Business Need
We have the UseCase:
As a line manager of a recruitment team i want to have reports delivered on a schedule in Excel so that i can prepare reports for the management team.
Our reports are built so that there is a summary table at the top- giving an overview, a pivot table giving a further breakdown and then details of one or more specific types. Without page breaks, even when using titles to separate the tables, the formatting (width/height) of these is set by the first table, leading to some unreadable areas of the report.
Adding a Page Break should resolve some of the formatting issues (using Page Break on inner most or outermost column) in the tables.
These page breaks show and are correct in PDF and PowerPoint exports, but not in Excel.
This idea to have either Page Break or "New Tab" breaks available for Excel.
Original Idea Number: fe168ec832