Help Re-write aggr expression - faster application

[Anonymous]

Hi,

Need help re-write this to an easier expression;

((sum(aggr(

sum(kWh) * sum(aggr(sum(Price), DateJoin,Pricearea,CustomerKey)) , DateJoin, Year,Month, Pricearea,portifolio,CustomerKey))    ) / sum(kWh))*100

as it is now, it slows down my application too mutch. Any suggestion to solve this?

[sunny_talwar]

Would you be able to share a sample to test out few possibilities?

[marcus_sommer]

It's not surprising that a nested aggr-function is slow. Are you sure that you really need it?

Beside this quite often determined the datamodel how performant gui-calculations could be. Therefore a different data-structure could be quite useful - fo example to put kWh and Price within one table and avoiding the aggr-stuff. Further if your datamodel is build with link-tables I suggest to rethink the entire datamodel.

- Marcus