Download in excel of a Analysis takes too long

AM HRE

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

SteveF-Oracle

To add, the size of the exported Analysis matters for the computational process (rows x columns). Additionally, the load on the system based on your OAC size.

This is documented here:

• Limits Exporting Data (Classic Analyses and Dashboards)

Gianni Ceresa

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.