So I have been getting an out of memory issue when running reports in Analytics.
At first I was at a loss with the issue as the log files didn’t point to any significant issue that would be the root cause.
I started by doubling the Max Heap Size to hopefully resolve the issue but with no luck there I was stuck.
A little research lead me to check the BIData\tmp location both BIServer and BIPresentation folders there were a number of tmp files that were very large in size.
I have removed these tmp files and now hopefully the issue is resolved
More to come…