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 in excel of a Analysis takes too long

Accepted answer
31
Views
2
Comments
AM HRE
AM HRE Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

Hi, we're fancing a problem in download of the Analysis built in our system: if we download in Formatted Excel it takes several minutes while not formatted takes few seconds. The only adjustment at the layout are the colours of the headline: all the coloumn of the query are displaied in the table and no aggregation are realized.

Do you have any suggestion? The problem is also on the dashboards as we can't say to the users to download them not formatted as it's not an option available for that kind of object.

Thank you

Tagged:

Best Answer

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    That's how the tool work.

    The not formatted export (CSV), takes the result of the criteria as it is. The formatted export goes through a number of steps and that's what make it slower. If you don't have any error and the file is exported correctly, not sure you can really do much: that's how the tool work.

    If times become a concern, you can consider trying to schedule things so that users receive their files instead of exporting them manually.