Skip to Content
0

How to return huge rows say 1 million using WebI report?

Dec 21, 2016 at 06:47 PM

62

avatar image

I am stuck with a simple problem. I have a report which extracts 10 years sales data in WebI. This reports takes approx 45 mins to run which is fine as the data volume is pretty high. when this reports run data is displayed in the browser but when I try to save this report the excels is blank.

Can any one has any idea on this? As I know when data volume is high data is exploded into different tabs in excels. Can anyone confirm this.

Your help will be really appreciated. Thanks in advance !!

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

AMIT KUMAR
Dec 21, 2016 at 09:04 PM
0

Try to schedule the report in default location with excel or send to file system and see...

Other option try to save the report output in CSV archive and check.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hi Amit,

We don't have permission to use file system due to security purpose. I am trying to save this report as excel but no data is coming.

0
Michael Hill Dec 21, 2016 at 11:12 PM
0

The answer is that a webi is an analysis tool and not and ETL tool. A user can not analyze 1 mil rows on a screen, additional filtering is required.

So use Data Services and get an extract to an excel file if thats what you need.

Mike

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Michael thanks for your reply.

Yes I am trying to export this report into the excel but when I save this report in excel it gets saved with blank fields. I mean no data is present in the excel file.

Any suggestions on this?

0
Kuldeep Ghosh Dec 21, 2016 at 11:58 PM
0

For such a huge record I would not recommend to use reporting medium. You can either use what Michael recommended or if this is relational database use the sql to export the data to .csv format. Excel wont be able to cope up with this much data.

Share
10 |10000 characters needed characters left characters exceeded
Sateesh Kumar Jan 05, 2017 at 02:41 PM
0

Hi Sandeep ,

which version of BO and Excel you are using ?

check Maximum Character Stream Size (MB) and Binary Stream Maximum Size (MB) in CMC->Webi proc sever properties . Make sure you have set required size for these parameters . Ex 50 MB or so .

You can also try scheduling as text/csv to check data is causing the issue or formatting . If this gets success , then check as Excel with easy data processing option checked .

Thank you

Sateesh

Share
10 |10000 characters needed characters left characters exceeded