How to display more than 65k lines in BEx Analyzer reports

[Former Member]

Hi All,

we have a report with hierarchies, these days one of the node got value more than 65k and when i tried to expand that hierarchy node it is struck there for long times, and sometimes it is giving message exceeding maximum no. of rows. I read few threads regading this before and found solutions as

1. with some VBA code in excel

2. web report

please anybody can explain me in detail how to achieve this im not aware of writing VBA code where & how?

not too familiar with web reports too.

Thanks in advance

Robyn.

[former_member184494]

Robyn,

Excel has the display limitation of 65K rows that you cannot overcome....

however

1. We reports

Web reports do not have any limitation and you can display the same using a web template and acheive the desired result without losing any rows

2. VBA

You watch out for the number of rows returned and split at say 60K rows and get the rest of the rows into the net worksheet... this can be done using the APIs defined in SAPBEX.XLA....

Arun

Hope it helps....

[Former Member]

Hi Arun,

where can i check the API's in that SAPBEX.xla, it opened up an excel sheet but i don't how to check that API's and change that figure.

Please let me know how can i do that?

Thanks

Robyn.