BEx Analyser Error

[Former Member]

Dear all,

we have excel 2007 installed. Each time I run my BEx Query I got this error message:

I am running a query whose result is too largeand does not fit into the main storage of the computer.

Connection to BI-Server is broken, Query result is not indicated.

Can some one help:

Is it that I have to get some frontend support package loaded up?

we are using BI 7.0.

Thanks a million.

caaron

[sathiendiran_balu · Accepted solution]

Hi ,

This is a front end issue , Download service package 9 for Bex from service.sap and install it , it will resolve the issue

Regards,

Sathya

[former_member186696]

Hello,

You have to be aware about the BEx Analyzer limitation.

BEx Analyzer cannot deal with more than 1.2 giga (around 750 000 cells) or 65 000 rows (EVEN with Excel 2007/2010).

Review note: 1040454 - Front-end memory requirement of the BEx Analyzer

If you are respecting this limitation, try to update to latest version of BI addons:

http://service.sap.com/swdc

-> Download

-> Support Packages and Patches

-> Entry by Application Group

-> BI ADDON FOR SAP GUI

-> BI 7.0 ADDON FOR SAP GUI 7.10

-> BI 7.0 ADDON FOR SAP GUI 7.10

-> Win32

-> bi710sp13_1300-10004472.exe

Kind regards,

Edward John

[Former Member]

What OS is running and how much RAM memory you have in the client PC? It looks to me more a hardware limitation than a software issue... Make sure you check these two things... Then try to run the same report in a PC with more resources and see if you get the same error... That would confirm the issue...

[Former Member]

Hi,

Can you please check whether the message is coming because the system is getting timed-out before the entire result set comes up.

[former_member209032]

Hi,

If the error is happening for a particular query then try to restrict the query output by using suitable filter. Further check the dump in ST22 for more details.

Regards,

Raghavendra.