.rep file growing from 600k to 400 MEGABYTES

Hello MrT,

First of all, welcome to the BusinessObjects Board :smiley:

For your problem of report, the 1st idea coming to my mind is about the report itself: have you checked in the data provider that you don’t get duplicate rows?

Have you also checked in the cube if you really have a lot of data loaded?

If none of the causes above can explain your problem, then:
1 - how much data will you get if you use the SQL of your data providers in applications like TOAD, SQL navigator…?
2 - Is it long and hard to recreate the report(s)?
3 - In a recent post (1 or 2 weeks old) in this ā€œreporterā€ section, someone has explained how to get rid of ā€œphantomā€ data from Data Providers. You can perform a search to find it. Edit: So I supposed it would be a little tough for you to find it so here is the link (see explanation from ā€œkoolā€): https://bobj-board.org/t/47504.

Good luck.


elallema :fr: (BOB member since 2004-12-23)