cancel
Showing results for 
Search instead for 
Did you mean: 

Size Limit of Result Set Exceeded in SAP Business Objects Advanced Analysis for Office 1.2

Former Member
0 Kudos

Hi Everyone;

I am running advanced analysis reports on HANA as datasource and I am getting the message Size Limit of Result Set Exceeded whenever I have a larger output. I have noticed that in the admin guide and in other SCN posts about this setting in Windows Registry:

[HKEY_LOCAL_MACHINE\Software\SAP\AdvancedAnalysis\Settings\DataSource]

"ShowBicsSample"="True"

"ResultSetSizeLimit"="-1"

But I am having hard time finding this setting in my windows registry; can someone help me understand why I don't have it in my registry? and how to find it and change this setting?

FYI...I am using Office 2010.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

I have been attempting to get the registry settings to work without success. I couldn't find any of the keys listed in any of the locations mentioned in this thread or in the notes. I added the folder structure and keys in multiple locations, but I still get hung up trying to pull > 500k records.

Any suggestions?

Former Member
0 Kudos

Hi everyone,

In BO AA 1.2 I have added HKEY_LOCAL_MACHINE registry entries,  but "Size Limit of Result Set Exceeded" message was finally avoided for my case only when I added the same parameters in HKEY_CURRENT_USER.

Thus I have got the following entries in register:

1.

[HKEY_LOCAL_MACHINE\SOFTWARE\SAP\AdvancedAnalysis\Settings\DataSource]

"ResultSetSizeLimit"="-1"

"ShowBicsSample"="True"

2.

[HKEY_CURRENT_USER\Software\SAP\AdvancedAnalysis\Settings\DataSource]

"ResultSetSizeLimit"="-1"

You may download and run the following .reg file in order to fix the issue quickly (no manual edit of register required):

1. https://www.dropbox.com/s/4k4ljhnjmfeh460/SAP_BO_AA_File_size_limit_removal%28HKLM%29.reg

2. https://www.dropbox.com/s/g1241r4hw7y88nj/SAP_BO_AA_File_size_limit_removal.reg

Good luck!

K.

maagp
Employee
Employee
0 Kudos

Hi Raja,

It is possible that the registry value isn't existing yet (the default value of the setting is also used when the registry value isn't existing). But that's no problem as you can create the necessary keys and the value by your own.

Therefore create the necessary folders that aren't existing yet (Create new "key") and afterwards create a new "string value" that is named "ResultSetSizeLimit".

You'll find more information about the ResultSetSizeLimit in following notes:

SAP Note 1656983: Result set size limit exceeded

SAP Note 1662968: Clarification on setting ResultSetSizeLimit in Analysis Office

I hope this information helps to solve your problem.

Best regards,

Patrik Maag

Analysis Office Development, SAP Walldorf