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

How to zip output files of OBIEE 11g reports?

Received Response
11
Views
4
Comments
User_UKPME
User_UKPME Rank 1 - Community Starter
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

OBIEE 11.1.1.7

When we form the analysis/report in BI Answer, the result file can reach n GB (until 5-6 GB). Output file usually - csv. Because of large size of  output files (csv/excel) - we have a problem with time spent to download this file.

So we need to zip output files. So user need to download zip file (csv/excel).

1. How to zip output files in BI Answers

2. Whether it is possible to open in the publisher the reports created in answers AND whether it is possible in the publisher to download the constructed reports as zip archive

Thanks in advance.

Answers

  • Martin van Donselaar
    Martin van Donselaar Rank 6 - Analytics Lead

    Why are you using answers to make datadumps? The tool isn't meant to to that, It' meant to make analyses.

    Also what are you trying to achieve by making these dumps? There's probably a better way to achieve your goal then dumping very large amounts of data to csv/excel.

  • Joel
    Joel Rank 8 - Analytics Strategist

    +1. With extracts up to 5-6 GB that just doesn't sound right.

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    Total miss on the intent and design of the OBIEE tool ...

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    @3615571 You got several responses stating the same thing.

    It would be good if you could explain WHY you are trying to do things this way? Most of the time these issues are simply down to wrong usage of the tool and wrong choices as to which technology to use.