How a webi report to saver as excel when the rows exceed it's limits?

[Former Member]

How a webi report to saver as excel when the rows exceed it's limits? Try to save a webi report to my computer as excel, however, the row exceeds the excel limits, so only partial saved. Is there a marcro or sdk, or any ways to save the whole data to one or more than one excel files?

[Former Member]

Hi,

Just FYI. Business Objects XIr2 (SP1-SP4) doesnot support excel 2007.It supports only excel 2000 and excel 2003.

XI3.0 supports excel 2007.

[Former Member]

I would recommend putting the data on multiple tabs and use filters to logically define the data on each tab.

For Example, if your data were representing Work Orders opened over the last three years, you could create 3 tabs filtered on each year.

hope that helps!

Mathieu

[Former Member]

The report contains several tabs already, the first one shows all the allocation inventory. The second tab sales detail is the one has issue. I duplicated this report to separate report so I can apply category into two group, so basically have two reports. But since this is an excetive report, it doesn't look good have too many separate reports.

[Former Member]

If my assumption is right, you are able to export the entire data into a csv file but are not able to view it in excel because of its 64K row limitation. You may want to try using Excel 2007(the limitation is 1million rows) or IBM Lotus Symphony (Not sure what the limitation is) to open your csv file

[Former Member]

If this is an executive level report - you may wish to summarize the data. I have yet to work with an executive who actually wants to see 65,000+ rows of data in nearly 10 years of writing reports. Massive amounts of data like that are usually next to impossible to work with anyways. Executives tend to love charts and totals rather than a dump table with tons of rows.

Excel 2007's file format (.xlsx) will support more than the 65,000 rows but as Jai mentioned above, you'll need to dump the data to .csv first because WebI doesn't seem to have the ability at this point yet to export to the new MS file format.

[Former Member]

Thanks for all the response. Yes, the first tab is a total summary report, but in additional we show detail in different levels in other tabs as well. The sales detail is the one over the limit. We are using office 2003 now. That's why I pull the sales detail to a different report to save as two workbooks in case they want to see the detail for now.

[amrsalem1983]

the only solution for this issue,

just try to divide the data into more tabs as much as you can,

you may use some "quick filters" to do that,

like if you are showing data for many stores,

you can select 10 stores in tab, and then other 10 stores in tab ,,,,, etc

use quick filter to finish this issue between tabs.

good luck

Amr

[Former Member]

Ha, that's a cheesy way to do itu2026thanks!

[Former Member]

Today, if report contains > 65,536 rows than it is cut off, this is an Excel limitation. The only way around that is to save data as CSV however this is not the same as the cube data is dumped as is. In the very near future, we will have the feature that if the report contains > 65,536 rows then continue on a new report sheet. thx

[Former Member]

when I dowload to my computer as csv, when I opened it, it's still cut off at the excel limits.