6 Replies Latest reply: Feb 20, 2015 7:19 AM by Diwakar Nahata RSS

    Performance issue with aggr function

    Diwakar Nahata

      Hi All,

       

      I am facing some severe performance issues while using aggr function in a straight table.

      I am calculating a Product Share column in its Category when the Product is selected using aggr function as below:

      Sum(Sales) / aggr(NODISTINCT Sum(Sales),Product_Category)

       

      After putting this expression, the RAM consumption spikes up exponentially and consumes all the available RAM on my local.

      I am developing on my local with a reduced data of 40 MB, and without this expression the total RAM consumption is 300 MB.

      After adding this expression, the RAM consumption goes to 2500 MB and i have to restart my system.

       

      Are there any alternatives how we can rewrite this expression.

       

      Regards,

      Diwakar