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

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Jul 23.

Compress a Business Object Report


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
binaykumarkhetan
Forum Member
Forum Member



Joined: 10 Nov 2004

Posts: 6
Location: mumbai


flag
PostPosted: Wed Dec 14, 2005 3:08 am 
Post subject: Compress a Business Object Report

I am facing problem with BO Report? The BO report is approx 80000 KB so when I Refresh the report and switch from one tab to another it takes lot of time (one full day). Can we compress a Business Object Report so that it can be faster.
Back to top
Andreas
Forum Advocate
Forum Advocate



Joined: 20 Jun 2002

medal_silver.gif*2medal_gold.gif
Posts: 17009
Location: *** BEEP ...Dreaming of Africa... leave No message ; ) BEEP ***


flag
PostPosted: Wed Dec 14, 2005 4:35 am 
Post subject: Re: Compress a Business Object Report

A) The file size seems to be way out of bound.. 80 MB eek.gif

B) Check if your universe measures are defined properly using a SQL aggregate function thereby inferring a SQL Group By clause, which in turn will reduce the number of resulting rows.

C) How many pages does your Business Objects document have?

D) Could it be that you deleted a data provider without purging it first? This in certain versions of Business Objects might leave you with a b l o a t e d file. Remedy: re-crate the doucment form scratch or use the copy data provider tool available in BOB's Downlaod section.

_________________
Follow me on Twitter
Reading "Hard Choices" by Hillary R. Clinton
Focusing on Data Visualization, SAP BI 4.x, SAP connectivity, Data Modeling, and SAP HANA Certified Associate
Back to top
Anita Craig
Forum Groupie
Forum Groupie



Joined: 17 Jun 2002

Posts: 8541
Location: Palo Alto, California, U.S.A.


flag
PostPosted: Wed Dec 14, 2005 8:34 pm 
Post subject: Re: Compress a Business Object Report

Also, take a look at our Reporter FAQ entry: Why is my report so slow?.
_________________
Anita Craig Image link
Institutional Research & Decision Support
Stanford University Image link
____________________
Search is Your Friendô
Back to top
Nishant Shrivastava
Senior Member
Senior Member



Joined: 26 Sep 2005

Posts: 54
Location: Columbia, SC



PostPosted: Wed Dec 14, 2005 8:52 pm 
Post subject: Re: Compress a Business Object Report

Did you purge all the data providers before publishing the report to infoview?? Since your report size is way too high it might be the case that data from the previous refresh is still there on your report.
_________________
Nishant Shrivastava
__________________________
Exceed Development Team
Computer Sciences Corporation
Back to top
Joealyche
Principal Member
Principal Member



Joined: 29 Feb 2012

Posts: 339



PostPosted: Wed Mar 18, 2015 8:33 am 
Post subject: Re: Compress a Business Object Report

So to answer this question...

Can a WEBI report being scheduled be compressed?
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 12999
Location: London


flag
PostPosted: Wed Mar 18, 2015 8:48 am 
Post subject: Re: Compress a Business Object Report

You could possibly get it to write to a zip file, using a program object?
The one thing you would notice that even zipping a report up does not make hardly any difference to its size.

As for the OP's report, it must be one of the worst designed reports in the entire universe, lol, to get to that size eek.gif .

_________________
Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
Joealyche
Principal Member
Principal Member



Joined: 29 Feb 2012

Posts: 339



PostPosted: Wed Mar 18, 2015 9:33 am 
Post subject: Re: Compress a Business Object Report

Thanks, I was thinking it wouldn't save that much.. but then thought that if I send it out as a .CSV that may compress further.
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 12999
Location: London


flag
PostPosted: Wed Mar 18, 2015 10:07 am 
Post subject: Re: Compress a Business Object Report

Joealyche wrote:
Thanks, I was thinking it wouldn't save that much.. but then thought that if I send it out as a .CSV that may compress further.


Ah, CSV you may have a lot more joy with icon_smile.gif.
Its formatted ones that don't compress as well in my experience.

_________________
Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
Joealyche
Principal Member
Principal Member



Joined: 29 Feb 2012

Posts: 339



PostPosted: Wed Mar 18, 2015 10:33 am 
Post subject: Re: Compress a Business Object Report

One thing about the CSV though. If I am removing columns within the report or am using any report filters then CSV will not show this.

In CSV I would get everything coming out of the SQL...
Back to top
Mak 1
Forum Aficionado
Forum Aficionado



Joined: 06 Jan 2005

Posts: 12999
Location: London


flag
PostPosted: Wed Mar 18, 2015 11:16 am 
Post subject: Re: Compress a Business Object Report

Joealyche wrote:
One thing about the CSV though. If I am removing columns within the report or am using any report filters then CSV will not show this.

In CSV I would get everything coming out of the SQL...


Correct, depends on the requirement, of course.

_________________
Business Objects Versions 4,5,6, XI R2, 3.2, 4.1 SP3
Oracle, SQL Server, Sybase, Netezza, SAP BW.

Red Adair: "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur."
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  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.0475 seconds using 18 queries. (SQL 0.0033 Parse 0.0347 Other 0.0095)
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