Skip to Content
0
Former Member
May 14, 2007 at 02:31 PM

Performance on Bookmarked Reports and Timing Out problems

10 Views

We have a report set up with an interval variable on 0CALMONTH from 01.2007 to 12.2007 (even though return values for 0CALMONTH stop at 05.2007) with an additional filter set up using 0CALDAY equal to a run date (of say) 14.05.2007.

Does the variable on 0CALMONTH have an impact on report performance given the run date? The report is consistently timing out and when we run transaction ST22 it suggests that SELECT * statements are being used. RSRT doesn't pick anything up.

Does any one have any ideas?

NB The report is being accessed via a Bookmarked version of the report and no changes have been made to the report in BEx nor have any changes been made to the users log-on.

I'd be grateful for your thoughts and input.