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?