Skip to Content
author's profile photo Former Member
Former Member

Client Out of Memory in BEx 7.x

Hi Everyone,

I would like to ask a question that has been asked many times here. I probably also know the replies Im going to get, but Im just hoping against hope of finding a satisfactory alternative.

We have a few BEx reports here, that need to display more than 65K rows. So here are the steps we followed:

- Create these BEx queries in 7.x version.

- We also have Excel 2007 version to go with it.

- We have also installed the patch bw350gui710_6-10004473.exe

- The OS is 64 bit too.

- I've read Note 1040454 and I know there's a 750,000 data-cell limitation in the BEx reports.

- Our BEx Report has 54 columns. Somewhere I read there's a 36 column limitation (but I couldn't find a supporting Note for it)

- I was told that running the Report through RSRT is also a no-go.

- I've not yet found a Note that has a solution for this problem.

- Restriction through Selection screen is not an accepted solution for the client.

So here are my Questions:

- At the risk of being branded a bad-searcher, I'd like to ask if SAP has already come out with a fix for this issue?

- As an alternative, would an ABAP report suffice? - Im worried about Performance Issues here.

- What about BI Accelerator? Will that solve the issue?

pk

PS: Any other alternative solutions?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Feb 01, 2012 at 11:22 AM

    No chance 😊

    You need to explain to the customer that BEX reporting is not designed for mass data transfer.

    65K rows = 35 columns will never work. BIA wont help either as BIA is is good at searching through a large number of records but will also not return large volumes like this.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Kishan,

      As you are talking about 65K rows, you might be using hierarchies in rows and APD will not support hierarchies.

      If ABAP has worked for you, could you direct me on how proceed with that.

      We are facing the same issue and the workbooks are failing with "Client out of memory" message. User needs multiple SAP views consolidated into a workbook.

      Regards,

      Jagadish V

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.