1 Reply Latest reply: Sep 5, 2011 1:29 AM by BlackRockS RSS

    how can I enhance the performance of the qvw

      I have a qvw with many data,about 1,000,000data.

      the group leader want to see the aggregation of the data.and the department leader want to see the detailed.

      how can I deal with this problem.

      thanks

        • Re: how can I enhance the performance of the qvw

          Hi,

           

          You can do the following to improve the performance.

           

          1. While final load just load the columns you required.

          2. Create 2 separate dashboards 1 for aggregation and one for detailed data.

          3. Create QVD with raw data and process the data loaded from QVD's and then created another version of QVD's with aggregated or any other additional columns required.

          4. Now use the final qvd's created above in the 2 separate dashboards 1 for aggregation and another for Detailed data.

           

          Cheers.