Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 38 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 274 Oracle Analytics and AI News
- 48 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Download report to multiple excel tabs based on prompt selection.
Users wants to download OBIEE Dashboard into multiple excel tabs based on prompt selection.
Example - User selects North America in prompt and report should generate 3 tabs(america, mexico and canada). Is there anyway we can do this where we select 1 level of hierarchy column and data displays for lower level.
Answers
-
Hi,
have you tried creating a report where there is a prompt area corresponding to your lower level and filtering the report based on your level1. Then download and select the all combinations option?
0 -
Thanks Robert.
I did move the column to sections in pivot table and was able to generate a report.
Breaking into sections is easy but can we convert those sections into separate excel tabs.
0 -
When you download to excel using the 'all combinations' option - how is it presented in excel~?
0