ASO Cube Spreadsheet Extractor Error

We got this issue on ASO cube which is having huge data.

Getting the below error while trying to connect through SmartView.

"OLAP_error (1020004): An error [1130203] occurred in Spreadsheet Extractor"

Checked the Essbase Log and Application log
In Application log we found 

Info(1020089) Ignoring span Hybrid Analysis option. Spanning into Hybrid Analysis Relational Source has been disabled. See the essbase.cfg file

Info(1020055) Spreadsheet Extractor Elapsed Time : [29.734] seconds

Error(1013289) Command [SpreadsheetOperation] failed due to memory allocation failure

Increased the Java Heap size for APS as below:

1. From "Start" ->run->regedit and enter.

2. In the registry look for the HKEY_LOCAL_MACHINE->Software->Hyperion Solutions->aps->HyS9aps

3. For this node you should see several keys, several are jvmoptions.

4. Locate the Xmx and -Xms which are the maximum and minimum heap respectively.

NOTE: You can also change or add the stack size setting -Xss here as well.

5. These can be changed by right-click-> and select modify.

6.For both Xms and Xmx, modify the value as 1024m

Now the values are 
JVMOption10 REZ_SZ -Xms1024m
JVMOption11 REZ_SZ -Xmx1024m
JVMOption12 REZ_SZ -Xss256m
-Xss1024m. 

7. After changing these settings you will need to stop and start the Hyperion Analytic Provider Server windows service.

Now tried with the retrieval using Smart view, we are not getting this error.