Skip to Content
0

Analysis for Office 2.x - Data cells limit and memory consumption

Jul 26, 2017 at 11:14 AM

504

avatar image
Former Member

Hi All!

I have a question about the data cell limit and memory consumption in Analysis for Office 2.x...

This is my scenario:

I have a query with materials in the rows and twelve columns. Furthermore, I have eighteen rows for each material.

Now, I am selecting round about 250 materials. So, the result-sheet in Analysis for Office should be about 54.000 data cells (250*18*12).

Actually, this should be fine according to the default limit of 500.000 data cells, BUT I get an exception... "Size limit of result set exceeded".

My first question: Why? In my understanding 500.000 is bigger than 54.000....

Whatever, I edited the data cell limit according to SAP Note "2083067 - How to maintain settings for Analysis Office 2.x". I changed it to 10.000.000.

After that I executed the query again and got a new exception: "Exception of type 'System.OutOfMemoryException' was thrown"

My second question is again: Why? And how can I solve this problem?

Many thanks in advance!!!!

Best regards,

Stephan

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Stephen Hobbs Jul 26, 2017 at 11:56 AM
1

Hi Stephan,

This is this link helps...

Regards,

Stephen

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jul 26, 2017 at 12:15 PM
0

Hi Stephen,

Unfortunately, there is not really a solution for this problem according to this link. Except to use the 64 Bit version of MS Office and the 64 Bit version of Analysis. We don't have the options to select less data by adding more filters or something like this.

Thank you anyway!!!

But there is still one question: Our result-sheet should be about 54.000 data cells. Why is the error message appearing? I don't get it...

Regards,

Stephan

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 01, 2017 at 11:33 AM
0

Hi Stephan,

May be because data cell limit 10.000.000 is too high. Please review Safety belt parameters once. SAP note 1127156 would be helpful.

Also could you please try to change parameter "ResultSetSizeLimit" to 500.000 at "%AppData\Roaming\SAP\Cof" and try again. Earlier it did not work because settings were not maintained in your machine.

Regards,

Ranjani

Share
10 |10000 characters needed characters left characters exceeded