Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Would you be able to share a sample to test out few possibilities?
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