Skip to Content
0
Former Member
Mar 16, 2015 at 08:11 AM

Size limit of result set exceeded+Analysis for Microsoft Office

1229 Views

Hi gurus,

I have installed new microsoft excel-2013 latest version and Analysis for microsoft office version 1.4.10.3295.When i take a report with more than 65000 rows,i am getting an error of "Size limit of result set exceeded" every time.I haven't uninstall old Bex Analyser,so i am still using that and there is no error for that.

I got one useful answer in one thread,like registry editing ()but i am not able to find in my client PC.Is this settings in the server side?.

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

"ShowBicsSample"="True"

"ResultSetSizeLimit"="-1"

If it in the client side,this is not a solution for all business users (we have around 2000 Analysis users).

Is there a permanent solution for this?Please help anyone?

rgds,

aby