Need a way to export all layouts in a report to one excel file — Oracle Analytics

Oracle Transactional Business Intelligence Idea Lab

Home› Oracle Analytics› Oracle Analytics Idea Labs› More Solutions Idea Labs› Oracle Transactional Business Intelligence Idea Lab

Categories

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

Need a way to export all layouts in a report to one excel file

Submitted
83
Views
2
Comments
cody hinds
cody hinds Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Idea Lab

Organization Name

Baylor University

Description

We would like to see a way to generate one excel file that contains the data from all tabs/layouts generated in a report. 

Use Case and Business Need

For instance, we have a report that contains three layouts. Each layout contains data generated from the same data model. It is displaying the same information differently. We would like to export all three of these layouts at one time. Right now we have to export each tab to .xlsx then copy the data into one excel file. This is confusing to our users and an inefficient use of  their time. 

More details

We have tried using the "Send" and "Schedule" options and sending the output to an email address. This is not helpful because it still generates three separate files. 

Original Idea Number: 71d8d06179

Tagged:
1
Up
1 votes

Submitted · Last Updated

Comments

  • User_4E5VW
    User_4E5VW Rank 1 - Community Starter

    same question

  • Glen Ryen
    Glen Ryen Rank 4 - Community Specialist

    Hi Cody,

    Are you creating those layouts as BI Publisher RTF templates? If the ultimate output is Excel, you'd be better off building this with a single true Excel layout template. Those support producing multi-tab Excel files, plus better Excel field formatting overall than RTF templates. So one BIP template leads to one output file, one tab per layout.

    Hope that helps,

    Glen