BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

Can BOXI 4 export data >65535 rows to Excel 2007?


 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
Bee
Forum Member
Forum Member



Joined: 19 Apr 2005

Posts: 24



PostPosted: Wed Nov 02, 2011 3:00 am 
Post subject: Can BOXI 4 export data >65535 rows to Excel 2007?

Hi,

I'm now using BOXI R2 which has the WEBI limitation in exporting data to Excel (2003). It can export only 65535 rows.

For BOXI 3.x, per KB 1282984, it can overcome the 65,000 row limitation by exporting the document to multiple worksheets within the Excel Workbook. Each worksheet will be 65,535 rows long. For example, if a query returns 150,000 rows of data the resultant export to Microsoft Excel would produce a single workbook with 3 worksheets. 2 worksheets of 65,535 rows and 1 worksheet of 18,930 rows.

My question is how about BOXI 4.x? How does it do with Excel 2007?

Many Thanks in advance.

Bee
Back to top
Bee
Forum Member
Forum Member



Joined: 19 Apr 2005

Posts: 24



PostPosted: Fri Nov 04, 2011 1:56 am 
Post subject: Re: Can BOXI 4 export data >65535 rows to Excel 2007?

Hi,

Here is what SAP Tech Support told me:

1.Is there any improvement on exporting from WEBI /Crystal Reports to
Excel 2007?
-In BI 4.0 we can directly save reports to Excel 2007 format.

2.Can we export data more than 65,535 rows but less than 1 million rows
(per the Excel 2007 limitation) from WEBI /Crystal Reports to Excel
2007 in one Excel worksheet?

-Excel 2007 format has a limit of 16384 columns and 1048576 rows, so you can export a report having more than 65535 rows to excel.

3.If we need to export more than 1 million rows from WEBI/ Crystal
Reports to Excel 2007, how will it treat the data (e.g. 1 million rows
in each worksheet OR display only 1 million row and remove the rest?

-As mentioned in the above point, it has a limit of 1048576 rows so it will not take or display records more than that.

Refer to SAP Note: 1629660 - When will Business Objects support exporting to xlsx format?


Bee
Back to top
alecsandes
Forum Member
Forum Member



Joined: 03 Nov 2011

Posts: 4



PostPosted: Fri Nov 04, 2011 9:39 am 
Post subject: Re: Can BOXI 4 export data >65535 rows to Excel 2007?

Hello, I am sorry for the dummy question:

BO = Bussiness Object

XI = 11

what is 4? or 4x? how do I know which version I am using, I have the same issue.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 17760
Location: Bratislava


flag
PostPosted: Fri Nov 04, 2011 11:20 am 
Post subject: Re: Can BOXI 4 export data >65535 rows to Excel 2007?

Hi,
alecsandes wrote:
how do I know which version I am using, I have the same issue.
This sticky topic can help you:
http://www.forumtopics.com/busobj/viewtopic.php?t=149027

_________________
BO: BI 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win and Linux servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0476 seconds using 17 queries. (SQL 0.0026 Parse 0.0347 Other 0.0103)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo