I have a huge report with 30 plus dimensions and 15 + expressions. I am running the report for a long range say 1 year. When I try to export the report to excel it gives the attached error.(screenshot attached).
Can you please let me know how to handle this situation apart from upping the memory and root causes of this problem?
Use less dimensions and expressions. You could let the user select dimensions and expressions and customize the table layout themselves that way. See for example this blog post: Customizable Straight Table
Somewhere I assume within the easter egg are options to customize the max. size of RAM which an object could get. But this is a global setting and it's not recommended to change it.
I think in your case it would be better to consider other options, for example to split such export on quarter- or month-level, to export into csv, to reduce the complexity and data-types from this object (columns with text will need a lot more RAM as which with numbers or more practically replace label-fields through ID-fields).
This RAM meant not the size of installed RAM on the machine else the RAM which a single object could be obtain. This is limited to a certain size to make sure that the application itself (and the server) will be stable even a single object required a lot of RAM which could be easily happens when an object like a pivot-chart is complex and contains many dimensions maybe with dimension-groups, some visibility-conditions and similar especially when vertically and horizontall used which could cause an explosion of RAM.
Therefore is the recommendation not to create huge reports which per gui will be exported else (if really needed such large outputs) to create them within the script and store them as csv or as qvx: QlikView QVX File Format.
