3 Replies Latest reply: Jun 22, 2011 9:59 AM by Martina Brenner RSS

    Improving expression for Performance reasons

      Hi Guys,

      I have a query I am hoping someone can help me out with.

       

      I have a chart in an application that has multiple expressions for different measures. I have about 7 expressions and the content of the expressions is pretty similar to the script below

       

      Sum({<STAT = {'CNS'}, LAST_DATE={'Y'},

      PRODUCT = {'C', 'L'},

      AREA ={'Usa', 'China', 'England', 'Wales', 'Italy'}

       

      >} VALUE)

       

       

      The problem I have is that the chart is really slow because of the excess use of set analysis and multiple expressions.

       

      Can someone please kindly suggest a way for me to do something with the expressions or possibly move some logic into the script to improve the performance of this chart?

       

      Thanks