Oracle Analytics and AI

Home
Oracle Analytics and AI
Oracle Analytics and AI Forums
Oracle Analytics Forums
Oracle Analytics Forum

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.

Find more posts tagged with

Accepted answers

All comments

Robert Angel

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?

3292571

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.

Robert Angel

When you download to excel using the 'all combinations' option - how is it presented in excel~?