Skip to Content
avatar image
Former Member

Performance tuning

My Report is Taking to much time for Opening.

How can we do the Performance tuning at Report Level and Universe Level.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Mar 27, 2012 at 12:35 PM

    Hi,

    Here are the few points for Performance tuning at Universe level in BO:

    << Universe Level >>

    • Modifying the Array Fetch parameter (advanced parameters window of connection. Just edit connection in Universe and click twice Next. or we can control this parameter in CS.CFG file. Bigger number = faster query but it should be set up according to capacity of memory)
    • Allocating table weights
    • Using shortcut joins
    • Using aggregate functions
    • Creating and using aggregate tables
    • Minimizing usage of derived tables

    Here are the few points for Performance tuning at report level in BO:

    • If you insert the Page Number/TotalNumberOfPages cell or the TotalNumberOfPages cell into a large report with many pages, Web Intelligence takes longer to return the data to the report.
    • Opting for Refresh At-Will over Refresh-On-Open
    • Not associating the List of Values (LOV) Objects which you don't want to use as a prompt
    • Using universe Condition Objects, try to restrict/filter the data at universe end rather than at the report end.
    • Keeping Complex Calculations at universe side.
    • Minimizing usage of Report variables/formulas
    • Auto height and auto width on report cells sucks in resources. setting cell sizes to fixed increases performance.
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 27, 2012 at 02:53 PM

    Hi,

    If you have covered up points suggested by Ravi and still have the same issue then you should also consider server side tunning process. The following links may be very helpfull in this regard.

    http://dhigtana.wordpress.com/2011/07/14/performance-tuning-web-intelligence-processing-servers/

    http://www.dallasmarks.org/blog/2011/11/sizing-the-adaptive-processing-server-in-bi-4-0/

    Regards,

    Shakeel

    Add comment
    10|10000 characters needed characters exceeded