on 07-31-2012 11:04 PM
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.
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.