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.