I have a large report with more than one tab. When I switch between different tabs, recomputing takes sometime and the report is loaded after few minutes.
Is there any way to avoid the re-computing… ?
Thanks
nandita (BOB member since 2004-06-22)
I have a large report with more than one tab. When I switch between different tabs, recomputing takes sometime and the report is loaded after few minutes.
Is there any way to avoid the re-computing… ?
Thanks
nandita (BOB member since 2004-06-22)
The computation time is slow because BusinessObjects has to calculate all of the local report formulas/local report variables/filters.
So – you can speed it up by removing any variables, and especially formulas that may no longer be needed. In particular, if you (or whoever developed the report) is in the habit of using the formula bar, and making gradual modifications to the formula – every version you ever tried is still there, being calculated, even if it isn’t needed.
If you ever attended any of Dave Rathbun’s “Variables and more Variables” presentations at a user conference, you would know that the way to go is to use a variable instead – because when you modify it, the old “version” isn’t left there to be re-calculated (but not used).
Alternatively, when you are working on the report, you can put each report tab into structure mode – it will display the structure of the document without the values – and will not have to calculate them all.
Anita Craig (BOB member since 2002-06-17)
I am afraid not. Be sure to remove any unused variables. There are also some suggestions ( try searching on compute time ) such as this thread Computing Data..... that offers some suggestions to reducing the compute time
Michele Pinti (BOB member since 2002-06-17)
Which version are you using?
Also I find that for a large report, one solution is to restrict the query to say a few rows.
That way you can still edit it and add new local vars etc.
Then when the report is completed, refresh it with the whole dataset.
Although this is only handy if you’re writing the reports, still not much help to the end user that has to switch tabs etc
Reporter Bloke (BOB member since 2004-05-20)