Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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