4 Replies Latest reply: Aug 4, 2014 1:10 AM by Sagar Tippe RSS

    How to improve the reports performance in dashboard pages?

    2725158

      Hi All,

       

      I am having the dashboard " Sales Dashboard".

      In that dashboard i am having 4 dashboard pages

      1.management

      2.Rep

      3.Account and

      4. Product

      In that dashboard pages, some reports are opening very slowly. Please any one can help me quickly.

       

      And more thing, in that reports am not able to find out which column is coming from which table?

        • 1. Re: How to improve the reports performance in dashboard pages?
          deepika walia

          Hi,

          Please check following points:

           

          • When you open the dashboard page, first figure out whether Prompt or Report is taking more time.
          • If it is prompt, check for any multi select prompts which are taking time to load all values.. (best practice is set default values).
          • If Report is taking longer time, set some default filters and query for just couple of records and check the report performance.
          • Take physical SQL from the session log (if SQL is not generated check for log level whether it is less than 2).
          • Run this Physical SQL in the TOAD or any SQL Editor.
          • Check Explain plan for the cost of the query.
          • Hash Joins/Cartesian Joins are always kills performance.
          • Some-times, Force Inner-join also helps to force the tables to have inner-join between two tables.
          • Check are there any “Full Table Scans” happening instead of Index Scan.
          • Consult your DBA for the Stats.

           

           

          Thanks

          • 2. Re: How to improve the reports performance in dashboard pages?
            2725158

            Thank you Deepika for your quick reply.

             

            I have observed here, my reports are taking longer time. If i want to check the joins i am not able to find out which column is coming from which table?

            there are lot of sub queries in my Physical Sql. please help me. If u want i can post my physical sql here.

             

            Thank you

            • 3. Re: How to improve the reports performance in dashboard pages?
              deepika walia

              Pls post query over here.

              • 4. Re: How to improve the reports performance in dashboard pages?
                Sagar Tippe

                Hi,

                 

                1. To check table names from which data is fetched out, you can check the query log file nquery.log or simply go to Administration > Manage Sessions. There check your particular Physical SQL and Logical SQL too. (Set your LOG LEVEL to 2)

                 

                2. If your are aware about Aggregate tables, use it.

                 

                3. Use Cache management to improve your performance