We have a query with ten calculated key figures and all of these have exception aggregation of summation at material level. Currently for just one plant the query is taking 8 minutes of time which is too bad.
These 10 CKF's caluculate different types of stock values..all these have summation as exception aggregation. The price is calculated on the fly by using replacement path attribute value. Any suggestions on how to increase the performance of the query or any other approach to handle this scenario.
stock value 1 = quantiy1 * price1.
stock value 10 = quantiy10 * price10.
Please let me know if you need more info.