SAP Knowledge Base Article - Public

1382035 - How to enhance the performance of Crystal Reports report based on Business Views with LOV in the report?

Symptom

  • Crystal Reports report with List of values (LOV) based on Business Views takes long time to refresh
  • How to enhance the performance

Environment

  • BusinessObjects Enterprise XI Release 2 Service Pack 2
  • Crystal Reports XI Release 2 Service Pack 2

Cause

  • If there is a cache miss within the Cache Server for the prompt page, then the prompt engine is activated and it rebuilds the prompt page by accessing the LOV used on that prompt page.
  • LOV are cached separately from the prompt page. The cache timeout value for each LOV object is controlled from the Edit List of Values dialog within the Business Views Manager.
  • The default value stored in Oldest on-demand data given to a client (in minutes) is 0.

Resolution

  1. Set the LOV setting 'Oldest on-demand data given to a client (in seconds)' value to the largest possible value.
  2. Ensure the server level setting for 'Oldest on-demand data given to a client (in minutes)' is equal to or greater than the largest LOV setting.
  3. Schedule LOV only when necessary.
  4. For more information on Performance Tuning read the attached document.

    

Keywords

Parameter Prompt.slow refresh , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

SAP Crystal Reports XI R2

Attachments

Dynamic, Cascading Prompts Performance Tuning.pdf