SAP Business Objects - Advanced Analysis for excel

[Former Member]

Hi All,

Need your help here. No luck with the below issue since a month.

Getting an error message in excel -  Size limit of result set exceeded when Created a query from info provider using advanced analysis for excel.

after checking all the blogs and forums modified the settings in windows registry and added the below,

run -> regedit

Step 1:

Add the string "ResultSetSizeLimit"="-1" to the following key;

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

Step 2:

Windows 7 64-bit OS:

HKEY_LOCAL_MACHINE\Software\Wow643Node\SAP\AdvanceAnalysis\Settings\DataSource

"ShowBicsSample"="True"

"ResultSetSizeLimit"="-1"

But issue is still there . Please let me know if this is correct or do I need to edit any other settings.

Thanks,

Bharathi.

[Former Member]

Hi ,

There is a space between Advanced Analysis , So I removed it and my issue is resolved.

Thanks,

Bharathi.