I have a document with size of 600 MB. I am able to open this document on server but not able to open at my local machine. It say "Out of virtual memory. Allocationg 4 MB". I have enough of RAM in my system and I can even open application having 900 MB of size. I don't know what is wrong with this particular application alone.
I checked the compression ratio for this application and it is set as HIGH. Can anyone has any clue what is happening? How can I avoid this?
You need to point expressions which have aggr,nested ifs or reused parameters. You can have a look at expressions through expression overview (CTRL+ALT+E)
Aggr: Check if they are really needed. Sometime can be done at script level and some you can try using TOTAL.
Nested Ifs: These can be done at script level most of the times (unless used after aggr tables).
Resued Expressions: Some expressions like current date/ current year/ current month etc are used in almost all expressions. You can reduce the calculation of these terms by subtituting with variables.
Set with Text: If you have set where product={'product_1'} , create a key at script (using AutoNumber() ) and use it in set anlaysis as product={'1'}.
These are generic but there are more depending on context and requirements. Unless we understand the business needs its difficult to suggest.
You can look into the opening sheet properties and find out the object which consumes more memory. Give the expressions in the object and data model for us to suggest better.
