Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Download report to multiple excel tabs based on prompt selection.

Received Response
1
Views
3
Comments
3292571
3292571 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:40PM in Oracle Analytics Cloud and Server

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

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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
    3292571 Rank 3 - Community Apprentice

    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
    Robert Angel Rank 8 - Analytics Strategist

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