Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
OBIEE 12C export to Excel 2007 is creating separate tabs in spreadsheet for different sections on a
1012147
Rank 1 - Community Starter
We have multiple reports that break on unique business unit, with the BU as the header. All the output is in the same section of the report, but when we export to Excel 2007 from 12C, it breaks each business unit into it's own tab on the spreadsheet, where 11G exporting did not.
We are trying to get the exported output to appear on one tab.
Anyone run into this and have a solution?
0
Answers
-
Problem solved.
In the Pivot Table properties, under Options, there is a drop down for Insert Page Break. Apparently, breaking pages on a specific column value creates tabs in Excel for each break, and titles the tab according to the header, which is the column value.
To stop the new tabs in Excel, turn off the page break.
0