2 Replies Latest reply on Jun 1, 2012 2:19 PM by MuRam

    performance tuning

    Raa.BI
      Hi Team,

      what are consedarations we have to take If we want to improve the performance of the report in obiee.

      Thanks
        • 1. Re: performance tuning
          MuRam
          Hi,

          -You can use hint on RPD-->Physical Layer-->Physical table
          Follow-

          http://prolynxuk.com/blog/?p=173
          http://businessdecisionsystems.com/blog/?p=486
          http://www.iwarelogic.com/2010/06/performance-increasing-obiee-724/
          http://gerardnico.com/wiki/dat/obiee/hint

          -Enable cache
          -Implement event pooling

          Refer the below for performance tuning-
          http://www.rittmanmead.com/files/biforum2011/Heljula_DBTuning.pdf


          Please let me know if my understanding above is wrong.
          Hope this helped/ answered.

          Regards
          MuRam
          • 2. Re: performance tuning
            MuRam
            Hi,

            Also you can also do the below things-
            - Aggregate tables
            - Turning off logging
            - Constructing result using where clause
            - Limiting Number of Initialization block
            - Setting Query limits
            - Modeling Dimension Hierarchies Correctly
            - Setting NQSConfig Parameters

            Details in below link-
            http://www.oraclebidwh.com/2010/02/performance-tuning-in-obiee/
            http://obiee101.blogspot.in/2010/01/obiee-performance-tuning.html



            Please let me know if my understanding above is wrong.
            Hope this helped/ answered.

            Regards
            MuRam
            1 person found this helpful