Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 215 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
Generate multiple Excel sheets based on parameter value
Sonia Choudhary
Rank 0 - Community Observer
Hi All,
We are using Oracle Fusion Cloud Application 25C and Oracle BI Publisher Desktop for developing data template reports. Our requirement is to generate Excel output where the number of sheets depends on parameter value dynamically.
If parameter X is A, all three sheets (A, B, C) are generated in Excel, if parameter X is B, only sheet B is generated, if parameter X is C only sheet C is generated. How can I create this in rtf template or Excel? I tried using rtf and splitting on multiple pages, but each page has different columns.
Could you please recommend the steps to achieve sheets dynamically.
0