how to display more than 65535 rows in ms excel 2007 with Bex 3.5.

[Former Member]

can ant 1 please provide solution for result set that display query output in single run more than 65535 rows,it is our business requirement dealing more than 35 lac consumer in delhi electricity bord

Regards:

satish

[Former Member · Accepted solution]

Hi satish,

In Excel, every workbook has 255 columns and 65,526 rows. These values are fixed and cannot be changed. If you need more rows, you might want to consider using a database (such as Access) or another spreadsheet (Quattro Pro can handle a million rows) for data storage. In most cases, you probably don't need to work with all of your data at once. You'll usually need only a subset of your data. You can use Excel's Data, Get External Data command to query the database and bring in only the records you need.

Regards,

Marasa.

[Former Member · Accepted solution]

thanks, but i thing if ms exel supports upto 2.40 lac rows at once then there must some method to get results more than 65535 rows at once.in our business if we can then very helpful for 33 divisons each have around 1-2 lac consumer

Regards:

satish

Edited by: satishsmse on May 17, 2011 4:12 PM

[Former Member · Accepted solution]

In our project we had the same requirement. The query in BI7 had a limitation which doesnt allow more than 350000 cells. A higher value could be set but was not feasible. Therefore we managed creating the queries in 3.5 and running them not with the Java Stack but using the ABAP stack with Excel 2007.

I shall provide more details on the solution tomorrow when in the office.

regards,

AHS.

[former_member211907 · Accepted solution]

Dear satishsmse,

Whilst Excel 2007 and 2010 do indeed offer 1,000,000 rows for your use, and it is possible for you to report that many rows out of Bex Analyzer 7. That does not mean it is a good idea.

The key thing to remember as you review your customer's requests is this....

BW is an Analytic tool. Not a 'data dump' tool. Write an ABAP report if you wish to extract enormous quantities of information to an external analytic tool or documentation purpose. Do NOT do that sort of thing in BW, it violates good design architecture rules.

[former_member366279]

Hi Satish,

There should be no method to do that.

If you need to display more lines, you may try Java Web.

However from the memory point of view, it's not recommended to display too many rows at once.

You may consider adding some filters before doing the drilldown.

Regards,

Patricia